By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,988 Members | 1,074 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,988 IT Pros & Developers. It's quick & easy.

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

P: n/a
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

Jul 20 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Dino wrote:

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".


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.
Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.