BigDump: Staggered MySQL Dump Importer

Version: 0.28b (last update on Aug 6, 2007)
Compatibility: 1.00
Download
Attention high risk : Please remove after your work !!!!!!! 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 starts where the last was stopped. Note: Version 0.28b includes some very important bugfixes and other improvements. Please don't hesitate to report any bugs in this release (but read this site first)! SUPPORT * Need help restoring or moving the large mySQL database? * Need help converting your dump file to use BigDump? * Need help developing new software that use BigDump? * Need a feature that BigDump doesn't currently provide? * Need help getting BigDump running? * Need a bug fixed right away? * Need someone you can ask if you run into a problem? Support services for BigDump can provide the solution you need. For more information please contact me. YOU WANT To restore the very large backup of your mySQL database (or a part of it) into the new or the same mySQL database. You can't access the server shell and you can't import the dump using phpMyAdmin or any other scripts due to hard memory resp. runtime limit of the web server. YOU NEED 1. Bigdump script bigdump.php from the download above 2. Dump file(s) of your database created by phpMyAdmin I'll call it dump.sql from now on. You can also use GZip compressed dump files if you call them somehow like dump.gz. GZip support is only with PHP 4.3.0 and later Note: Using a huge GZip compressed dump file can cause the script to exceed the PHP memory/runtime limit since the dump file has to be unpacked from the beginning everytime the session starts. If this happens use the uncompressed dump. It's your only chance. 3. Access account for your mySQL database 4. Access account for some web server with PHP 4.1.0 or later installed. This web server must be able to connect to the mySQL database (this ability is probably present if your web server and the mySQL server are from the same ISP) 5. Some text editor like Notepad to edit the configuration file 6. Some FTP client to upload the files to the web server 7. Common knowledge about files, PHP, mySQL databases, phpMyAdmin, FTP and HTTP USAGE 1. Open bigdump.php in a text editor and adjust the database configuration 2. Drop the old tables on the target database if your dump doesn't contain "DROP TABLE" (use phpMyAdmin) 3. Create the working directory (e.g. dump) on your web server 4. If you want to upload the dump files directly from the web browser give the scripts writing permissions on the working directory (e.g. make chmod 777 on a Linux based system). You can upload the dump files from the browser up to the size limit set by the current PHP configuration of the web server. Alternatively you c