Page 1 of 1

Dump Database

Posted: Thu Jan 02, 2003 2:57 pm
by leebo
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

Posted: Thu Jan 02, 2003 3:03 pm
by Elmseeker
url varchar( 255 ) NOT NULL default '',

try getting rid of the default '' if your gonna default it to be empty it doesn't need to be defaulted at all since if it is left empty when adding to the DB it will remain empty...

Posted: Thu Jan 02, 2003 3:08 pm
by leebo
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 ?

Posted: Thu Jan 02, 2003 3:17 pm
by leebo
Ok i have sorted it - it was the names of the fields which was giving errors: i changed index to index2 and type to type2 then it worked fine

Thanks anyway

Posted: Thu Jan 02, 2003 3:20 pm
by Elmseeker
Yeah, Index and type are probably reserved words in MySQL.