Re: best way to backup data

[Alejandro Cavallo]

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!