mysql批量备份与还原

1.备份

mysqldump -uimp_admin -p'caimP@*&56' imp_commondb > /usr/local/suninfo/imp/temp/imp_commondb.sql

远程备份

mysqldump -h 29.192.16.199 -u imp_admin -p'caimP@*&56' -P13507 -S /dev/shm/mysql1/mysql.sock imp_commondb > /opt/data/imp/ftp/imp_commondb.sql;
mysqldump -h 29.192.16.199 -u imp_admin -p'caimP@*&56' -P13507 -S /dev/shm/mysql1/mysql.sock imp_monitordb > /opt/data/imp/ftp/imp_monitordb.sql;
mysqldump -h 29.192.16.199 -u imp_admin -p'caimP@*&56' -P13507 -S /dev/shm/mysql1/mysql.sock imp_scheduledb > /opt/data/imp/ftp/imp_scheduledb.sql;

2.还原

mysql -uimp_admin -p'caimP@*&56' imp_commondb < /usr/local/suninfo/imp/script/imp_commondb.sql