mysql数据库修复



系统报错：02/05/2015 08:52:21 AM - CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'145', SQL:"SELECT facility_id, facility FROM syslog`.`syslog_facilities`"
 CMDPHP: Poller[0] ERROR: SQL Assoc Failed!, Error:'145', 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;
mysql> use cacti;
Database changed
#查看当前连接的数据库：
mysql> select database();
mysql>
mysql>repair table syslog.syslog;

直到成功。