{"id":9692,"date":"2009-10-05T21:06:07","date_gmt":"2009-10-05T15:36:07","guid":{"rendered":"https:\/\/www.quickonlinetips.com\/archives\/?p=9692"},"modified":"2020-05-29T18:25:36","modified_gmt":"2020-05-29T12:55:36","slug":"backup-restore-wordpress-database","status":"publish","type":"post","link":"https:\/\/www.quickonlinetips.com\/archives\/2009\/10\/backup-restore-wordpress-database\/","title":{"rendered":"How To Backup and Restore WordPress Database"},"content":{"rendered":"

How can you backup and restore your WordPress blog database? If you\u2019ve been blogging long enough, you might have heard the words \u201cBackup Your WordPress Database Regularly<\/strong>!\u201d Well, this is quite true. Don\u2019t take it with a pinch of salt! <\/em>A healthy backup of your database could one day be THE ONLY<\/strong> means of restoring your blog should something go wrong such as a bad plug-in installation or an attack by blog hackers.<\/p>\n

For a second time since I started blogging, this database backup of a thing, as some would call it, has saved me a lot of headache. Recently I messed up my blog\u2019s permalink structure<\/a> and my saving grace was the day before\u2019s database backup.<\/p>\n

DISCLAIMER:<\/span> <\/strong>This tutorial is provided as it is. I shall not be held responsible in any way should you encounter problems like loss of database and entire blog\/website along the way. Use this at your own discretion. It worked EXCELLENTLY well for me and should do the same for you hopefully!<\/p>\n

How to Backup WordPress Database.<\/h2>\n

1.\u00a0 Download, install and activate WordPress Database Backup\u00a0available at\u00a0austinmatzko.com\/wordpress-plugins\/wp-db-backup\/<\/p>\n

2. Go to Tools in the sidebar of your dashboard and click on Backup<\/p>\n

\"wordpress-restore-01\"<\/p>\n

Under Backup options as shown below, select “Download to your computer” and click on “Backup Now”. When the backup is done you\u2019ll be given an option to choose where to save the backup. Save the backup and you\u2019re done.<\/p>\n

\"wordpress-restore-02\"<\/p>\n

Note: <\/strong>I strongly advice you schedule a daily backup of your database as issues could arise at ANY TIME<\/strong>. Simply navigate down the Backup option page to Scheduled backup. Select the once daily option and select which tables you\u2019d like included in the backup. Type in your email address, click the schedule backup button and all is well. Check to see if your first backup gets delivered successfully the next day.<\/p>\n

\"wordpress-restore-03\"<\/p>\n

How To Restore WordPress Database<\/h2>\n

The guide below will help you restore your database in no time using the backups that have been made in the past. I\u2019m assuming that your current database has been damaged or is behaving erratically.<\/p>\n

1. Log into your FTP account and Delete everything in the \/wp-content\/cache<\/em> directory.<\/p>\n

2. Log into PHP MyAdmin and select your wordpress database.\u00a0 It\u2019s mandatory you remember clearly well the name of your wordpress database especially if you auto-installed it using Fantastico.<\/p>\n

\"wordpress-restore-04\"<\/p>\n

A list of all of the tables contained in the database will be shown. As shown below, click on Check all to select all the tables then select the Drop option to delete them PERMANENTLY<\/strong>.<\/p>\n

\"wordpress-restore-05\"<\/p>\n

You\u2019ll be prompted to confirm the Drop action<\/p>\n

\"wordpress-restore-06\"<\/p>\n

Choose Yes and all tables will be DELETED<\/strong> with this result displayed on your computer screen<\/p>\n

\"wordpress-restore-07\"<\/p>\n

Now that the database for wordpress is empty, let\u2019s proceed to uploading our database backup file<\/p>\n

\"wordpress-restore-08\"<\/p>\n

Click on the Import menu as shown above and then browse to the location of the backup file as shown below. Once you\u2019ve done that, click on go and wait for the upload process to finish.<\/p>\n

\"wordpress-restore-09\"<\/p>\n

A successfully database restoration will show you something similar to the message below<\/p>\n

\"wordpress-restore-10\"<\/p>\n

Once the whole restoration process is done, log into your dashboard and make sure everything is working okay. Don\u2019t forget to browse your site to see if it\u2019s functioning as expected.<\/p>\n

This guest post was written by Udegbunam Chukwudi who shares <\/tt>make money online and blogging tips\u00a0on strictlyonlinebiz.com,\u00a0his PR 2 dofollow blog. You can also write a guest article<\/a> and share your WordPress tips.<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"

How can you backup and restore your WordPress blog database? If you\u2019ve been blogging long enough, you might have heard…<\/p>\n","protected":false},"author":4,"featured_media":9715,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","footnotes":""},"categories":[6,25],"tags":[44,49,17],"class_list":["post-9692","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blogging","category-domain-hosting","tag-guest-posts","tag-tutorials","tag-wordpress"],"_links":{"self":[{"href":"https:\/\/www.quickonlinetips.com\/archives\/wp-json\/wp\/v2\/posts\/9692","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.quickonlinetips.com\/archives\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.quickonlinetips.com\/archives\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.quickonlinetips.com\/archives\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.quickonlinetips.com\/archives\/wp-json\/wp\/v2\/comments?post=9692"}],"version-history":[{"count":0,"href":"https:\/\/www.quickonlinetips.com\/archives\/wp-json\/wp\/v2\/posts\/9692\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.quickonlinetips.com\/archives\/wp-json\/wp\/v2\/media\/9715"}],"wp:attachment":[{"href":"https:\/\/www.quickonlinetips.com\/archives\/wp-json\/wp\/v2\/media?parent=9692"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.quickonlinetips.com\/archives\/wp-json\/wp\/v2\/categories?post=9692"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.quickonlinetips.com\/archives\/wp-json\/wp\/v2\/tags?post=9692"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}