can you send the contents of your dumpfile up to this point. assuming its
line 118 of hte dumpfile and 21 of this build table query
Jeff
"Chris W. Parker"
<[EMAIL PROTECTED] To: <[EMAIL PROTECTED]>
.com> cc:
Subject: DB not restoring from dump
file
10/27/2003 01:45
PM
Hey everyone,
First post to the MySQL list so please be gentle.
I recently emptied some tables I shouldn't have in a db of mine and I
want to restore the data from a dump file made a few days ago.
MySQL version is 3.23.
This is the command I used to create the dump:
mysqldump --opt -u root --password=password dbname > dbname.dump
I'm trying to restore that file with:
mysql -u root -ppassword dbname < dbname.dump
I'm getting the following error:
ERROR 1064 at line 118: You have an error in your SQL syntax near
'unique (email)
) TYPE=MyISAM' at line 21
Someone suggested to me that it might be because I have a reserved word
for a column name but I checked this option out and I do not.
Where did I go wrong?
Thanks,
Chris.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
