On 1/25/2011 09:00, Robinson, Eric wrote:
> I'm starting to worry that you may be right. I know FLUSH TABLES WITH
> READ LOCK does not work as expected with InnoDB, but is there really no
> way to put InnoDB into a state where all changes have been flushed to
> disk and it is safe to rsync the directory? Is stopping the service
> really the only way? (And even if I stop the service, is rsync totally
> safe with InnoDB?)
You need to quiesce the InnoDb background threads. One technique is
Look for the section talking about "clean" backups.
MySQL Principal Technical Support Engineer
Oracle USA, Inc.
Office: Blountville, TN