Database is empty after restarting LocalWP

Bug Summary

The DB is empty after I restarted the LocalWP.
Opening DB with adminer proves that there are no tables there.

Steps to reproduce

  1. Import site from WPEngine.
  2. Make some adjustments to the code
  3. Check on local site that changes are applied.
  4. Close the LocalWP
  5. Hibernate laptop
  6. Open LocalWP
  7. Start the site.
  8. Open site link - WP installation process is opened
  9. Open adminer - no tables in the DB

Environment Info

  • Win 11 Pro x64
  • nginx, php 7.4.30, MySQL 8.0.16, WP 6.7.1
  • Local Version 9.0.5+6706

Supporting info

Also the site in question has no records in the log file (site name is “emlid3”)
local-lightning.log (289.5 KB)

Hi @Pavel

I just tested this on my Windows 11 setup but I couldn’t replicate it. Have you tested with a new blank site or any other sites to see if the same thing happens?

You might also run through our Windows guide here and make sure there are any blockers in place that could be preventing changes from getting saved properly.

1 Like

Thank you Nick for quick response.
I’ve looked through the article you provided. Nothing there that could help me.

Unfortunately, I cannot reproduce it myself right now, it looks like it was one-time issue.
There was another step, that couldn’t be reproduced. I started another site and tried to pull DB from WPE, there was an error and you can see it in the logs that I’ve attached above.

Could that DB pull issue cause that behavior with dropping all tables?

I don’t see any errors standing out in the log yet that could have caused that issue, but it’s possible there was a sync issue. Some of the sites in your account I can see are quite large, which in those cases it’s often better to download a backup and direct import it rather than trying to use the Local Connect sync. As a workaround for pushing you can use the free WPE migration plugin which will work from Local to WPE.

A few of the sites on your account I’ve checked also have a large number of plugins installed, mostly all outdated, so a plugin/theme conflict could also be another culprit.

1 Like

Is there any backup tool in Local? That issue has happened only because I had that database only in local env, and WPE has already rewritten that old database in backups. (more than 90 days passed)

Local has a Cloud Backups Add On tool:

Cloud Backups

You can also always use Local’s native export feature to create a manual backup zip copy that can be stored on your device or in your own cloud storage.

Of course any other backup plugins should work fine, but you’ll want to be careful if creating backups that are then saved within your site files as those can bloat your site’s overall size.

Thank you. Although it’s not resolving my issue, I will mark your response as solution for prevention of data loss.

1 Like

Sounds good @Pavel! If you have any other questions or concerns don’t hesitate to reach back out. We are always happy to help!

This topic was automatically closed 36 hours after the last reply. New replies are no longer allowed.