MysSQL db not restoring

From: 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/

« previous php.general (#167505) next »