Can’t ‘import’ (revive, restore, whatever word you want) a Local Site, even though all the files exist.
Troubleshooting Questions
I have tried creating a zip file of the entire directory, and the usual steps, however each time I drag the file onto the Local window, I get a popup that says Local doesn’t know what to do with the file.
Does this happen for all sites in Local, or just one in particular?
ALL SITES
Are you able to create a new, plain WordPress site in Local and access it in a Browser?
Yes
Replication
Open Local (ver 6.4.2+6012).
Select a Local site.
Right Click Site Name, select Delete, Uncheck “Move site files to Trash”, Click Delete Site.
Even though all the files were left in place, there is seemingly no way to ‘restore’ the site.
System Details
Which version of Local is being used?
ver 6.4.2+6012
What Operating System (OS) and OS version is being used?
Mac Monterey v 12.5
** If you try to create a ‘new’ site with the same name, Local gives an error that there’s already a local site there. You’d think the software could just re-import it.
I followed some of the posts on the site about importing a zip file.
The real problem is this: I had some clients who wanted development done, so I started building a site. Then they decided not to move forward. So, I deleted the site from Local, but left the files on my hard drive (as they existed). Now the clients are back, and I would like to import the site that I had been building.
I figured this should be easy since all the data is still there (and hasn’t changed), but apparently it’s not.
I can’t create a new site with the same name, as Local says the file exists already. However, I can’t even “import” the old site as Local apparently doesn’t recognize it.
So glad you were able to solve this (although a bummer about the posts, comments, etc) - I presume that is living in a sql file somewhere - do you want to keep looking for that together?
local.wp_comments.sql
The “schema” file is the actual table schema. The non-schema file is the data.
One issue that you have to correct by hand is that the default datetime that’s used in the files (0000-00-00 00:00:00) is not allowed by mysql. The minimum datetime is ‘1000-01-01 00:00:00’ - so you have to find/replace that in each file before you can continue.
You can then remove all the tables from the “new site” database file, but keep the database.
You can then restore all the ‘shcema’ files, which will create the tables.
You can then import all the non-schema sql files which contains the data.
When you log in to the admin panel, you’ll likely get a notice about upgrading the database (as I did, because of the changes from WP5 to WP6). The upgrade ran without issue and the site is back.
