[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