123456
--导出数据
MysqLdump -h rdsav7fqzjjbyzq.MysqL.rds.aliyuncs.com -u rybhe -P 3306 -p --opt --default-character-set=utf8 --triggers --hex-blob rybhedb > /opt/yizhichao/db_rybdbhe_backup_20161024.sql
导入数据
MysqL -u root -p MediaPlatDB_20170329< /opt/yizhichao/db_mediaplatdb_backup_20170329.sql
MysqL -u root -p MediaPlatDB_20170329< /opt/yizhichao/db_rybdbhe_backup_20170406.sql
MysqL -h 127.0.0.1 -u root -P 3306 -p rybhedb< /opt/yizhichao/853632_all.sql
导入数据
MysqL -h 127.0.0.1 -u root -P 3306 -p MediaPlatDB_20170329 < /opt/yizhichao/db_mediaplatdb_backup_20170329.sql
原文链接：https://www.f2er.com/centos/378073.html