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

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

http://bugs.mysql.com/bug.php?id=30838?.

Duplicate of: http://bugs.mysql.com/bug.php?id=9953.

Page generated in 0.040 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.