mysql备份恢复
备份某个表：mysqldump -u username -p password database_name table_name > backup_file.sql
备份多个表：mysqldump –u username -p password database_name table1 table2 >BackupName.sql 备份整个库：mysqldump -u username -p password database_name > backup_file.sql 备份多个库：mysqldump -uroot -p'1qazzaq1' --set-gtid-purged=off -h192.168.112.217 --databases v_dcm v_eca v_ica v_la v_ma v_pca v_ra v_root_ca v_ssp v_trcla > /root/sqlbak/init_v2x.sql
恢复：mysql -h 127.0.0.1 -u root -p;
source path/to/file.sql