Time for action – restoring the Cacti database
Logon to your Cacti server.
Change to the backup directory:
cd /backup
Extract the latest backup file:
gunzip cacti_database_20101004.sql.gz
Restore the database. Make sure to change the username and Cacti database name to fit your installation. Please note that this command is going to overwrite your existing database:
mysql -u cactiuser -p cacti < cacti_database_20101004.sql
What just happened?
You restored your Cacti database from a backup. Please note that any changes you have made since the backup has been created, such as adding new devices to the server, will be lost.
Restoring the Cacti files
Restoring files from a backup will involve two methods:
Restoring all of the Cacti files
Restoring a single file
Restoring all Cacti files
Restoring all files is only necessary in case of a full disaster recovery like a hard disk failure. Thankfully, your backup should contain all necessary files to restore a Cacti installation from the ground...