Re: ERROR 1100 (HY000) at line : Table was not locked with LOCK TABLES

[Michael delos Reyes]

In the sqldump file:

LOCK TABLES `TABLE_A` WRITE;
/*!40000 ALTER TABLE `TABLE_A` DISABLE KEYS */;
set autocommit=0;
ALTER TABLE `TABLE_A` ADD KEY `TABLE_A_IX1` (`SESSION_ID`);
ALTER TABLE `TABLE_A` ADD CONSTRAINT `TABLE_A_FK` FOREIGN KEY (`SESSION_ID`) REFERENCES `TABLE_B` (`SESSION_ID`) ON DELETE CASCADE;
/*!40000 ALTER TABLE `TABLE_A` ENABLE KEYS */;
UNLOCK TABLES;
commit;

its should be LOCK TABLES `TABLE_A` WRITE, `TABLE_B` READ;

so that I dont get the error:
ERROR 1100 (HY000) at line 74: Table 'TABLE_B' was not locked with LOCK TABLES