MySQLDump problem

MySQLDump problem

Postby 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
Hostonet
 
Posts: 14
Joined: Thu 31 Mar 2005 18:17
Location: Ham-sur-Heure / Nalinnes

Postby Alexey » Tue 11 Jul 2006 09:22

We do not experience this problem with the latest version of MySQLDirect. What version do you use?
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby Hostonet » Tue 11 Jul 2006 11:02

Hi,

I use the version 3.50.11 Professionnal

Image

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
Hostonet
 
Posts: 14
Joined: Thu 31 Mar 2005 18:17
Location: Ham-sur-Heure / Nalinnes

Postby Alexey » Tue 11 Jul 2006 11:29

What is your hardware?
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby 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
Hostonet
 
Posts: 14
Joined: Thu 31 Mar 2005 18:17
Location: Ham-sur-Heure / Nalinnes

Postby 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.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby 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
Hostonet
 
Posts: 14
Joined: Thu 31 Mar 2005 18:17
Location: Ham-sur-Heure / Nalinnes

Postby 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.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby Hostonet » Thu 03 Aug 2006 14:04

Hi,

Sorry for delay.

I have send the mail

Thanks,

Didier Lombet
Hostonet
 
Posts: 14
Joined: Thu 31 Mar 2005 18:17
Location: Ham-sur-Heure / Nalinnes

Postby Alexey » Fri 04 Aug 2006 14:52

We haven't received your mail. Please resend.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby Hostonet » Sat 05 Aug 2006 17:06

Ok, now it's done
Hostonet
 
Posts: 14
Joined: Thu 31 Mar 2005 18:17
Location: Ham-sur-Heure / Nalinnes

Postby 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
Hostonet
 
Posts: 14
Joined: Thu 31 Mar 2005 18:17
Location: Ham-sur-Heure / Nalinnes

Postby Alexey » Mon 20 Nov 2006 07:20

We are planning to release MySQLDirect .NET 4.0 in a month.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby Hostonet » Mon 22 Jan 2007 16:05

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

:cry: :cry: :cry:
Hostonet
 
Posts: 14
Joined: Thu 31 Mar 2005 18:17
Location: Ham-sur-Heure / Nalinnes

Postby Alexey » Tue 23 Jan 2007 09:00

And what about MySqlDump.Backup(Stream stream) method?
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43


Return to dotConnect for MySQL