数据库导入~~#1100 - Table 'pma_column_info' was not locked with LOCK TABLES

winzeng 2010-11-21 10:39:15

mysql 3.3.8，导入另外一个dedecms数据库时提示错误

SQL 查询:

SELECT `comment`
FROM `phpmyadmin`.`pma_column_info`
WHERE db_name = 'cnabcn_fenlei'
AND table_name = ''
AND column_name = '(db_comment)'

MySQL 返回：

#1100 - Table 'pma_column_info' was not locked with LOCK TABLES

把新服务器按照dedecms得到的sql，和旧服务器上的dedecms sql 对比发现旧的sql表开始部分中多出了LOCK TABLES ...WRITE;
1.本服务安装dedecms在sql文件中发现
INSERT INTO `dede_addonarticle` (`aid`, `typeid`, `body`, `redirecturl`, `templet`, `userip`) VALUES
2.旧数据sql中
LOCK TABLES `dede_addonarticle` WRITE;
/*!40000 ALTER TABLE `dede_addonarticle` DISABLE KEYS */;
INSERT INTO `dede_addonarticle` (`aid`, `typeid`, `body`, `redirecturl`, `templet`, `userip`) VALUES (1,80,'<p>/*!40000 ALTER TABLE `dede010ef_addonarticle` ENABLE KEYS */;
UNLOCK TABL

...全文