MySQL備份/還原指令(How to Back Up and Restore a MySQL Database)
MySQL備份/還原指令(How to Back Up and Restore a MySQL Database)
mysqldump -u [uname] -p[pass] [dbname] | gzip -9 > [backupfile.sql.gz]
範例:mysqldump -u root -pusbw -P 3307 v7 > v7.sql
mysql -u [uname] -p[pass] [db_to_restore] < [backupfile.sql]