Database Backup

From NetMRG Wiki

Jump to: navigation, search

To make a file backup of your NetMRG database, follow these steps:

  • Prevent changes to the database
    • Stopping the gatherer (either the cron job, or the daemon) is not strictly required, but is recommended.
    • You should inhibit configuration changes from the web interface, either by stopping your web service, putting up a maintenance page, or simply scheduling an off-hours backup, or informing your user base.
  • Use mysqldump to backup the database to a file
    • mysqldump -unetmrg -psomepassword netmrg > netmrg.mysql
    • Use your username, password, and database names in place of the example.
  • You now have a file backup of the database. If you desire a complete backup, remember to backup your RRD files and custom scripts.
Personal tools