I have problems to import my database

Support
1

What issue or error are you experiencing?

The following is happening: I have a backup I downloaded from the “All-In-One-Migration” plugin for a website I’m working on (I’m not in a hurry because I had to use a backup from the host to fix the problem), but I’m still worried about not being able to use the backup I downloaded from that plugin. Since I’m having trouble paying for the “AIO-Migration Unlimited” license, I came up with the idea of ​​unzipping the backup of my “.wpress” file using one of the Node libraries called “wpress-extractor.” From there, I obtained the files shown below.

All that was left was to import the website locally. To do this, I followed the steps in the tutorial and combined all the files to create the “wp-content” file and separated the “database.sql” file. Then, I compressed both files into a zip file following the steps in this tutorial:

I moved the zip file to start the import, and everything seemed to be going well. When I got to the database import stage, an error occurred and a pop-up window opened with the message “please try again with a compatible zip file.” Afterwards, the entire import file was deleted.

I can’t figure out what happened. The database is about 450MB and the wp-content is about 1.89GB. I had to discard the zip import method and opt for the manual import method. I uploaded a blank site and replaced the wp-content folder with the one I have. In the same “app\public” path, I added the database.sql file.
I opened the site shell and tried to run the command:

wp db import database.sql

But it didn’t work.

I tried another command I found at this link:

mysql -u root -root local < database.sql

And it didn’t work either. I think I ran out of options.

What steps can be taken to replicate the issue? Feel free to include screenshots, videos, etc

  1. Files unzipped by wpress-extractor
  2. Error executing: wp db import database.sql
  3. Error executing: mysql -u root -root local < database.sql

Captura
Captura650×514 32.1 KB

Captura2
Captura2984×607 10.6 KB

Captura3
Captura3842×118 5.65 KB

System Details

  • Local Version:

Version 9.2.0+6762

  • Operating System (OS) and OS version:

Windows 10 64bits, 22H2

Local Logs

Attach your Local Logs here (Help Doc - 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.

2

Hi @yobz

Something we’ve seen happen with the native zip imports is they can fail if they are confused by things like multiple site backups, DB backups, extra core files, etc. So if you have any of those things floating around from previous backup plugins you could try pulling them out and then rezipping just the necessary content + DB. You could probably remove any “cache” directories as well.

As far as the wp db import command not working, this could be due to a number of things. We have a Windows Troubleshooting guide below that goes over some common items worth checking to start. For example, make sure you’re running Local as an admin user, that you don’t have any security blockers, and that Local has access to update your Hosts file.