1,备份数据库
mysql -uroot -p123456 db_name > /root/db_name.dump
2,数据库备份文件恢复
mysql -uroot -p123456 db_name < /root/db_name.dump
mysql -uroot -p123456 db_name > /root/db_name.dump
mysql -uroot -p123456 db_name < /root/db_name.dump
转载于:https://www.cnblogs.com/peteremperor/p/10113616.html