Re: mysqlhotcopy to backup ARCHIVE tables?

[Beat Vontobel]

> archive.krow.net

I liked the entry on auto_increment ;-) (still watching sweety)

> The other item that needs to be done at some point
> is I should allow it to keep a version list when
> mysqldump is used to do a dump, so that it would
> give a consistent snapshot.

Sorry, last question: I just don't get this completely. Where would the version list be kept? How would I replay a consistent backup from the dump and the binary log and make sure that no row gets inserted twice?

But okay, for now we could just use mysqldump with the --lock-tables option. This should at least work when we don't use INSERT DELAYED. We still have the same consistency problem with MyISAM anyway. (That's the problem right now anyway: How to ensure consistent backups across all your databases if you use InnoDB and non-transactional engines at the same time.)

Thanks,
Beat