{"id":144,"date":"2008-02-17T09:59:19","date_gmt":"2008-02-16T23:59:19","guid":{"rendered":"http:\/\/www.seawind-network.com\/20080217\/restoring-wp-database-in-an-offsite"},"modified":"2008-02-17T09:59:19","modified_gmt":"2008-02-16T23:59:19","slug":"restoring-wp-database-in-an-offsite","status":"publish","type":"post","link":"https:\/\/www.rommelpascual.com\/index.php\/20080217\/restoring-wp-database-in-an-offsite\/","title":{"rendered":"Restoring WP Database in an Offsite"},"content":{"rendered":"
\n\t\t\t\t\tTweet<\/a>\n\t\t\t\t<\/div><\/div>

Did I say – “I don’t know what I enjoy most – blogging or learning all about WordPress” ?<\/p>\n

Well, keeping in line with my original objective why I set this blog in the first place, I spent some time learning how to restore a WP database in another site. In this case, on my Ubuntu Gutsy (7.10) at home. I’ve set the main blog site to backup every week and email the compressed backup file. Note however, that this is not a complete backup but rather just all the text found in the site. Any uploaded images\/attachments are not included in this backup.<\/p>\n

Here are my findings:<\/p>\n

    \n
  1. Upon restore, viewing the test site will attempt to redirect to the original site. The reason being that the site setup are also contained in the database that was restored.<\/li>\n
  2. You should login as admin by going directly to the login page e.g. https:\/\/localhost\/subdir\/wp-login.php then go directly to the Options tab and change the URLs accordingly.<\/li>\n
  3. Then go to the Permalinks tab and rebuild it. Unfortunately for me, the URL re-write of my Apache installation was not working, so I set this to the default, effectively disabling Permalink in the test site. This means that posts are access with the odd series of ? and # e.g. https:\/\/localhost\/?p=123#comments.<\/li>\n<\/ol>\n

    That’s it. Even if you do not know how to restore a WP Database – you should still take a backup and keep it somewhere other than your site. Someone can always help you restore it on another site when needed. To be totally safe – keep a backup of your \/wp-content directory as well.<\/p>\n","protected":false},"excerpt":{"rendered":"

    A brief description on restoring a WordPress database SQL backup into a different site. It contains notes on the experience, problems encountered and gotchas. Overall – it’s a simple process but assumes some SQL admin knowledge.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ngg_post_thumbnail":0,"footnotes":""},"categories":[16],"tags":[],"class_list":["post-144","post","type-post","status-publish","format-standard","hentry","category-evaluation"],"_links":{"self":[{"href":"https:\/\/www.rommelpascual.com\/index.php\/wp-json\/wp\/v2\/posts\/144","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rommelpascual.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rommelpascual.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rommelpascual.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rommelpascual.com\/index.php\/wp-json\/wp\/v2\/comments?post=144"}],"version-history":[{"count":0,"href":"https:\/\/www.rommelpascual.com\/index.php\/wp-json\/wp\/v2\/posts\/144\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.rommelpascual.com\/index.php\/wp-json\/wp\/v2\/media?parent=144"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rommelpascual.com\/index.php\/wp-json\/wp\/v2\/categories?post=144"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rommelpascual.com\/index.php\/wp-json\/wp\/v2\/tags?post=144"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}