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!

Leave a Reply

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