Recover RRD and SQL from backup

[Quickybilly]

Hello,

After several problems, I decided to format the server and reinstall Cacti. I'll do it with BSOD installer as soon as I download it.

Could you please explain which files should I recover from backup to have all the devices back without having to re-create them again?

I guess the RRD files will be no problem, as you only need to copy them to the RRA folder, but what about the database? Do I need to recover the file cacti.sql and overwrite the one existing after installing cacti? Will I need to make any changes in another files or folders?

Thank you very much.

[Sirup]

The database stores all configuration you made via the webinterface.

You can export it via:

Code: Select all

mysqldump -opt [databasename] > dbsave.sql --password

..and reimport it like this:

Code: Select all

 mysql [databasename] < dbsave.sql --password

[Quickybilly]

Thank you very much Sirup.