If the exported database SQL file is bigger, if it is imported through phpMyAdmin, it will often fail, and there is often no shell permission on the virtual host, there is no way to import from the command line, if you find the service provider, once a second time, if you have multiple times , I think the opponent's face is definitely not good, it is not necessary to charge.
Based on this, you need to find a tool that supports large data imports that support Webase, BIGDUMP is used for this purpose.
BigDump: Staggered MySQL Dump Importer Staggered import of large and very large MySQL Dumps (like phpMyAdmin 2.x Dumps) even through the web-servers with hard runtime limit and those in safe mode The script executes only a small part of the huge dump. And restarts itself. The next session stopped.
Software download address: http://www.ozerov.de/bigdump.zip
Website: http://www.ozerov.de/bigdump.php
Frequently Asked Q: q: I get an error: "MySQL: Table 'Some_TBL_NAME' Already Exists". Why?
A: Your Dump Queries. Use phpmyadmin to Drop All The Tables on The Target Database Which Must Be Restored Before You Start The IMPORT.
Q: I get an error: "Fatal error: allowed memory size of xxx bytes exhausted" or "mysql server haas game gone". Why?
A: Your dump file probably contains extended inserts An extended insert contains all table entries within one SQL query BigDump is not able to split such SQL queries Please turn off extended inserts when exporting database from phpMyAdmin....
Q: Why does bigdump fail PUTTING STRANGE SQL ERRORS IF I Run IT from The Localhost On My Windows PC?
A: This is IMHO a bug in the PHP 4.3.x that is crashing BigDump on Win32 if using a dump file with DOS encoded line breaks (contact me for details) As workaround create your dump with only the UNIX line breaks or convert it. INTO UNIX FORMAT USING SOME TEXT EDITOR. The You Will Be Able To Run Bigdump Also At Your Localhost.
Q: Can I use dump files created by other software than phpMyAdmin A:? You can use any text dump file at your own risk Although it's very important for BigDump to find a semicolon followed by a line break at the end of each query.. It will not work else since it has no time to parse the queries to find their proper ends. Further BigDump behaviour can be unpredictable if your dump file is using double quotes to surround strings. BigDump will not work too if your dump file contains any proprietary comment lines (like in some dumps created by other tools). Although you can use the $ comment setting in bigdump.php to drop non-standard comment lines by their first characters. Apart from that BigDump does not filter the dump file .
Q: Why don't you provide any facility to input the database configuration from the browser form?
A: Input The Database Configuration from the form.
