mysqldump是MySQL提供的数据库导出的实用程序.
备份数据库
mysqldump -h hostname -u username -p password --default-character-set=utf8 dbname > filename.sql
备份数据库表
mysqldump -h hostname -u username -p password --default-character-set=utf8 dbname table1 table2 table3 > filename.sql
还原数据库
mysqldump -h hostname -u username -p password --default-character-set=utf8 dbname < filename.sql