MyISAM引擎备份
mysqldump -u root -p --default-character-set=utf8 --opt --triggers -e -C -R dbname > bak_dbname.sql
恢复
mysql -u root -p --default-character-set=utf8 dbname < bak_dbname.sqlInnoDB引擎备份
mysqldump -u root -p --default-character-set=utf8 --opt --triggers -e -C -R --single-transaction dbname > bak_dbname.sql
恢复
mysql -u root -p --default-character-set=utf8 --single-transaction dbname < bak_dbname.sql
mysqldump -u root -p --default-character-set=utf8 --opt --triggers -e -C -R dbname > bak_dbname.sql
恢复
mysql -u root -p --default-character-set=utf8 dbname < bak_dbname.sqlInnoDB引擎备份
mysqldump -u root -p --default-character-set=utf8 --opt --triggers -e -C -R --single-transaction dbname > bak_dbname.sql
恢复
mysql -u root -p --default-character-set=utf8 --single-transaction dbname < bak_dbname.sql
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货