Did you try this one? I simplified it for you. You just need to put this in
a file and chmod +x the file. Then you can execute it from a crontab or with
the shell.
~~~ Copy/paste after this ~~~
#!/bin/bash
# Modify following variables
# script will dump the tables that contain the following in the name
expression_to_match="z_"
# database name
database="database_name"
# database host
database_host="localhost"
# directory to dump tables (put ending /)
dump_path="/path/to/dump/"
TABLES=`echo "show tables" | mysql -h$database_host $database | grep
$expression_to_match`
for table in $TABLES
do
echo $table
mysqldump $database $table >$dump_path$table
done
# end script
~~ end copy/paste ~~
You may need to twea the TABLES= command if you're using a password. Same
for mysqldump if you want to put more options such as --opt
_____________________________
Steve Poirier
> -----Original Message-----
> From: Josh Howe [mailto:[EMAIL PROTECTED]
> Sent: November 2, 2004 11:47 AM
> To: Spenser; [EMAIL PROTECTED]
> Subject: RE: mysqldump
>
>
> 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]
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
