MySQL Forums
Forum List  »  Backup

Designing a backup solution for Huge Tables
Posted by: tysonlowery
Date: November 02, 2005 10:34AM

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.

Options: ReplyQuote

Written By
Designing a backup solution for Huge Tables
November 02, 2005 10:34AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.