Answers for "mysqldump skip table data"

SQL
1

mysql backup skip table

mysqldump -u testuser -p testdb --ignore-table testdb.table1 --ignore-table testdb.table2 > /tmp/backup_ignored.sql
Posted by: Guest on January-06-2021
0

mysqldump ignore table

/*ignore dumbing tables with --ignore-table option like so: (note you can use it multiple times)*/
mysqldump -u USER -pPASS DATABASE --ignore-table=DATABASE.table1 --ignore-table=DATABASE.table2 > backup.sql
Posted by: Guest on October-06-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language