Backup and Restore MySQL Database with Shell Access

Published on Thursday, September 21st, 2006 1:37 am GMT
Category: Servers

Backup Database

mysqldump -hhostname -uusername -ppassword databasename > backupfile.sql

Add Drop Table - This option is useful if you would like to create a backup file which can rewrite an existing database without having to delete the older database manually first.

mysqldump -–add-drop-table -uusername -ppassword databasename > backupfile.sql

Directly Compress Data from a Database

mysqldump -hhostname -uusername -ppassword databasename | gzip > backupfile.sql.gz

Back up Only Specified Tables

mysqldump -hhostname -uusername -ppassword databasename specific_table1 specific_table2 > backupfile.sql

Backup Multiple Databases

mysqldump -hhostname -uusername -ppassword –databases databasename1 databasename2 databasename3 > multibackupfile.sql

Back up Only the Database Structure

mysqldump –no-data –databases databasename1 databasename2 databasename3 > structurebackupfile.sql

Backup up All Databases on a Server

mysqldump –all-databases > allbackupfile.sql

Restore Database

mysql -hhostname -uusername -ppassword databasename < backupfile.sql

Restoring Zipped Files

gunzip < backupfile.sql.gz | mysql -uusername -ppassword databasename

Moving Database to a New Server

mysqldump -uusername -ppassword databasename | mysql –host=*.*.*.* -C databasename

发表评论

Backup and Restore MySQL Database with Shell Access

上一篇：几个常见的SEO错误观点
下一篇：第一次使用服务器的站长常犯的一些小错误

Trackback