Cacti Table ‘host’ is marked as crashed and should be repaired

Cacti Table ‘host’ is marked as crashed and should be repaired

My Cacti server lost all host information and on monitor tab its showing error  “Table ‘host’ is marked as crashed and should be repaired”

I tried google got below solution that worked for me .I got my all devices back to monitor.

go to cli directory    /var/www/html/cli/

and run command  “php repair_database.php”

[root@localhost ~]# cd /var/www/html/cli/

[root@localhost cli]# php repair_database.php
Repairing All Cacti Database Tables
Repairing Table -> ‘cdef’ Successful
Repairing Table -> ‘cdef_items’ Successful
Repairing Table -> ‘colors’ Successful
Repairing Table -> ‘data_input’ Successful
Repairing Table -> ‘data_input_data’ Successful
Repairing Table -> ‘data_input_fields’ Successful
Repairing Table -> ‘data_local’ Successful

(more…)

Continue Reading Cacti Table ‘host’ is marked as crashed and should be repaired

Recover MySQL root Password

  • Post author:
  • Post category:MySQL
  • Post comments:1 Comment

Recover MySQL root Password You can recover MySQL database server password with following five easy steps.   Step # 1: Stop the MySQL server process. Step # 2: Start the…

Continue Reading Recover MySQL root Password

How to backup MySQL on Linux

How to backup MySQL on Linux Connect to your Linux server via SSH Use the mysqldump utility to create your database backup. The command is run in the format “mysqldump…

Continue Reading How to backup MySQL on Linux