Importing large databases in MySQL September 27, 2010Posted 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 :