Bug #55880 Table 'time_zone_name' was not locked with LOCK TABLES
Submitted: 10 Aug 2010 12:45 Modified: 10 Aug 2010 17:49
Reporter: Omar Bourja Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Backup Severity:S1 (Critical)
Version:5.0.91-community OS:Linux (CentOS)
Assigned to: CPU Architecture:Any
Tags: time_zone_name locked LOCK TABLES

[10 Aug 2010 12:45] Omar Bourja 
Description:
 Hello
I have this error when I try to restore a database :
ERROR 1100 (HY000) at line 103: Table 'time_zone_name' was not locked with LOCK TABLES

on the line 103 I have this :
/*!40103 SET TIME_ZONE='+00:00' */;

could some one help please

I couldn't edit the db because its about 10Gb in its size

thank you

How to repeat:
 Hello
I have this error when I try to restore a database :
ERROR 1100 (HY000) at line 103: Table 'time_zone_name' was not locked with LOCK TABLES

on the line 103 I have this :
/*!40103 SET TIME_ZONE='+00:00' */;

could some one help please

I couldn't edit the db because its about 10Gb in its size

thank you
[10 Aug 2010 13:16] MySQL Verification Team 
http://bugs.mysql.com/bug.php?id=30838?.
[10 Aug 2010 17:49] MySQL Verification Team 
Duplicate of: http://bugs.mysql.com/bug.php?id=9953.