What issue or error are you experiencing?
This issue is restoring a local.sql file from two days ago to replace the one that may be corrupted.
What steps can be taken to replicate the issue? Feel free to include screenshots, videos, etc
Hoping this is the right place to post; I am requesting support team, maybe Clay, to verify these steps. As of this writing, I have not tried this myself, but this is the result of my research. Please make corrections and let me know. I need to restore my database from a previous backup!!!
How to use Adminer to Restore a local.sql database from a previous local.sql database backup. Is this correct?
-
Backup the site using another backup software, for example Backu4All (whole computer and selective directories backup) or updraftplus (which allows saving database backup offline).
(A local.sql backup can also be created by exporting the current database to another directory via Adminer as followes: With the site started, open Adminer. Click Export. Output: save, Format SQL. Click the smaller Export button.) -
Stop the Site: Check that a new local.sql file was created when the site stopped in the local backup directory: …\Local Sites\devDirectory\app\sql
-
Copy and paste the existing local.sql database (even if its corrupt) to another directory somewhere for safe keeping.
-
Copy a selected previous backup to …\Local Sites\devDirectory\app\sql
– Select the desired previous version of local.sql file.
– Navigate to the local sites backup directory …\Local Sites\devDirectory\app\sql
– Double-check that a copy of the current local.sql file was made; THE NEXT STEP WILL OVERWRITE THE CURRENT LOCAL.SQL FILE.
– Paste the selected local.sql backup file to …\Local Sites\devDirectory\app\sql -
From Adminer, Import the just pasted SQL File.
– Restart the site in Local.
– Open Adminer.
– Click the Import button, click Browse to navigate to the …\Local Sites\devDirectory\app\sql directory
– Select the newly pasted local.sql file.
– Click Execute. This will replace the existing database contents with the data from the backup. -
Verify the Import:
– After importing, check the WordPress site to ensure that the database has been restored correctly.
– Verify that the posts, pages, and other data match the state from expected from the backup. -
Troubleshooting:
– If the changes do not reflect immediately, clear the browser cache or use a different browser to check the site.
– Ensure that there are no errors during the import process in Adminer.
– If the data isn’t as expected, restore a differenct local.sql backup
– In the worst case, restore from you updraftplus backup.
System Details
- Local Version:
9.02+6676 - Operating System (OS) and OS version:
Windows 10
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.