MySQL Forums
Forum List  »  Backup

Re: Designing a backup solution for Huge Tables
Posted by: Brian Moon
Date: January 05, 2006 02:40PM

We use a slave server to do all our database backups. We then dump each table to its own file. We found it is easier to work with that way.

If you have data in the tables you could partition, you could pass a where to the mysqldump script and create several sql files.

Brian Moon
Phorum Dev Team
http://phorum.org/
-----------------------
dealnews.com - How to go broke saving money.
http://dealnews.com/

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Designing a backup solution for Huge Tables
2331
January 05, 2006 02:40PM


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.