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.
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)
· 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'
The error you shared specifically means that MySQL encountered an issue with the user_registered column, likely because the default value for this column is set incorrectly or is incompatible with the MySQL version or settings you are using.
The simplest thing to try would be changing the MySQL version and see if it works with a different version. It’s possible the version you’re trying to set up in Local doesn’t match what the site had previously.
If that doesn’t work then some deeper changes will have to be made in the DB manually.
But, apart from that, the situation gets complicated. I went to open that blank Wordpress that you recommended me to create here (Error importing a website to LocalWP: Please try again with a compatible zip file - #2 by Nick-B) to import the database manually. My surprise is that, when I put its site domain address (test1.local) in Chrome, it redirects me to the online website https://… which is, precisely, the website that I want to move to local. So now, on top of that, I can’t continue testing on that blank Wordpress.
When you’re creating a new site you can choose the Custom version instead of the Preferred setup with our preset defaults. With the Custom option you can adjust your MySQL version.
As far past the browser redirects, this sounds like caching. So you could try flushing cache, using incognito, etc. Unless the site you have set up also has some redirection type plugins installed that are also interfering.
Today I am sharing a significant development in case it helps anyone who is experiencing a similar problem.
During the process of importing the database, I received numerous error messages on specific lines in the database. When I examined them, they appeared to be IPv6 groups permanently blocked by Wordfence. This format generated lines that were too large for LocalWP to support. I decided to delete them without further ado. The database was then imported without any problems. I went to view the website in LocalWP but, to my surprise, it looked horrible. Neither the Astra theme settings nor the widgets that I have in the footer+sidebar on the right of all pages and all blog posts were imported. The Astra theme has a plugin that serves to export/import its configuration between one website and another. Using this plugin, I was able to transfer the theme settings without any problems. However, I have not yet managed to transfer the widgets. I tried to do it with a plugin called ‘Widget Importer & Exporter’. But this plugin gives an error when importing the .wie file that it generates.
So my sidebar and footer were mutilated, so you could say that the progress in importing this website to LocalWP has gone up to 85%.
–
Postscript: Another problem that I haven’t solved yet, is that I still can’t get the website to load in Microsoft Edge. (ERR_TUNNEL_CONNECTION_FAILED (only in Edge) [MAG]) I can get it to load in Google Chrome (very slow, much slower than the online website), and in Brave (slow, somewhat slower than the online website).