MySQL Forums
Forum List  »  Backup

Advanced Search
New Topic

ERROR 1146 (42S02) at line 12: Table 'mysql.time_zone_name' doesn't exist
Posted by: pedro davila
Date: October 22, 2011 10:30PM

Hello, I encountered this 'mysql.time_zone_name' error when trying to restore a MySQL 5.0 database from a mysqldump. I believe it's a bug. I saw someone asked about it earlier on this forum. I found a solution, since that topic is closed, I'm opening a new topic.

Solution: Delete Line 12. (:)

12: /*!40103 SET TIME_ZONE='+00:00' */;

Old Topic:
http://forums.mysql.com/read.php?28,404875,404875

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
ERROR 1146 (42S02) at line 12: Table 'mysql.time_zone_name' doesn't exist
6159
pedro davila
October 22, 2011 10:30PM
Re: ERROR 1146 (42S02) at line 12: Table 'mysql.time_zone_name' doesn't exist
1742
Rick James
October 23, 2011 08:23PM


Sorry, you can't reply to this topic. It has been closed.

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.