Devart Forums

Posted: **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

Posted: **Tue 11 Jul 2006 09:22**

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

Posted: **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

Posted: **Tue 11 Jul 2006 11:29**

What is your hardware?

Posted: **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

Posted: **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.

Posted: **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

Posted: **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.

Posted: **Thu 03 Aug 2006 14:04**

Hi,

Sorry for delay.

I have send the mail

Thanks,

Didier Lombet

Posted: **Fri 04 Aug 2006 14:52**

We haven't received your mail. Please resend.

Posted: **Sat 05 Aug 2006 17:06**

Ok, now it's done

Posted: **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

Posted: **Mon 20 Nov 2006 07:20**

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

Posted: **Mon 22 Jan 2007 16:05**

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

Posted: **Tue 23 Jan 2007 09:00**

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

Devart Forums

MySQLDump problem

MySQLDump problem