subject:"\[PHP\] MysSQL db not restoring"

RE: [PHP] MysSQL db not restoring

2003-10-27 Thread Chris W. Parker

Curt Zirzow on Friday, October 24, 2003 5:19 PM said: > You probably have a field name that is a keyword of some sort. Hard > to tell without seeing the create table syntax. I checked this out and I did not have any keywords as column names. Would it help if I poste

Re: [PHP] MysSQL db not restoring

2003-10-24 Thread Curt Zirzow

* Thus wrote Chris W. Parker ([EMAIL PROTECTED]): > > 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 You probably have a field name that is a keyword of some sort. Hard to tell without seeing th

[PHP] MysSQL db not restoring

2003-10-24 Thread Chris W. Parker

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 follo