jump to navigation

Importing large databases in MySQL September 27, 2010

Posted by Tournas Dimitrios in Mysql, PHP.

One of the things I like about PhpMyAdmin is its ability to export an entire database as a series of SQL statements (CREATE and INSERT) .

On the other hand the same PhpMyAdmin has a very serious limitation when it comes to import back SQL files: it wouldn’t import any files larger than 2Mb. I’m not sure what are the technical reasons for this limitation. This is due to the PHP configuration (upload_max_filesize and post_max_filesize directives in PHP.ini). If you are using a shared server, you may not be able to change these values.

Fortunately I’ve discovered a very simple tool called BigDump. This little PHP script allows for arbitrary-sized sql files to be imported in the MySql database with no headaches. It’s pretty simple to configure, files can be uploaded via ftp and it’ll show them in a list for easy restore. It supports both text (*.sql) and compressed (*.gz) files.

Download BigDump and follow the instructions how to use this simple php-script .

Now download from Mysql these two test databases and make a test  :


No comments yet — be the first.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s