Ted,
This appears to be a pretty basic conversion issue, a simple syntax
mismatch, and nothing to worry about .. here's how I would trouble shoot
it..
- Start with a dump of the table structure only (ie. no data) , start
with one table first to see if you can isolate the syntax issue
- I ran your code and it works fine on MySql 5 , Mysql 5 supports
MyISAM this is the default table type, so there is no worries there...
Give me a call if your still having trouble... The only possibility is
there is something setup awkwardly in your mysql 5 setup,, maybe a table
type is missing or something.. this can only be determined once I speak
with you ...
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
--
best regards,
Tony Brandao
/------------------------------------------\
|Developer and Partner |
|http://www.traxxinc.com |
|email: [EMAIL PROTECTED] |
|tel: 973-836-1906 |
|mob: 973-868-7140 |
|fax: 866-336-5946 |
\------------------------------------------/
_______________________________________________
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
