Jump to content

daily database backup

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Create New...