Designing a backup solution for Huge Tables

[tysonlowery]

Hi - I have a fairly large MySQL database, comprised of MyIsam and Innodb tables. The database is about 10 GB, with about 7 or 8 GB being Innodb tables. Some of the larger tables I don't even bother backing up at this point.

I probably need to get in and use the backups about 1-2 times a month.

I've tried mysqldump scripts, and I seem to have problems using the data sometimes because the files are so large.

Should I be looking at a hotbackup script? How fast are these? Do these just copy the data files?

I was also thinking some kind of delayed replication might do the trick - is there a way to setup replication so that the slave table only gets updated every 24 hours?

Thanks for the help!!!



Edited 1 time(s). Last edit at 11/02/2005 10:35AM by tysonlowery.