When migrating a site that has been around for a while, I often run into the problem where my MySQL Database is just too large to import via the web interface of PHPMyAdmin. Often times its to a server that doesn’t allow remote access to their databases. What is a poor dev to do?
Take a big dump
Although this script has been around for almost 9 years, its still an essential tool for every developers toolbox. Big Dump staggers the database import so your server does not timeout. Here is a quick tutorial on how to use Big Dump.
Video
Instructions
- Download the latest version of Big Dump here.
- Open up bigdump.php and configure: Server, database name, username, password, and the file name.
- Upload both your SQL file and bigdump.php to your server
- Browse to bigdump.php and click import
Thats it! Wait a few minutes and you will see a confirmation screen similar to the one below. Make sure to delete bigdump.php off your server when you are finished.
Very cool! I’ve never heard of this before. Thanks for sharing.
I usualy use Bigdump.php for large mysql database, too. Thanks…
thank u very much solved my problem
Thanks for this guide. Lucky i found your tutorial. Now i can do transfer my site by myself.
i am getting below mention error
Fatal error: Maximum execution time of 300 seconds exceeded in C:\wamp\apps\phpmyadmin3.1.3.1\libraries\import\sql.php on line 142
can you help in this regard, Thanks
Saleem
Hey Saleem, thats just a timeout error which means its too low. since you are on your own machine, you can up the time out. I dont know exactly where it is on WAMP but this should point you in the right direction: http://www.directadmin.com/forum/archive/index.php/t-7797.html
hi, and thanks for a such a good script and tutorial.
I try to import one database to my localhost, but I get this error:
Error at the line 30: CREATE DATABASE `information_schema` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
I change the charset, but same error.
any suggestion?
thanks in advance
set max time at php.ini file at your server..,you can set there in seconds..like 7200 open php.ini and find there max keyword..