mysql dump

mahmoud · 02-25-2008, 10:14 AM

Hi does anyone know how to exclude a database from a mysql dump
or if you can use mysqldump to dump database that are in file list
for example i have a list of all the database i want to dump in a file can i use mysqldump to look into the file and use the list to do the dump

mtimbro · 02-25-2008, 10:23 AM

Quote:

Originally Posted by mahmoud

Hi does anyone know how to exclude a database from a mysql dump
or if you can use mysqldump to dump database that are in file list
for example i have a list of all the database i want to dump in a file can i use mysqldump to look into the file and use the list to do the dump

From what I can read, either you specify each DB or all the DB's:

>mysqldump [options] --databases DB1 [DB2 DB3...]
>mysqldump [options] --all-databases

Hope this helps,

mahmoud · 02-26-2008, 03:59 AM

i want to exclude a database from mysql dump

Deleriux · 02-26-2008, 06:24 AM

mtimbro is exactly right. You cant exclude. You must include those you want to backup instead.

Code:

USER=user;
PASS=pass
HOST=host;
EXCLUDE=exludeddb
#********

MYSQL=$(mysql -N -u${USER} -p${PASS} -h${HOST} <<<"SHOW DATABASES" | grep -v ${EXCLUDE} | tr "\n" " ")

mysqldump -u${USER} -p${PASS} -h${HOST} --databases ${MYSQL}

my_seagul · 02-26-2008, 07:48 AM

I have been using this backup-script for quite a while now in many production environments:

http://www.debianhelp.co.uk/mysqlscript.htm

Deleriux's script is handy, but if you need to get mysqldump regularly, this might come handy.

Deleriux · 02-26-2008, 08:23 AM

Well, I woudlnt call the above a proper script so to speak, just a means of excluding 1 database when doing a mysqldump.

Seagull is right though - it might be more beneficial for you to take advantage of a prewritten script which is capable of customization to your particular needs.

choogendyk · 02-26-2008, 05:10 PM

Or, if you wanted to do some serious management of mySQL dumps, you could adopt Zmanda Recovery Manager (ZRM) for MySQL:

http://www.zmanda.com/backup-mysql.html

It's open source and free, so you can download it and use it. Zmanda also provides commercial enterprise support.

mahmoud · 02-27-2008, 02:43 AM

thanks guys i put those commands in a script and it worked fine
its just a one time dump