MySQL Forums
Forum List  »  Backup

Re: best way to backup data
Posted by: Alejandro Cavallo
Date: December 15, 2014 08:59AM

Thanks Rick for the answer!
The database has inno and myisam tables. There is no problem blocking the writes to all tables because the database is not write intensive (and the backups are done during the midnight, when the traffic is low).
Regarding users, it has only 2 users configured, so it's also unnecessary.
I didn't added --lock-tables because I tough it is done by default by mysqldump.

Is there a chance that mysqldump produces a corrupted dump without returning an error in stderr?
I want to do a script backup that could be 100% automatized. I want the backup and check processes could be done through a cronjob.

The database and backups are in a server with a RAID-1 configuration to reduce corruptions due disk failure.

Why do you said to pull a dump out of evault to a different computer?

Thanks!

Options: ReplyQuote


Subject
Views
Written By
Posted
3092
December 11, 2014 01:36PM
1848
December 12, 2014 11:01PM
Re: best way to backup data
1645
December 15, 2014 08:59AM
2126
December 17, 2014 11:48AM
1421
December 17, 2014 01:20PM


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.