At ManageWP, we are working very hard to make backing up, restoring, and cloning your WordPress websites as easy and intuitive as possible. On the blog, we have previously discussed how to move your WordPress site to a new hosting provider, and how to restore a damaged/destroyed site to its former glory. Those two articles give you all the information you need in order to use ManageWP to restore your site in the fastest possible way.
But it is always good to have redundancies in place, and any web developer worth his or her salt should know how to manually restore a damaged or deleted WordPress site.
The following steps assume that you have a functional installation of WordPress active on your site. If this is not the case, follow these instructions for installing WordPress before proceeding.
Step 1 – Grab Your Backup Files
One of the very first things you should do when signing up for ManageWP is set up scheduled backups. We advise that you perform a full backup every week, and a database backup every day. We also strongly suggest that you export your downloads to one of the five external locations/methods that ManageWP offers – Amazon S3, Dropbox, Google Drive, FTP, or email. If your backups aren’t external and your entire site gets wiped, the backups will disappear along with the rest of your data.
When it comes to restoring a site, the first thing you need to do is get your hands on the files and folders that you will be restoring. If you have set up regular scheduled backups with ManageWP, doing so is a piece of cake.
In your ManageWP dashboard, click on “Backups” in the top navigation menu under “Protect”, then “View Backups” under the relevant backup schedule. You will then be presented with a list of backups for you to choose from. Download the ZIP file you need to a convenient location on your PC.
Step 2 – Upload Your Database
Your site’s database includes all of the vital raw data for your site – posts, pages, comments, settings, and so on. It is almost definitely the most important part of your site. Getting it back up and running should be your first priority.
In order to do so, you will need to access phpMyAdmin, which is something that should be available on your hosting provider’s control panel. If it is not, contact your host for information on how to access phpMyAdmin.
Once you have logged in, you need to ascertain whether or not your database is intact. Click on “Databases” (please note, the follow screenshots may not look the same on your system, but they should be similar):
If your database no longer exists, you will not find it listed. In such cases, you need to create one (this option should be right in front of you).
If your database does still exist, you need to click on it and “Drop” all of the remaining tables within:
Once you have confirmed the “Drop” of your tables, you will be left with a shell into which you can insert your unscathed backup database file.
Next, click the “Import” option in the navigation bar at the top of your screen. Remember the backup file you unzipped earlier? Go back to that, and find a folder within named “mwp_db”. You will find your backup database file inside, which you can upload on the Import screen.
As you can see from the above screenshot, there is a size restriction on the file. If your database file is larger than 9mb, you can compress it in order to bring it under the limit.
That’s it! If you attempt to access your site now, you should find that the content of your site has been restored. But your themes, plugins and media will all still be missing. So what next?
Step 3 – Upload Files To Your Site Via FTP
Your database is the only “sensitive” data that needs to be properly uploaded and installed via phpMyAdmin. All other data can simply be uploaded via FTP. However, you will of course need to make sure that you upload the files and folders to the correct location.
Login to your website via your FTP client and navigate to the root directory. Your backup folder will contain a comprehensive list of files and folders. Depending upon the state of your site, you will need to upload either some or all of them. If you are in any doubt, it is easier to simply copy the full contents of the folder, and overwrite files as and when it is necessary. If you feel uneasy about doing so, feel free to take a backup first. If your site has been completely wiped, you will need to transfer the entire backup folder via FTP.
That’s It!
Your site should now be restored to its former functioning self. Although the process is certainly more cumbersome than ManageWP’s WordPress website backup/restore tool, this method is useful to have to hand as a last resort.
Blog post updated on June 16, 2014
Creative Commons image courtesy of Alex Proimos
Betty Linn
You can now use Backup& Restore Dropbox plugin on WordPress for all your files. You only need to link it to your Dropbox account and it automatically backs everything up. It is free and easy to install.
fasco
I was unable to renew my hosting plan on time.
4 months later
all my webpage content was lost.
Had no backup from my web builder nor my server.
How can i recover .
Dont wanna start afresh.
Adeduro Solomon Anjorin
Hello!
I make a mistake to deleted a content on my site. but surprise to me, I can’t access to post asked me to restored my item and try again. please how do I go about it. thanks.
Zac Harris
I have overwrite on the members area section. and now members area is disappeared. how can i have it back? Thanks.
Ariel
Hi Tom,
Thank you for your concise and easy-to-follow directions! I have a question that I can’t seem to find an answer to anywhere on the web….I am moving a site from one server to another. I have my backup files all ready and have logged into phpMyAdmin but I see 4 items under ‘Database’.
Which one do I select to restore?
Thank you!
Ariel
Jai
Hi,
I have made a terrible mistake. I wanted to change my username without me realising that once I do it, it will automatically replace my old wordpress site related to my username.
I wanted my old site back and the facebook shares included there, also the comments, likes and followers I have already gained.
Could someone help me fix it from the support system of wordpress?
Thanks.
Sincerely yours,
Jai
suraj singh
Hi TOM, there is some problems in my site.
my themes are changing itself interchangeably with the previously installed themes(which i have installed before). Its very strange for me that lots of time the themes i have installed are lost after some time and other themes which i installed previously gets activated. Again after sometimes, same things happened and again presently existing (installed as well as the activated ones) themes are replaced by the previous themes. Because of this problem, none of my plugin is working properly. While making any change to my plugins and then saving their settings, they are always making me redirect to ‘404 page Not Found’. and the post which i have published before some time are lost because of the change in the existing active theme. I’m facing this problem from last 1 to 2 days.
my site http://surajsingh.in/
My question is–
1. Is it a better option to restore my website backup to solve this problem completely?
2. Should i format my complete website before restoring or i should simply upload my backup from c panel without removing the existing database?
3. In such conditions if i opt to restore my website backup, is there any negative effect on my SEO of restoring backup.
4. Restoring my website backup from C Panel >> Backups(partially), will solve my above explained problem or not?