Unable to successfully import backup of Wordpress site to Local. I created a zip archive with 1.) a mysqldump of my website’s database (backup.sql) and 2.) a copy of the wp-contents folder. It proceeds successfully with “adding Wordpress” step, but then fails at the “Importing Database: backup.sql” step.
Here is the exact error message:
Uh-oh! Unable to import site.
Error: Command failed: /Applications/Local.app/Contents/Resources/extraResources/lightning-services/mysql-8.0.16+5/bin/darwin/bin/mysql local -B --disable-column-names -e SELECT option_value FROM wp_options WHERE option_name = ‘siteurl’;
ERROR 1146 (42S02) at line 1: Table ‘local.wp_options’ doesn’t exist
I found two separate forum threads with this exact issue, but no resolution. Honestly, for an app that specializes in Wordpress, I have no idea why I’m failing to even get past this step. I assume this should be the easy part.
The table wp_options does exist in the database. I can see it with SequelPro on my server and in the SQL dump file.
I exported the database directly from my server using
mysqldump -uUSER -pPASSWORD databasename > backup.sql
I use VESTACP, and it formats databases with the database name as SERVERUSERNAME_DATABASENAME. All tables have been prefixed with “wp_”, as is common with most WP sites. Is the issue the database name itself? I’m wondering why the error message states “local.wp_options” for the table name. Why it’s not just wp_options.
Anyone have any idea? I’m just a bit shocked this is even an issue. I followed the process exactly, which is fairly simple. Just zip a folder with the mysqldump file and the wp-contents folder. I was expecting this process to be the easy part.
I have heard great things about this app, I would love to actually use it.
I’m using the latest version of Local on Mac (Catalina OS).