MySQL Forums
Forum List  »  Data Recovery

ERROR 1100 (HY000): Table ... was not locked with LOCK TABLES
Posted by: Omer Khalid
Date: June 11, 2009 03:40PM

Hi,

I am trying to import data from a sql dump file. But when I import it:

mysql -u root -p DBName < dump.sql

I constantly get this error:
ERROR 1100 (HY000): Table 'T1' was not locked with LOCK TABLES

I tried to lock tables by issuing LOCK TABLES command and then attempted importing data but it didn't work.

It would be really great if some one could reply to this message with a solution of about how to fix this since its pretty urgent for me.

Many thanks for your help in advance, regards

Omer

Options: ReplyQuote


Subject
Views
Written By
Posted
ERROR 1100 (HY000): Table ... was not locked with LOCK TABLES
7566
June 11, 2009 03:40PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.