MySQL backup but only soem tables with a prefix

One of my friend had to mix 2 kind of tables into the same database
'friend_database' using a different prefix (pre1_tables and pre2_tables
).
He would like to backup separatly these 2 kind of tables, but using
phpmyadmin he can't (all or one by one selection.... 200 tables) Is
there any way to find a script that can do the selective backup ?
(then I'll rebuild 2 databases....)

thanks for your help

Joss

"Josselin" <josselin@wanadoo.fr> wrote in message
news:441030d7$0$20174$8fcfb975@news.wanadoo.fr...
> One of my friend had to mix 2 kind of tables into the same database
> 'friend_database' using a different prefix (pre1_tables and pre2_tables ).
> He would like to backup separatly these 2 kind of tables,

mysqldump allows optional arguments with which you can specify individual
tables to back up. I don't think that it supports any kind of
pattern-matching or wildcards in the table names. You could get a list of
the tables and use a text editor to create two separate mysqldump commands,
for the two sets of tables.

I don't have phpmyadmin installed currently, I'm using MySQL Administrator
when I use a GUI. In this tool, there is no opportunity to use wildcards
for table names when making a backup dump. You get to check off specific
tables.

Regards,
Bill K.

On 2006-03-09 18:53:00 +0100, "Bill Karwin" <bill@karwin.com> said:

> "Josselin" <josselin@wanadoo.fr> wrote in message
> news:441030d7$0$20174$8fcfb975@news.wanadoo.fr...
>> One of my friend had to mix 2 kind of tables into the same database
>> 'friend_database' using a different prefix (pre1_tables and pre2_tables
>> ).
>> He would like to backup separatly these 2 kind of tables,
>
> mysqldump allows optional arguments with which you can specify
> individual tables to back up. I don't think that it supports any kind
> of pattern-matching or wildcards in the table names. You could get a
> list of the tables and use a text editor to create two separate
> mysqldump commands, for the two sets of tables.
>
> I don't have phpmyadmin installed currently, I'm using MySQL
> Administrator when I use a GUI. In this tool, there is no opportunity
> to use wildcards for table names when making a backup dump. You get to
> check off specific tables.
>
> Regards,
> Bill K.

thanks for your support... I have both MySQL Administrator and
phpmyadmin.... and unfortunatly it's seems to be impossible to
dump/backup tables based on prefix.... (so why prefix are made for...?)
200 tables to check... well time to start !

Joss