I am not strong with the command line. As such, I rely on PHPMyAdmin to get things done in MySQL quickly. One of the big problems with PHPMyAdmin are the import limitations and timeout issues. In my case, my host's implementation of PHPMyAdmin doesn't even include the import function. In my last post, on upgrading to D6, I described a situation where I really needed to import a database, that I had performed the update on my laptop.
I used PHPMyAdmin to export the database on my live site and plopped it on my desktop. I fired up MAMP and went to MySQL. I created a new database and granted all to a new user on the blank database. I *tried* to import my database--which currently is about 56--and had no joy. I increased the file size and timeout length, but that didn't help me out--I could only get two out of 88 tables to import.
I needed a different solution. In comes BigDump.
BigDump is a script that will take your MySQL database and stagger the import, handling very large MySQL files.
- Open up the bigdump.php file with a text editor
- Scroll down to the following:
db_server = 'localhost';
db_name = 'yourfreshnewdatabase';
db_username = 'yourfreshnewusername';
db_password = 'yourfreshnewpassword';
- Enter your database name, your database's user name (that you granted all permissions to), enter your user name's password and save
- Hop onto your favourite FTP client and FTP onto your server
- Place your database sql file and the bigdump php file into the root directory for your web files (typically htdocs or just docs)
- Fire up your browser and point it at http://yourdomainname.com/bigdump.php
- Follow the directions that pop up
- Your MySQL database should import into the empty MySQL database
- DELETE the bigdump script from the server. It has your database's username and password in it! I would also delete the MySQL sql database backup file
You should have a restored copy of your database living on your server now. In my case I had uploaded a fresh set of D6 files and modified the settings.php file to look at my new database.
Command line is faster, but if you need an alternate way to import a MySQL database, this is a dandy way of doing it.