cacti mysql 修复_Cacti不产生流量图，Mysql 数据表修损坏修复

0/17/2012 10:26:38 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'145', SQL:"select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name) LIMIT 10000"

10/17/2012 10:26:37 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'145', SQL:"select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name) LIMIT 10000"

10/17/2012 10:26:36 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'145', SQL:"select poller_output.output, poller_output.time, poller_output.local_data_id, poller_item.rrd_path, poller_item.rrd_name, poller_item.rrd_num from (poller_output,poller_item) where (poller_output.local_data_id=poller_item.local_data_id and poller_output.rrd_name=poller_item.rrd_name) LIMIT 10000"

Mysql

中数据表修复：

#用REPAIR TABLE方式修复，语法：REPAIR TABLE 表名 [选项]

#进入Mysql数据库：

C:\AppServ\MySQL\bin>mysql -u root -p

Enter password: **************

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 87

Server version: 5.0.45-community-nt-log MySQL Community Edition (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

#

显示所有数据库：

mysql>

show databases;

+--------------------+

| Database

|

+--------------------+

| information_schema |

| cacti

|

| mysql

|

| phpmyadmin

|

| test

|

+--------------------+

5 rows in set (0.00 sec)

mysql>

#

连接损坏表所在的数据库：

mysql>

use cacti;

Database changed

#

查看当前连接的数据库：

mysql>

select database();

+------------+

| database() |

+------------+

| cacti

|

+------------+

1 row in set (0.00 sec)

# REPAIR TABLE

修复数据表

mysql>

REPAIR TABLE poller_item;

+-------------------+--------+----------+----------+

| Table

| Op     | Msg_type | Msg_text |

+-------------------+--------+----------+----------+

| cacti.poller_item | repair | status

| OK       |

+-------------------+--------+----------+----------+

1 row in set (0.02 sec)

mysql>

修复成功。

如果修复失败，可以尝试用USE_FRM选项，例：

mysql>

REPAIR TABLE poller_itemUSE_FRM;