PDA

View Full Version : Mysqldump options



lirkaaa
December 8th, 2010, 08:30 AM
Hello,

I was wondering if there is a way to backup all my databases(which are actually backup-ed table per table), with both "create" backup and data backup.
What I mean with the create backup is something like the "--no-data" option from mysqldump, and the data will be a normal backup.
I used a script in the past with:
mysqldump --no-data -f
mysqldump -f -t
and that for each table from each DB.

Is there a way to do the same with Zmanda?

Thanks.

paddy
December 8th, 2010, 02:06 PM
Set these options as extra-mysqldump-options in mysql-zrm.conf or pass it as command line parameter to mysql-zrm-backup.

See http://wiki.zmanda.com/index.php/Mysql-zrm-backup

Paddy