Tedd, I'm running 5.0.38 and had no problem running the script that you provided (just copied and pasted it). Is there anything before the CREATE TABLE statement?
- Brian On 6/18/07, Brian D. <[EMAIL PROTECTED]> wrote:
Tedd, I'm running 5.0.38 and had no problem running the script that you provided (just copied and pasted it). Is there anything before the CREATE TABLE statement? - Brian On 6/18/07, tedd <[EMAIL PROTECTED]> wrote: > 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 >
_______________________________________________ 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
