This article will deal with the export and import of mysql databases and solving a common import problem of huge mysql database files that they cannot be imported into mysql if they are large enough due to time limits and other restrictions.

Export MySQL Database with mysqldump:

mysqldump -u username -ppassword database_name > export.sql

Import MySQL Database with mysql:

mysql -u username -ppassword database_name < export.sql

Importing very large MySQL Database using BigDump Importer:

Download BigDump v0.29b from: http://www.ozerov.de/bigdump.php

Usage:

Edit bigdump.php and modify your database connectivity

// Database configuration
$db_server   = ‘localhost’;
$db_name     = ‘dbname’;
$db_username = ‘dbusername’;
$db_password = ‘dbpassword’;

Browse to bigdump.php file

http://localhost/bigdump.php

In case you want the upload option available you will need to give write permissions to your current directory

chmod 777 dir

Example Preview:

Clicking on Start Import option you can start importing your database.

In case you want to specify the file from within bigdump.php file you need to edit the follow line:

$filename = ”; // Specify the dump filename to suppress the file selection dialog

You can import the following .gz, .sql and .csv file extensions only.

Results of the import: (2.5GB size and about 32Million Records)