How to restore compressed mysql backup file
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
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
RSS Feeds
