mysql数据库备份，恢复命令

1. 备份

?

? ? ?mysqldump -B dbname -uroot -ppassword --default-character-set=utf8 > /home/opt/opdir/dbname.sql;

?

2. 创建数据

?

? ? ?mysqladmin -uroot -ppassword?create dbname --default-character-set=utf8;

?

3. 恢复

? ? ?mysql -uroot -ppassword dbname < /home/opt/opdir/dbname.sql;