MySQLDump problem

Hostonet · Post by **Hostonet** » Sun 09 Jul 2006 22:46

Hi,

When I backup any table with more than 50 Mb of data the mysqldump throw an error : System.OutOfMemory.Exception

Can you provide to me a solution ?

Thanks,

Didier Lombet
Hostonet

Alexey · Post by **Alexey** » Tue 11 Jul 2006 09:22

We do not experience this problem with the latest version of MySQLDirect. What version do you use?

Hostonet · Post by **Hostonet** » Tue 11 Jul 2006 11:02

Hi,

I use the version 3.50.11 Professionnal

At this time all table is not backuped !

List of table :

phpbb_annuaire_cat
phpbb_annuaire_comment
phpbb_annuaire_lien
phpbb_annuaire_vote
phpbb_auth_access
phpbb_banlist
phpbb_categories
phpbb_chatbox
phpbb_chatbox_session
phpbb_config
phpbb_confirm
phpbb_disallow
phpbb_forum_prune
phpbb_forums
phpbb_groups
phpbb_newshr
phpbb_newshr_config
phpbb_newsvrt_lrg
phpbb_newsvrt_lrg_config
phpbb_posts
phpbb_posts_text
phpbb_privmsgs
phpbb_privmsgs_archive
phpbb_privmsgs_text - Partialy backuped

No backup because System.OutOfMemoryException
phpbb_ranks
phpbb_search_results
phpbb_search_wordlist
phpbb_search_wordmatch
phpbb_sessions
phpbb_sessions_keys
phpbb_shout
phpbb_smilies
phpbb_themes
phpbb_themes_name
phpbb_topics
phpbb_topics_watch
phpbb_user_group
phpbb_users
phpbb_vote_desc
phpbb_vote_results
phpbb_vote_voters
phpbb_words

Total Size of dataBase : 197,6 Mb
Number of rows : 3 439 535 rows

Thanks,

Didier Lombet
Hostonet

Alexey · Post by **Alexey** » Tue 11 Jul 2006 11:29

What is your hardware?

Hostonet · Post by **Hostonet** » Tue 11 Jul 2006 13:26

Hi,

2 CPU's OF INTEL XEON HT 2.8 Ghz with 2 Gb RAM DDR.
2 Hard Drive with 120 Gb mount in RAID 0.

Thanks you,

Didier Lombet
Hostonet

Alexey · Post by **Alexey** » Wed 12 Jul 2006 06:53

Please make a backup of your table with only one record inside and send it to the address provided in the readme file.

Hostonet · Post by **Hostonet** » Sun 16 Jul 2006 16:19

Alexey wrote:Please make a backup of your table with only one record inside and send it to the address provided in the readme file.

All tables with one record for each table or just one table with one record ?

Sorry for this question but my english is poor and I don't speak it fluently.

Thanks,

Didier Lombet
Hostonet

Alexey · Post by **Alexey** » Mon 17 Jul 2006 07:41

Your English is alright for being supported.

When I backup any table with more than 50 Mb of data the mysqldump throw an error : System.OutOfMemory.Exception

Send the definition of the table if you are sure that backing it up would definitely cause the error.

Hostonet · Post by **Hostonet** » Thu 03 Aug 2006 14:04

Hi,

Sorry for delay.

I have send the mail

Thanks,

Didier Lombet

Alexey · Post by **Alexey** » Fri 04 Aug 2006 14:52

We haven't received your mail. Please resend.

Hostonet · Post by **Hostonet** » Sat 05 Aug 2006 17:06

Ok, now it's done

Hostonet · Post by **Hostonet** » Fri 17 Nov 2006 20:15

Oleg - by mail wrote:Database schematHello,

We reproduced the OutOfMemoryException in MySqlDump. This behavior caused by the class design (dumping data into the string). We plan to add streaming support for MySqlDump in the next versions. To avoid problem with current build try to dump largest tables data separately.

Best regards,
Oleg Yaroshevych

Can you tell me when it's done ?

It's long , very long ...

Thanks,

Didier Lombet

Alexey · Post by **Alexey** » Mon 20 Nov 2006 07:20

We are planning to release MySQLDirect .NET 4.0 in a month.

Hostonet · Post by **Hostonet** » Mon 22 Jan 2007 16:05

In the MySQLDirect .net 4 beta the streaming support is not implemented

Alexey · Post by **Alexey** » Tue 23 Jan 2007 09:00

And what about MySqlDump.Backup(Stream stream) method?