>You may wish to also look into replication, which is a cinch to setup
>with MySQL.
Unfortunately replication does not handle point in time recovery. This
is usually required to happen when someone accidentally drops a table
or deletes too many rows from the database inadvertently. Under
replication these changes will be dutifully applied to the replica.
One mechanism would be to mirror the data disks, raid-1. This would
provide the necessary reliability, but again will not account for user
mistakes. Best bet is to utilize one of the backup strategies to make
a copy of the data in a reasonable fashion. And this may also require
replication so the actual backup may happen from the replica without
unduly effecting the primary.
Brad Eacker ([EMAIL PROTECTED])
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
