MySQL will go down if locked tables are touched during dump. Use the following mysqldump syntax instead: 1mysqldump --single-transaction --skip-lock-tables

1mysqldump -u<username> -p<password> --no-create-db myDB --ignore-table=myDB.table1 --ignore-table=myDB.table3-h localhost > mysql.backup See https://tecadmin.net/tutorial/mysql/skip-tables-in-mysqldump/

1mysqldump -u<username> -p<password> --no-create-db myDB -h localhost > mysql.backup That way, it would strip the original database name and NOT become a problem when importing to another database name. See …

1mysqldump -u root -p yourDB system > yourDB_system.sql More details in https://dba.stackexchange.com/questions/9306/how-do-you-mysqldump-specific-tables