How to restore your WordPress database from backup using phpMyAdmin

Here is a video tutorial for restoring your WordPress blog/ site contents from backed up database. I came across this highly useful video tutorial while searching for easy methods to reinstall lost posts of WordPress blogs and other sites like static sites powered by WordPress.

Why do you need this tutorial? Well, possibly, sometime or the other you may need such HOW TO videos and tutorials if you are serious about making a successful blog or site (and, of course, money), especially if you are not a techie who is well versed with codex and the complete knowledge about how WordPress, in conjunction with blog themes, plugins, server side applications of your webhosting companies, etc. publishes your blogs.

This tutorial assumes that you regularly backup your sites and that you have a fairly good working knowledge about phpMyAdmin, MySql databases, etc.

There are many important things to take care of while performing this backup. If you do certain things wrong, there may not be another option to try again, because there may be no ‘undelete’ or ‘undo’ options.

A few fairly reliable steps that you have to take care of are:

  1. Keep more than one backup and at different locations so that you can use them if everything goes wrong.
  2. Make sure that your hosting company does not limit your options by making undue restrictions and they will provide you complete support when you are in trouble. Unfortunately, many companies do not give actual technical support after you sign up with them. All hosting companies promise 24/7 support 365 days, but the support will be limited to opening a trouble ticket and a phone chat through which they tell you to follow steps that you may not understand. And the end result will be they blame you for what went wrong or blaming the software that you are using.
  3. So, because most companies keep backups of your sites and they can restore your site within minutes, if they want, it will be a very nice idea to contact your hosts technical support before you try your DO-IT-YOURSELF (DIY) plan. I suggest this because most of the times I had troubles, I got total support from my hosting companies (I use the services of three different hosts), and I did not have to struggle with technicalities that I am not familiar with.
  4. And finally, be ready to seek professional help if nothing works for you. I presume that you are well-informed of these steps, and I take no responsibility if you mess up everything. Also perform a Google search for more info on this topic. Perhaps you will come across better solutions than this.