Can't restore a backup because of: ERROR 1100 (HY000) at line 79763: Table 'wp_wps_object_term' was not locked with LOCK TABLES

SYSTEM INFORMATION
OS type and version Ubuntu 22.04
Webmin version 2.101
Virtualmin version 7.7 Pro
Related packages SUGGESTED

I’m trying to restore a backup but the backup fails because found this:
ERROR 1100 (HY000) at line 79763: Table ‘wp_wps_object_term’ was not locked with LOCK TABLES

ERROR 1100 (HY000) at line 79766: Table ‘wp_wps_object_term’ was not locked with LOCK TABLES

ERROR 1146 (42S02) at line 79790: Table ‘store_wordpress.wp_wps_object_term’ doesn’t exist

ERROR 1146 (42S02) at line 79792: Table ‘store_wordpress.wp_wps_object_term’ doesn’t exist

ERROR 1100 (HY000) at line 79828: Table ‘wp_wps_query’ was not locked with LOCK TABLES

ERROR 1100 (HY000) at line 79831: Table ‘wp_wps_query’ was not locked with LOCK TABLES

ERROR 1146 (42S02) at line 79843: Table ‘store_wordpress.wp_wps_query’ doesn’t exist

ERROR 1146 (42S02) at line 79844: Table ‘store_wordpress.wp_wps_query’ doesn’t exist

ERROR 1100 (HY000) at line 79872: Table ‘wp_wps_user_agent’ was not locked with LOCK TABLES

ERROR 1100 (HY000) at line 79875: Table ‘wp_wps_user_agent’ was not locked with LOCK TABLES

ERROR 1146 (42S02) at line 79887: Table ‘store_wordpress.wp_wps_user_agent’ doesn’t exist

ERROR 1146 (42S02) at line 79888: Table ‘store_wordpress.wp_wps_user_agent’ doesn’t exist

ERROR 1100 (HY000) at line 79972: Table ‘wp_yoast_indexable_hierarchy’ was not locked with LOCK TABLES

ERROR 1100 (HY000) at line 79975: Table ‘wp_yoast_indexable_hierarchy’ was not locked with LOCK TABLES

ERROR 1100 (HY000) at line 79998: Table ‘wp_yoast_migrations’ was not locked with LOCK TABLES

ERROR 1100 (HY000) at line 80001: Table ‘wp_yoast_migrations’ was not locked with LOCK TABLES

ERROR 1100 (HY000) at line 80020: Table ‘wp_yoast_primary_term’ was not locked with LOCK TABLES

ERROR 1100 (HY000) at line 80023: Table ‘wp_yoast_primary_term’ was not locked with LOCK TABLES

ERROR 1100 (HY000) at line 80048: Table ‘wp_yoast_seo_links’ was not locked with LOCK TABLES

ERROR 1100 (HY000) at line 80051: Table ‘wp_yoast_seo_links’ was not locked with LOCK TABLES

What can I do? It’s supposed that the backup and the restore should be clean, but I have been wasting 3 days with this error!

Hello,

There is an option in System Settings ⇾ Virtualmin Configuration: Backup and restore page called Backup MySQL in a single transaction. Please double check if it’s enabled.

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.