restore db problem URGENT

Portal Home > Knowledgebase > Articles Database > restore db problem URGENT

Posted by xserverx, 08-10-2010, 08:13 AM
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
Posted by Patrick, 08-10-2010, 09:59 AM
Yikes. You can try a forceful import: mysql -F database < import.sql (Add the -F flag to your mysql statement.) . .
Posted by Richard-BCS, 08-10-2010, 10:39 AM
Seems like a faulty backup to me or your webserver is trying to access that table at the same time. Either way try to forcefully restore it as mentioned above. If that doesn't work, try to take the database dump apart and try to restore small passages one after another.
Posted by madaboutlinux, 08-10-2010, 10:59 AM
I guess the table is been accessed by the webserver at the time it is restored. Stop the webserver, restart the mysql service once and then give a try.