Hi
I have backed up my mysql database to my hardrive and moving it to another host but when i try and upload it again i get the following error:
CREATE TABLE apart(
town varchar( 100 ) NOT NULL default '0',
sleeps int( 19 ) default '0',
price int( 20 ) default '0',
pool varchar( 8 ) default '0',
beach varchar( 20 ) default '0',
other text NOT NULL ,
picture varchar( 255 ) default '0',
index int( 11 ) NOT NULL auto_increment,
url varchar( 255 ) NOT NULL default '',
type varchar( 50 ) NOT NULL default 'villa',
email varchar( 50 ) NOT NULL default '',
dateadded date NOT NULL default '0000-00-00',
PRIMARY KEY ( index )
) TYPE = MyISAM
MySQL said:
You have an error in your SQL syntax near 'int(11) NOT NULL auto_increment, url varchar(255) NOT NULL default '', type varc' at line 1
Any help will be gratefull
Dump Database
Moderator: General Moderators
Thanks but still gives the error :
CREATE TABLE apart(
town varchar( 100 ) NOT NULL default '0',
sleeps int( 19 ) default '0',
price int( 20 ) default '0',
pool varchar( 8 ) default '0',
beach varchar( 20 ) default '0',
other text NOT NULL ,
picture varchar( 255 ) default '0',
index int( 11 ) NOT NULL auto_increment,
url varchar( 255 ) NOT NULL ,
type varchar( 50 ) NOT NULL default 'villa',
email varchar( 50 ) NOT NULL ,
dateadded date NOT NULL default '0000-00-00',
PRIMARY KEY ( index )
) TYPE = MyISAM
MySQL said:
You have an error in your SQL syntax near 'int(11) NOT NULL auto_increment, url varchar(255) NOT NULL , type varchar(50) NO' at line 1
Any more suggestions ?
CREATE TABLE apart(
town varchar( 100 ) NOT NULL default '0',
sleeps int( 19 ) default '0',
price int( 20 ) default '0',
pool varchar( 8 ) default '0',
beach varchar( 20 ) default '0',
other text NOT NULL ,
picture varchar( 255 ) default '0',
index int( 11 ) NOT NULL auto_increment,
url varchar( 255 ) NOT NULL ,
type varchar( 50 ) NOT NULL default 'villa',
email varchar( 50 ) NOT NULL ,
dateadded date NOT NULL default '0000-00-00',
PRIMARY KEY ( index )
) TYPE = MyISAM
MySQL said:
You have an error in your SQL syntax near 'int(11) NOT NULL auto_increment, url varchar(255) NOT NULL , type varchar(50) NO' at line 1
Any more suggestions ?