NYCPHP Meetup

[nycphp-talk] Data import from MySQL 3.23 to MySQL 4.0

Ajai Khattri ajai at bitblit.net
Thu Jan 6 14:14:53 EST 2005


Im trying to import data from a database in MySQL 3.23 to another server 
using MySQL 4.0.

Im getting an error creating this table:

ERROR 1064 at line 47: 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 'show tinyint(1) unsigned NOT NULL default '1', 
PRIMARY KEY  (s_

The SQL looks like this:

CREATE TABLE items (
  s_id int(10) unsigned NOT NULL auto_increment,
  title varchar(100) default NULL,
  description tinytext,
  price float default NULL,
  pic varchar(50) default NULL,
  show tinyint(1) unsigned NOT NULL default '1', PRIMARY KEY  (s_id)
) TYPE=MyISAM;

Anyone know offhand what changed and how I can modify this to complete 
the import?

-- 
Aj.
Systems Administrator / Developer




More information about the talk mailing list