HELP! having BIG problems with mysqldump and backup script....

[Dino]

hello,

every night i'm running a simple cronjob which created sql-dumps from
serevral web applications using a syntax like this:

mysqldump --add-drop-table -uuzzer -hmyhost -pmypw mydatabase table1 table2
table3 > dumpme.sql

after this, the sql-dump is packed together with the pages of the website,
creating a whole backup-archive.

now, there is a new web application and i'm simply running mad :-(((
this applications creates and deletes some tables dynamically, making it
impossible to use a fixed naming for tables for the dump. the only thing they
have in common is the similar part of the nyme, they all start with
"myapplication_ ", followed by a number, e.g. "myapplication_ 23".

using a syntax like mysqldump --add-drop-table -uuzzer -hmyhost -pmypw
mydatabase myapplication_* > dumpme.sql failed.

i don't have the slightest clue how to solve this problem, it would be simply
fantastic if someone could help me. the backup script is running on a linux
server using a bash-script.

thanks a lot in advance,
dino

[Bill Karwin]

Re: HELP! having BIG problems with mysqldump and backup script....

Dino wrote:[color=blue]
>
> this applications creates and deletes some tables dynamically, making it
> impossible to use a fixed naming for tables for the dump. the only[/color]
thing they[color=blue]
> have in common is the similar part of the nyme, they all start with
> "myapplication_ ", followed by a number, e.g. "myapplication_ 23".[/color]

I can think of two possible suggestions:

1) Back up all tables, by omitting the list of specific tables.

or

2) Run mysqlshow -u uzzer -h myhost -pmypw mydatabase
This gives a list of the tables currently in that database, and you can
grep out the right table names that you want to back up.

Regards,
Bill K.