BigDump: Staggered MySQL Dump Importer

Serving 3665 extensions to the community

Directory Menu

Login or Register

Home

Tools

Database tools

!!!!!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

Editor's Note

This extension requires registration to download.

Reviews (2)

A Must for any website owner!

byMrEngland on March 2, 2009

I have used the script version of this and it is a must!.
We all know how to back up but restoring can seem a little more complex. This file is neat. Dump your SQL output in a folder and load the script, prime it first with your details.
Call it in your browser and let it loose.
Also get around the SQL size limit by slicing the dump into manageable chunks.

like I said, until u tried you don't quite realise what you have.
oh and yes, as you are going to upload a file with your details on first you must delete this file after using the script (but you all knew that right!)

Works like a charm!

byMarHaj on August 6, 2007

I had some problems with importing large Joomla! tables (2-3MB)via phpMyAdmin into MySQL database. Timeouts, lack of memory, etc., etc.

My problems have gone away with BigDump.

The product is really fast, reliable and - to my surprise - very easy to install and use.

I am The very satisfied user!

Categories

Directory Menu

Login or Register

BigDump: Staggered MySQL Dump Importer