I have a site backup zip file that contains all required files and a dump database. This site was from live production and now I want to restore it on local machine. When importing the file I got an error “…SELECT option_value from eas_options WHERE option_name =‘siteurl’;
ERROR 1146 (42S02) at line 1: Table ‘local.eas_options’ doesn’t exist”
Note: the eas_options table is on the database. I can create a site using this database without an issue.
Troubleshooting Questions
- Does this happen for all sites in Local, or just one in particular?
It only happens when importing a site. - Are you able to create a new, plain WordPress site in Local and access it in a Browser?
Yes, I can create a new plain WordPress site in Local using this database without an issue.
Replication
- Backup file of the WordPress site using cPanel
- Exported the database, it was from phpmyadmin using Mamp server. the table prefix is eas_
- Zip all in one file
- Import the zip file to the Local
5 Error as below
System Details
-
Which version of Local is being used?
Local version 6.6.0 +6231 -
What Operating System (OS) and OS version is being used?
Windows 11 -
Attach the Local Log. See this Help Doc for instructions on how to do so:
- [Retrieving Local’s Log](
local-lightning.log (180.0 KB)
local-lightning-verbose.log (69.0 KB)
local-lightning-verbose1.log (761 Bytes)
local-lightning-verbose2.log (1.0 MB)
/)
- [Retrieving Local’s Log](
Security Reminder
Local does a pretty good job of scrubbing private info from the logs and the errors it produces, however there’s always the possibility that something private can come through. Because these are public forums, always review the screenshots you are sharing to make sure there isn’t private info like passwords being displayed.