Re: mysqlhotcopy to backup ARCHIVE tables?
Thanks, Brian. So I assume the Archive engine was your "baby"? Cool stuff!
I didn't use it in production yet, but I think I might use it for a project soon (and probably replace some older archive solutions that currently work with a combination of merged unpacked and packed MyISAM tables).
> You won't get whatever rows are currently in the compression buffer,
> but all data on disk at that moment will be just fine. If not, there is a bug :)
Will the compression buffer be written to disk completely when I do a FLUSH TABLES? Then the LOCK, FLUSH and copy strategy would be absolutely safe and I couldn't lose a single row.
Cheers,
Beat
Subject
Views
Written By
Posted
8364
February 01, 2006 10:19AM
5000
February 03, 2006 12:56AM
Re: mysqlhotcopy to backup ARCHIVE tables?
4998
February 03, 2006 02:35AM
4763
February 03, 2006 05:11AM
4586
February 03, 2006 09:45AM
4745
February 05, 2006 10:31PM
4593
June 20, 2006 05:14PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.