MySQL Forums
Forum List  »  Backup

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:,404875,404875

Options: ReplyQuote

Written By
ERROR 1146 (42S02) at line 12: Table 'mysql.time_zone_name' doesn't exist
October 22, 2011 10:30PM

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.