I've lost all my pages

[marypearson]

I am on a Mac OS 15.3.2

I am using Local 9.2.3 on my own computer.

I had an issue on the site with BuddyPress so I reset the slugs. In the process I lost ALL of my pages Except Buddypress pages.

The only pages left are ones that were in the trash, and a draft of Privacy Policy. Sample page/Home page is gone. There are no other pages AT ALL.

I have Time Machine going all the time so I deleted all the current files and uploaded all new files from a backup, but the pages are still missing. I have gone through all the files to make sure everything was copied over, and it was, but I cannot find the pages.

Can you tell me where they might be please and how do I get them back.
Thank you.

Update: I may have found them in the database. I have exported wp_posts as an SQL but I don’t know what to do with it.

All logs are just a repeat of the following:

{“class”:“Process”,“level”:“warn”,“message”:“2025-04-15T03:40:20.178527Z 2772 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ‘‘mysql_native_password’ is deprecated and will be removed in a future release. Please use caching_sha2_password instead’”,“process”:“mysql”,“thread”:“main”,“timestamp”:“2025-04-15T03:40:20.178Z”}
{“class”:“Process”,“level”:“warn”,“message”:“2025-04-15T03:40:21.226470Z 2773 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ‘‘mysql_native_password’ is deprecated and will be removed in a future release. Please use caching_sha2_password instead’”,“process”:“mysql”,“thread”:“main”,“timestamp”:“2025-04-15T03:40:21.226Z”}
{“class”:“Process”,“level”:“warn”,“message”:“2025-04-15T03:40:21.998252Z 2774 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ‘‘mysql_native_password’ is deprecated and will be removed in a future release. Please use caching_sha2_password instead’”,“process”:“mysql”,“thread”:“main”,“timestamp”:“2025-04-15T03:40:21.998Z”}
{“class”:“Process”,“level”:“warn”,“message”:“2025-04-15T03:40:23.505294Z 2775 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ‘‘mysql_native_password’ is deprecated and will be removed in a future release. Please use caching_sha2_password instead’”,“process”:“mysql”,“thread”:“main”,“timestamp”:“2025-04-15T03:40:23.505Z”}
{“class”:“Process”,“level”:“warn”,“message”:“2025-04-15T03:40:25.176652Z 2776 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ‘‘mysql_native_password’ is deprecated and will be removed in a future release. Please use caching_sha2_password instead’”,“process”:“mysql”,“thread”:“main”,“timestamp”:“2025-04-15T03:40:25.177Z”}
{“class”:“Process”,“level”:“warn”,“message”:"2025-04-15T03:40:25.475948Z 2777 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: '‘mysql_native_password’ is deprecated and will be removed in a future release. Please use caching_sha2_password

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.

[Nick-B]

Hi @marypearson

So you exported wp_posts from your Time Machine backup and now need to reimport it into your Local site. Is that correct?

If that’s the case, you can click on Start Site, Database, and then open AdminerEvo. Once you’re inside the Adminer UI, there is an Import button on the upper left-hand side you can use to get that table into your site. After you’ve imported it, you may need to Stop/Restart your Local site.

Those warnings flooding the Local Log are something we are looking at removing soon and can be ignored for now.

[marypearson]

No, I downloaded wp_posts from AdminerEvo

[Nick-B]

Ah okay so the table is already in place on the correct site but the posts aren’t showing.

You’ll want to check and see if the post_status is set to publish. If it’s not then that’s why they aren’t showing up.

You can try running this SQL command to change that:

UPDATE wp_posts SET post_status = 'publish' WHERE post_type = 'post' AND post_status != 'publish';

[marypearson]

Only two rows were affected. This put 2 posts - auto draft into my Posts section, but there is still nothing in my Pages.

[Nick-B]

Maybe you could attempt to spin up a new, blank site, and then reimport the contents into the new install to start fresh. We have some steps on manually importing here you could use:

Manually Import a Local Site

[marypearson]

OMG Nick-B THANK YOU!!! That worked! I can’t believe it. Thank you sooooo much!!!

[Nick-B]

Glad to hear it @marypearson! Thank you for following up