OStatic

By an anonymous user on Mar. 22, 2008

Haven't tried Zmanda, but try Innodb (http://www.innodb.com)

By an anonymous user on Mar. 22, 2008

Do you use innodb tables or do you use myisam tables? Depending on which ones you use, you have different options.

By an anonymous user on Mar. 22, 2008

If you use innodb tables, you can use innodb hot backup (link mentioned above).

By Nigel Smith on Mar. 23, 2008

Thank you! Well, my database has a mix of InnoDB and MyISAM tables. I have looked at InnoDB hot backup, but I don't think those apply. Currently, I take a backup while the database is running using mysql dump. I'm not sure if my data integrity will be maintained in case a table is updated when mysqldump is running. I do not want to take my database offline when running the backup (hence, the need for hot backups).

Thanks.

By an anonymous user on Oct. 24, 2008

if you want to dump and be consistent, use the --master-data switch.

Be sure to note the DB is effectively read locked for the duration of the dump however.

The added benefit of this is that you know the checkpoint on which the backup was made and can roll logs forward from there.

By wadise wu on Oct. 25, 2008

google team has an opensource for hot backup mysql.. but i forget its name..you can google it