If you need to restore a database that already exists, you’ll need to use mysqlimport command. The syntax for mysqlimport is as follows:

Mysql backup using phpmyadmin

To tack the mysql database backup you can login to phpmyadmin and follow the following steps

1. Select Export from the menu

technointellects-phpmyadmin-export1

2. Select the Zipped format for downloading in compressed form

3. Press “GO”

technointellects-phpmyadmin-export2

Mysql database migration using shell command

I had a problem migrating the large mysql databases from one server to another. When ever i tried to do that using some utility I got “Out of Memory” error.

After a bit of research work, I realized that big databases can be migrated using shell command easily

Below you can find instructions to move database from one hosting provider to another:

1. Make database backup

shell> mysqldump –host=[hostname] –user=[username] –password=[passowrd] [database_name] > dump.sql

2. Back up the database

Pack that backup into archive (for example - tar.gz). The following shell command will pack file “dump.sql” into archive “dump.tar.gz”:

shell> tar -cvf - ./dump.sql | gzip -c > dump.tar.gz

3. Transfer the archived from one hosting provider to another using FTP or anything else.

4. Unpack that backup archive at new server.

OR (for TAR that doesn’t support ‘z’ option): shell> gunzip < ./dump.tar.gz | tar -xvf -

5. Restore database from dump file using native MySQL command-line tool - mysql