CloudAccess Wordpress Site Exported With Duplicator Pro

Support
1

Issue Summary

Hello! I exported my Wordpress site - hosted on CloudAccess - using duplicator pro. I then imported the zip file into local and got these two errors as well as a failure.

The following SQL files failed to import:

• /app/sql/expectedQueries.sql

Please double-check that the site looks correct after importing.

Error: Command failed: /private/var/folders/hr/5npp9pzn2nn0tbf1gq358_mc0000gn/T/AppTranslocation/A4D55A14-3648-4292-A998-9A0C041D87DF/d/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

Troubleshooting Questions

I have only tried with the one site

Replication

Export a CloudAccess Wordpress website (I believe cloudaccess matters because the server info may be different) using duplicator pro plugin. Try to use the output zip file to import site to Local. Get an sql error.

UPDATE: Tried following the Local Youtube video on importing a site from wordpress by compressing wp_content and database file and I got the same error. I am assuming it is something to do with my database setup? For instance, my database tables’ prefixes are not wp_(table)

System Details

I just downloaded the most recent version.

2

When you look at the raw SQL files, does there appear to be content there?

What is the prefix? Local should be able to tease out different WP prefixes, but it’s possible that there are multiple sql files that are being auto imported and causing issues.

3

Thank you for the reply!

Yes the sql file has content. I don’t think I am able to upload it here…

The prefix is azc_. I also tried again by editing the sql file and replacing the prefix with wp_ but to no avail. Must be something else?

My workflow follows this article

I have done everything here from using duplicator and importing the archive to Local but it doesn’t finish.

4

Update: I tried just taking the wp_content folder and using WP Migrate DB to export the database just to see if a different workflow would get it done and I got the same error.

Please help! I can send you my DB file if that helps. I’m not sure how else to make it work.

I have read many great things about Local and would love to start using it!

5

I am receiving the same error although I have used cpanel and UpdraftPlus to download db.

6

It seems the issue is due to local’s inability to map DB prefix properly. I used All-in-One WP Migration plugin to transfer my website and it worked.

7

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