ERROR 1100 (HY000) at line 570: Table 'table_name' was not locked with LOCK TABLES

All MAMP discussions around troubleshooting and anything related to MAMP. Be as detailed as possible here when posting an issue.
Post Reply
mampsupportmod
Site Admin
Posts: 92
Joined: Wed Jan 20, 2021 3:06 am

ERROR 1100 (HY000) at line 570: Table 'table_name' was not locked with LOCK TABLES

Post by mampsupportmod »

I did a SQL dump from MAMP Pro (dumped all db's into a single file) then tried re-importing but I found when it took the dump it inserted a table lock statement. Now, none of the db's will import and I'm stuck with this message:

Code: Select all

ERROR 1100 (HY000) at line 570: Table 'table_name' was not locked with LOCK TABLES
Post Reply