Thanks Spenser, but I'd already tried something similar. What I get when I try this is:
mysqldump: Can't get CREATE TABLE for table `z_*` (Table 'sinu_com.z_*' doesn't exist) -----Original Message----- From: Spenser [mailto:[EMAIL PROTECTED] Sent: Monday, November 01, 2004 6:30 PM To: Josh Howe Subject: Re: mysqldump Take a look at this article: http://www.unixreview.com/documents/s=8989/ur0408d/ There's a section on mysqldump if you prefer using it. You would do something like the following to backup only certain tables based on their names starting with z_. mysqldump -u root -p -x -e db1 z_* > /tmp/backup/db1_table1.sql On Mon, 2004-11-01 at 11:30, Josh Howe wrote: > > Hi, > Can anybody help me with a linux newbie question. I want to use > mysqldump to backup all of the tables in a database that start with z_. > Can I do this in linux with a single line? Thanks. > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
