8/19/2011

Cacti plugin installation problem

When you applied the pa.sql to cacti database, you might face 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 12

To get around this, you have to edit pa.sql and replace the word TYPE to ENGINE like this.

:%s/TYPE/ENGINE/g

Then excute the sql file.:)

No comments: