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)