How Can I Do A Mysql Dump Only Certain Tables With Wild Card

Forums » MySQL » How Can I Do A Mysql Dump Only Certain Tables With Wild Card
a questino asked by a forums member: how can i do a mysql dump with only certain tables using a wild card? im using ssh to connect to my linux server and im sending a commmand but i have like 50 tables
how can i do a mysql dump with only certain tables using a wild card? im using ssh to connect to my linux server and im sending a commmand but i have like 50 tables, and i only want my forums tables to be included in the mysqldump how can i do this?

this is the command im sending:

mysqldump --opt -u root -p databse myforum* | gzip > 6-12-23-08.sql.gz

and this is the error i get:

mysqldump: Couldn't find table: "myforum*"



please help me


Title: How Can I Do A Mysql Dump Only Certain Tables With Wild Card [911]
Tags: mysqldump only certain tables wild card
By
Comments 0
Visits 1045