-->-----Original Message-----
-->From: Chris W. Parker [mailto:[EMAIL PROTECTED]
-->Sent: Monday, October 27, 2003 10:46 AM
-->To: [EMAIL PROTECTED]
-->Subject: DB not restoring from dump file
-->
-->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?
- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://friendfinder.com/go/p40688
Look at that line and make sure there is not a DOS character line in it.
This is what I can think of off the top of my head. Could you provide
line 21 and a few lines above that? It could be a missed comma.
-->
-->
-->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]
