Bigdump stop on 32

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
Frederick A Greene
Forum Newbie
Posts: 5
Joined: Sat Mar 12, 2011 2:22 am

Bigdump stop on 32

Post by Frederick A Greene »

Hello everyone i am trying to upload database to my mysql using bigdump. but after 32% it's stop. what is problem. ? please help me thanks.
User avatar
John Cartwright
Site Admin
Posts: 11470
Joined: Tue Dec 23, 2003 2:10 am
Location: Toronto
Contact:

Re: Bigdump stop on 32

Post by John Cartwright »

I think it was because the stars were aligned at just the right time, which caused an abrupt stop to all data transfer electrodes temporarily.

Seriously, how do you expect us to answer such a vague question?
User avatar
Darhazer
DevNet Resident
Posts: 1011
Joined: Thu May 14, 2009 3:00 pm
Location: HellCity, Bulgaria

Re: Bigdump stop on 32

Post by Darhazer »

Here are some things to check (by the way, enable error reporting so you can check for any error messages)
Note 1: BigDump will fail processing large tables containing extended inserts. An extended insert contains all table entries within one SQL query. BigDump isn't able to split such SQL queries. In most cases BigDump will stop if some query includes to many lines. But if PHP complains that allowed memory size exhausted or MySQL server has gone away your dump probably also contains extended inserts. Please turn off extended inserts when exporting database from phpMyAdmin. If you only have a dump file with extended inserts please ask for our support service in order to convert it into a file usable by BigDump.

Note 3: If Timeout errors still occure you may need to adjust the $linespersession setting in bigdump.php.
Note 4: If mySQL server overrun occures you can use $delaypersession setting to let the script sleep some milliseconds or more before starting next session. This setting will only work if the JavaScript is activated.
Post Reply