Hi:
I'm moving MySQL data from version 3.23.58 to version 5.0.27. I
dumped 3 version and tried to load it into 5 -- but, the following
error was generated.
CREATE TABLE `cert` (
`cert_id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
`title` TEXT NOT NULL ,
`bodytext` TEXT NOT NULL ,
`eval_id` INT( 11 ) NOT NULL DEFAULT '0',
`sig1_text` VARCHAR( 255 ) NOT NULL DEFAULT '',
`sig2_text` VARCHAR( 255 ) NOT NULL DEFAULT '',
`sig1_img` VARCHAR( 255 ) DEFAULT NULL ,
`sig2_img` VARCHAR( 255 ) DEFAULT NULL ,
PRIMARY KEY ( `cert_id` )
) TYPE = MYISAM COMMENT = 'Hold all the data for a certificate.'
AUTO_INCREMENT =125;
MySQL said:
#1064 - 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 'cert_id` int(11) NOT NULL auto_increment,
`title` text NOT NULL,
`bodytext` ' at line 1
I know the above is an error, but how bad is it? It is easily fixed
OR something that requires a major rewrite, or what? I have read that
MySQL 5 does not support ISAM, but I'm not sure as to what that is or
if that presents a problem here, or not.
I'm a bit lost at the moment. I am open to suggestions, comments, and guidance.
Many thanks in advance for any help.
Cheers,
tedd
--
-------
http://sperling.com http://ancientstones.com http://earthstones.com
_______________________________________________
New York PHP Community MySQL SIG
http://lists.nyphp.org/mailman/listinfo/mysql
NYPHPCon 2006 Presentations Online
http://www.nyphpcon.com
Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php
