And also another item, when you export a table that had AUTO_INCREMENT and it had 125 entries in it already, after you export it at the end of the exported TABLE CREATE code it will say: AUTO_INCREMENT =125 (like yours does). You need to ensure that that says: AUTO_INCREMENT =1 (or whatever your AUTO_INCREMENT is actually intended to be) when you actually run the code for the new table in the new location. Otherwise, I believe in the new table, each new entry will get auto incremented by 125.
Warmest regards, Peter Sawczynec Technology Dir. Sun-code.com Web related services 646.316.3678 [EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Antonio Brandao Sent: Monday, June 18, 2007 1:56 PM To: MySQL SIG Subject: Re: [mysql] Moving data from MySQL 3.23.58 to 5.0.27 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 _______________________________________________ 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
