How to dump specific tables using mysqldump?

I had forgotten how to dump a specific table using mysqldumb (normally I just dump the entire DB) but thankfully RolandoMySQLDBA had the simple answer! Thanks for the help 🙂

“If you are dumping tables t1, t2, and t3 from mydb

mysqldump -u... -p... mydb t1 t2 t3 > mydb_tables.sql

via mysql – How do you mysqldump specific table(s)? – Database Administrators.

Rating 5/5 stars, easy and intuitive!

Top Search Terms:
  • mysqldump specific tables (6)
  • "mysql" and "dump specific tables" (1)
  • mysql dump specified table (1)
  • mysqldump of specific tables (1)
  • mysqldump specfic table (1)
  • mysqldump specific table (1)
  • rolandomysqldba (1)

Leave a Reply

Your email address will not be published. Required fields are marked *