Re: Backup and Maintenance Strategies

2005-06-25 Thread Mathias
Selon James Tu [EMAIL PROTECTED]: What have people done in the past regarding backup strategies? Is it adequate enough to rely on filesystem backups for mysql? Basically such that we can restore MySQL to the last filesystem backup. Is there a reason not to do this? I don't have any mission

Re: Backup and Maintenance Strategies

2005-06-25 Thread Michael Kruckenberg
I don't know how big your tables are, and if you can withstand any downtime. Because we're using MyISAM tables, we use mysqlhotcopy, which locks the database as it copies the tables to another location. Once that's been done you can rely on your filesystem backup to keep copies of the data

Backup and Maintenance Strategies

2005-06-24 Thread James Tu
What have people done in the past regarding backup strategies? Is it adequate enough to rely on filesystem backups for mysql? Basically such that we can restore MySQL to the last filesystem backup. Is there a reason not to do this? I don't have any mission critical data and data that is lost