Bigdump stop on 32
Moderator: General Moderators
-
Frederick A Greene
- Forum Newbie
- Posts: 5
- Joined: Sat Mar 12, 2011 2:22 am
Bigdump stop on 32
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.
- John Cartwright
- Site Admin
- Posts: 11470
- Joined: Tue Dec 23, 2003 2:10 am
- Location: Toronto
- Contact:
Re: Bigdump stop on 32
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?
Seriously, how do you expect us to answer such a vague question?
Re: Bigdump stop on 32
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.