mysql 备份命令 mysqldump

mysqldump --skip-opt -u root --password=123456 im_inv >iminv.SQL

 --ignore-db=information_schema  跳过数据库
--skip-opt 跳过锁表

mysqldump --skip-opt -u root --password=123456 --all-databases >alldatabase.sql
mysql -uroot -p[password] < all_databases_backup.sql

 mysqldump --skip-opt -u root --password=123456 --databases IMPE_Setting dataxweb im_dong im_donga imcf imcloud immes immesflow imoa message nacos  wifi>/usr/local/mariadb/backup/alldatabase.sql
 mariadb -uroot -p331253a < /usr/local/mariadb/backup/alldatabase.sql

未经允许不得转载：lxfamn » mysql 备份命令 mysqldump