Digital Marketing

MySQL – Ignore Tables from Backup in MySQLdump

Use –ignore-table option with the mysqldump command to ignore table for backup. 

Using this option, you need to specify both the database and table names as showing in the below example.

mysqldump --login-path=root -T /backup/mysql-files/ goyuninfo --ignore-table=goyuninfo.table_to_ignore1 --ignore-table=goyuninfo.table_to_ignore2


Or using --ignore-table and create an array of tables, with syntaxs like

--ignore-table={db_test1.table8,db_test2.table6,db_test3.table5}

Comments

Popular posts from this blog

Fixed WSL sshd: no hostkeys available -- exiting

PowerMTA pmta command

How to fix: mv: failed to preserve ownership