Shulou(Shulou.com)06/01 Report--

one。 Backup

1. Export the database file and execute the following command:

Mysqldump-ucactiuser-pcactipw cacti > mysql123.sql

It means: mysqldump directory-u user-p password database name > randomly named file name

two。 Package and back up all the contents under the rra folder

Cd / var/www/html

Tar-cvf rra.tar / var/www/html/rra

= =

two。 Recover data

1. Execute the following command

/ usr/local/mysql/bin/mysql-ucactiuser-pcactipw cacti < / var/www/html/mysql123.sql

Note: / var/www/html/mysql123.sql is the directory of the mysql123.sql file, change it on a case-by-case basis.

two。 Copy the files in rra to the rra folder and modify the cacti permissions of all rrd files

Restart mysql, page Rebuild Poller Cache, complete.

Note: the equipment information, graphics tree and grouping data are all in the mysql123.sql file, and the historical data of the monitoring is in the rra file.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.