I dont think you can do a hot backup because it does no do transactions.

The 2 easiest ways would be:

have the filesystem mirrored, quiesce the database then break the mirror.
write-lock a table at a time and do a mysqldump.


On Wed, Jan 17, 2001 at 03:31:48PM -0800, Gerald Wichmann wrote:
> Is it possible to backup MySQL on Linux while the DB is up and running and
> get a good back? (i.e. a hot backup)
>
> Gerald Wichmann
> Systems Engineer
> Sansia System Solutions
> 408-844-8893 work
> 408-884-9801 fax