Skip to content

Latest commit

 

History

History
16 lines (11 loc) · 453 Bytes

skip_tables_dump.md

File metadata and controls

16 lines (11 loc) · 453 Bytes

Skip certain tables while doing dump

mysqldump db --ignore-table=db.table1 --ignore-table=db.table2 > backup.sql
  • db - database name generate dump for
  • --ignore-table= - ignore speicified table while dumping (for multiple tables add this option multiple times)
  • db.table1 - first table to ignore
  • db.table2 - second table to ignore
  • backup.sql - name of dump file

group: dump

link_youtube: https://youtu.be/fz3Ci7Pl9iI