mysql5.5.x 安装cacti报语法错误

  安装cacti时,在导入cacti.sql 这个文件时报错:

The command "mysql -u root -p cacti < cacti.sql' gets the following error:
ERROR 1064 (42000) at line 5: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 6
 

   

    原因是mysql5这后不再支持 TYPE=MyISAM  这样的语法了,改成  ENGINE=MyISAM 就可以了。

 

posted on 2011-06-06 15:31  Maxwell Hu  阅读(434)  评论(0编辑  收藏  举报