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



Popular posts from this blog

Make online money from the Internet