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]
Posts with the Mysql tag
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 2. Select the Zipped format for downloading in compressed form 3. Press “GO”