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