There are several restore scenarios that need to be considered:
- Restore a single page post.
- Restore from a corrupt Database
- Restore from a corrupt Database and lost files
Recovering A Single Page or Post
Since WordPress 2.6 WordPress has incorporated two new features designed to make editing pages and posts easier and more secure.
These features are designed to allow you to recover from connection errors and editing mistakes. The features are called Autosave and Revisions.
The video below overview of the Autosave and revision features and how they are used. Showing how to recover a previous page/post and how to revert back to an auto saved version of a post/page.
You can also watch on Youtube.lease don’t forget to comment.
You are allowed 25 revisions which are created when you manually save/update a page or post but only one auto save.
While you are editing a page/post any changed are automatically save every minute each auto save overwrites the previous one.
If you have browser crash or loose connection to the WordPress server or just forget to save your edits then the auto save feature can be used to restore your edits.
You cannot turn the features off in the WordPress settings they are present and enabled by default.
However by changes to the wp-config file you can modify the autosave interval (6o seconds) and turnoff revisions.(not recommended)-http://codex.wordpress.org/Editing_wp-config.php
Recovering A Corrupt Database
If the MYSQL database has become corrupted or even deleted then you will first need to recreate the database.
The first scenario I want to take you through is a database restore in the event of a corrupt or damaged database.
I am assuming that the database still exists, if not you will need to recreate the database with the same name and assign a database user fro wordpress.
The necessary information you will find in the config.php file.
All hosting providers provide access to phpadmin which will allow you to manage your MYSQL databases and do a restore.
In order to do a restore you obviously need to have a database backup. This can be from the db-backup plugin, or a manual backup using cpanel or phpadmin.
The Video takes you through using the PHPMyadmin interface.
If you are missing the import tab then you need to upload the backup file by clicking the SQL tab and uploading the file using the browse button to locate it and then click GO (see screenshot).
If your host uses cpanel then you can do the restore using backup wizard located under the Files Menu.
Recovering from a corrupt Database and Lost Files
In this case you will first need to restore your WordPress files using ftp.
This assumes that you have been backup up the site root directory files as covered in the backup section.
In which case you simply connect to your site using an ftp client and upload the files to your host.
After you have restored the files you can now restore the database.
