MysSQL db not restoring
| From: | Chris W. Parker | Date: | Sat, 25 Oct 2003 00:00:33 +0000 |
| Subject: | MysSQL db not restoring | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-167505@lists.php.net to get a copy of this message | ||
Sorry for the OT post but here goes...
I do nightly dumps of a MySQL database and now I've finally mistakenly
emptied some tables I shouldn't have. I'd like to restore last nights
dump file.
This is the command I'm using:
mysql -u username -ppassword db_name < db_name.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
Anyone know why this is going wrong? Am I doing something obviously
wrong?
Chris.
--
Don't like reformatting your Outlook replies? Now there's relief!
http://home.in.tum.de/~jain/software/outlook-quotefix/