Error importing a website to LocalWP: Please try again with a compatible zip file

[MAG]

Operating System: Windows 10.
LocalWP Version 9.0.5+6706

I have successfully imported 6 websites into LocalWP. But there is one that is resisting me, despite having used the same method as in the previous 6.

I drag the .zip into LocalWP and the import process begins. Everything seems to be going well until when it says “importing database: ssl.sql” I get the message “please try again with a compatible zip file”.

I have created several zip files in different ways, but I always get that error message. I don’t know what else to do.

[Nick-B]

Hi @MAG

There might be something in the site files that is conflicting with the native import. As an alternative, you can try the manual method here:

Manually Import a Local Site

[MAG]

I have followed the steps that you kindly indicated:

· Unzip the file in a common location, like the desktop.
· Create a new, blank site in Local. Use whatever username/password you like since you’ll be overwriting the Database.
· The wp-content folder that is created with the new blank site you can rename wp-content-old or just delete it. Copy the wp-content folder from your backup to the newly created site’s location to take its place.
· Copy the correct SQL file to the site root (App>Public).
· Within Local, click Open Site Shell

But at this point I get an error that I don’t know how to resolve:

C:\Users\and\Local Sites\prueba1\app\public>wp db import backup_2024-07-29-2226_Semana_Santa_Linares_0b750dc3e63f-db. sql
Error: Failed to get current SQL modes. Reason: ERROR 2003 (HY000): Can’t connect to MySQL server on ‘localhost’ (10061)

The sql is correctly in the public folder:

Gyazo

[Nick-B]

Hey @MAG

There could still be something blocking this on your machine, or it might be a conflict with the DB itself.

You could try changing your command to see if this works:

Unable to access database

Hey Everyone – We’ve been zeroing in on why this is happening and the general issue is that the wp db subcommands use the --no-defaults param which blocks out the custom MySQL config we provide. There is a solution but we ran into major issues when trying to implement it on Windows so we’re still working on a way to implement this in a way that works across the various environments. In terms of a workaround, as @kristarella mentioned, you should be able to do some of the basic things wit…

Do you know if the database for this site is extraordinarily large? Or does it have any tables with millions of rows or anything like that?

If the DB is small and you’re still striking out it could mean that your Firewall or some other application is still blocking the import.

[MAG]

Hi, friend.

· ​​I’m not sure if the .sql file size is “extraordinarily large”. It is certainly much larger than the .sql files of the other 6 websites I’ve successfully installed on LocalWP. They were all between 60 and 100 MB, while the problematic one is 230 MB. I hope this is not the problem. If you consider it possible and appropriate, I have no problem sending you in any large file method to see if you can install it in LocalWP.

· I don’t know how to check if it’s a database with millions of rows. My limited knowledge doesn’t go that far.

· It also doesn’t work for me with

C:\Users\and\Local Sites\prueba1\app\public>mysql -u root -proot local < backup_2024-07-29-2226_Semana_Santa_Linares_0b750dc3e63f-db.sql
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1067 (42000) at line 1057: Invalid default value for 'user_registered'

· I don’t have any firewall installed.