MySQL Forums
Forum List  »  Backup

Can't restore a mysqldumped backup file
Posted by: Elmer Claveria
Date: May 17, 2005 03:45AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Can't restore a mysqldumped backup file
3627
May 17, 2005 03:45AM


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.