List:General Discussion« Previous MessageNext Message »
From:Ananda Kumar Date:May 8 2008 5:59am
Subject:error while creating a copy of a table
View as plain text  
Hi All,
I am getting below error. This is the only table of INNODB ENGINE, the
default storage engine is MyISAM

mysql> create table tmp_dc as select gid,siteid,has_gy,starts from dc_tc;
ERROR 1206 (HY000): The total number of locks exceeds the lock table size

how do i fix this error.

Thread
error while creating a copy of a tableAnanda Kumar8 May
  • Re: error while creating a copy of a tableMoon's Father24 May