Oh No! all of the blog posts and contents are deleted accidentally! Now, what to do? There are two options – you can either freak out or retrieve all of the lost contents from the Wordpress Database.

If you want to restore the “lost” web page contents, I can show you two easy steps to accomplish this job:

1. Check the revision date

This is probably the easiest step to retrieve the lost posts or contents. Open the WordPress edit page of the desired content or blog post. Scroll down towards the end and you will find a list of page revision. You just have to click on the revision date. It will take you to the last version of the page. Here you will find a whole bunch of restore dates. Click on the desired and bring back the early contents.

2. From the Database

2.1 Use Plugins

Restoring database can also help you to recover the deleted or modified data. But, how are you gonna do this? First, you can use plugins / MySql interface or retrieve the database manually. BackUpWordPress is the plugin appropriate for this job. You can also use the BackupBuddy plugin, which is actively protecting half a million WordPress sites since 2010. The use of plugin is similar to the free data recovery software. You can also use popular free plugins like Jetpack, Duplicator, UpdraftPlus WordPress Backup, and BackWPup.

2.2 Manually

Restoring Wordpress Database manually is a little-complicated job. But, if you have a fair knowledge about MySQL and coding, then the process would be much easier. Here, check this out:

Step 1: Stay logged out from the WordPress. It is important to stay logged out while doing restoration, because if WordPress recognizes anything out of order, it may attempt to recreate the content database.

Step 2: Never forget to take your Database backup. You can use phpMyAdmin for manual backup or any plugins to do the same job. If you are using the plugin, download the –main backup archive. You will find SQL within the archives, which includes the post, pages, and WordPress settings.

Step 3: Prepare your database. Before restoring the database, you may need to clean up the old contents. With MySQL Admin tool it is easy to clear the old contents. Open your PhpMyAdmin and click the ‘databases.’ Then you will find all of the WordPress tables are listed. Before restoring the database, you have to remove all of the existing tables. Click on the “check all” option and “drop” from the pull-down. You will be asked to execute the query. Click “yes” to clear those files.

Step 4: Import the database. You can import your database using phpMyAdmin easily. Just click on the “import” button. Then select the “choose file” button and pick up the desired SQL file that you want to import. Check the options as “default” and select the “Go” button.

Step 5: Merge the SQL files. If you have a small database combine the SQL in single file and then the task should be accomplished from a command line or a text editor. While importing the file you may find that your file size is too big and phpMyAdmin has a file size limitation.

Step 6: Don’t forget to validate the restores WordPress. The last step this process is to ensure that the backup database has restored properly. Select the “structure” link on the page and you will find the listed files.

Conclusion

The use of the plugin to recover the WordPress is a very efficient process. However, this using plugin is quite quite easy. If you are familiar with recycle bin recovery process, then you will find the process easy. On the other hand, the manual database recovery process is little complicated but certainly useful.

The post How to Recover all your Posts from a WordPress Database appeared first on WP Web Help.