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]

Reply via email to