How to restore compressed mysql backup file

July 31, 2008 · Filed Under Linux / Unix Commands, Mysql · 1 Comment

To restore compressed backup files you can do the following:

gunzip < [backupfile.sql.gz] | mysql -u [uname] -p[pass] [dbname]

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

mysqlimport -u [uname] -p[pass] [dbname] [backupfile.sql]

Mysql backup using phpmyadmin

July 26, 2008 · Filed Under Mysql · Comment

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