标签: it |
1.备份
mysqldump --default-character-set=utf8 -uroot -p*** ebaoyang > ebaoyang.sql
2.拷贝
scp ebaoyang.sql root@10.23.103.31:/root
3.恢复
mysql -uroot -p***
create database ebaoyang;
use ebaoyang;
source ebaoyang.sql;