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!