Can't restore a mysqldumped backup file
Hi!
I tried using mysqldump to backup my database and i can't restore it using the $mysql database < backup.sql command. I'm suspecting that the problem is because i'm using the field name KEY. The error lies somewhere here:
CREATE TABLE Bago (
sn varchar(10) NOT NULL default '',
KEY varchar(5) NOT NULL default '',
PRIMARY KEY (sn)
) TYPE=MyISAM;
Are we not allowed to use KEY as a field name? I enclosed it with quotes ('KEY') and it worked!
whew! Anyone? Thanks
Subject
Views
Written By
Posted
Can't restore a mysqldumped backup file
3627
May 17, 2005 03:45AM
2469
May 19, 2005 03:14AM
Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.