数据库备份

DBserver1

mysqldump -u root -P 3307 -h 192.168.2.2 -p333333 --opt --single-transaction -R jfpt_qd_0728 > /mnt/0728.dump

DBserver2

source
mysql -u root -predhat -e ”create database westos;”
mysql -u root -predhat < /mnt/westos.sql    把/mnt/westos.sql还原为westos库