[WBEL-users] Backup
John Hinton
webmaster@ew3d.com
Wed, 11 Aug 2004 21:06:43 -0400
>
> It doesn't: it reads them sequentially.
>
> Somehow, you need to be able to create a "snapshot" of your database
> files so that they are entirely self-consistant before they get backed
> up. This depends on your database. What kind of database and
> database program are you using?
>
> If you're using linux lvm or evms, you can stop your database, create
> a snapshot, restart your database, and back up the snapshot of the
> database files while the database continues running. This may or may
> not be acceptable for your enviroment.
>
I have a very busy mysql database and don't want to shut it down for any
time. I run a slave from this and shutdown, backup and restart the
slave, which then syncs back up. Works great!
John Hinton