Mysql 6 support?

[west408@hotmail.com]

Having problems getting the sql dump int my dbase, it doesn't like any of the types? Is cactii support for sql 6?

Server version: 6.0.8-alpha FreeBSD port: mysql-server-6.0.8


[root@BSD]!504! [~] # mysql -u root -p cactidb < /usr/local/share/cacti/cacti.sql


ERROR 1064 (42000) at line 16: 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 AUTO_INCREMENT=16' at line 6

DROP TABLE IF EXISTS `cdef`;
CREATE TABLE `cdef` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`hash` varchar(32) NOT NULL default '',
`name` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM =16;

Thanks!

[cigamit]

Most likely not, MySQL 6 is still in Alpha testing.

MySQL 6.0 Community Edition - Alpha Development Release

NOTE: This alpha release, as any other pre-production release, should not be installed on production level systems or systems with critical data. It is good practice to back up your data before installing any new version of software. Although MySQL has worked very hard to ensure a high level of quality, protect your data by making a backup as you would for any other software beta release. MySQL generally recommends that you dump and reload your tables from any previous version to upgrade to 6.0.

[west408@hotmail.com]

Confirmed MySQL 6.0 doesn't like cacti -

downgraded to 5.0 - works fine