MySQL – Table ‘the_table’ was not locked with Lock Tables

MySQL

I try and load tables via MySQL and get the following error?

MySQL said: Table 'cms' was not locked with LOCK TABLES

Why does the table need to be Locked? I haven't seen this before? is there any way to unlock? do you even want to?

Best Answer

If in one session, you locked one table but want to select from another table, you must either lock that table too or unlock all tables.

mysql> LOCK TABLES t1 READ;
mysql> SELECT COUNT(*) FROM t1;
+----------+
| COUNT(*) |
+----------+
|        3 |
+----------+
mysql> SELECT COUNT(*) FROM t2;
ERROR 1100 (HY000): Table 't2' was not locked with LOCK TABLES

Related Solutions

Mysql – How to restore a dump file from thesqldump

If the database you want to restore doesn't already exist, you need to create it first.

On the command-line, if you're in the same directory that contains the dumped file, use these commands (with appropriate substitutions):

C:\> mysql -u root -p

mysql> create database mydb;
mysql> use mydb;
mysql> source db_backup.dump;

Mysql – How to find all the tables in MySQL with specific column names in them

To get all tables with columns columnA or ColumnB in the database YourDatabase:

SELECT DISTINCT TABLE_NAME 
    FROM INFORMATION_SCHEMA.COLUMNS
    WHERE COLUMN_NAME IN ('columnA','ColumnB')
        AND TABLE_SCHEMA='YourDatabase';

Best Answer

Related Solutions

Mysql – How to restore a dump file from thesqldump

Mysql – How to find all the tables in MySQL with specific column names in them

Related Topic