daily database backup

[SaschaRD 0]

Hey Folks,

we want to made a daily database backup of the contained mysql database. We imported the ESET Remote Administrator Virtual Appliance on one of our ESX-Servers, where you have the manually Backup database function.

To automate the process I followed the guide of the support.eset.com site, which leads me to the following shell command:

mysqldump -u root -p era_db > /opt/eradb.sql

But, when i compare the backups which has been created from the management mode and the one which has been created by the shell command, the database backup from the shell command is missing over 6.000 lines.. any ideas why this is happening?

Thanks and Cheers, Sascha

[SaschaRD 0]

I found the reason/solution why the backups were not equal, the parameter -R - for all routines was missing. Which is described in the guide of mysqldump.

Cheers, Sascha