mysql数据库迁移

mysql数据库迁移

标签：  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;

转自：http://blog.sina.com.cn/u/1401623893