{"id":2468,"date":"2013-11-20T22:49:11","date_gmt":"2013-11-20T22:49:11","guid":{"rendered":"http:\/\/www.softwareeverydayblog.com\/?p=2468"},"modified":"2013-11-21T09:01:11","modified_gmt":"2013-11-21T09:01:11","slug":"wordpress-backup","status":"publish","type":"post","link":"https:\/\/www.softwareeverydayblog.com\/?p=2468","title":{"rendered":"WordPress Backup"},"content":{"rendered":"

WordPress Import\/Export<\/a><\/strong>
\nWordpress allows you to export your ‘content’ in xml format. it then allows you to imports that content in a wordpress instance. The tool allows you to import data from various sources (e.g. Live Journal, Tumblr etc). Seems quite straightforward however the wordpress import\/export have some caveats.<\/p>\n

    \n
  1. It requires you to add users on the site before you import.<\/li>\n
  2. If the exported file is very large, the import script may run into your host’s configured memory limit for PHP.<\/li>\n
  3. If the import process is run again with the same data file after stopping midway through, it could result in duplicate data, missing data or other errors in the destination database.<\/li>\n
  4. Some discussion<\/a> about whether this process does or does not import images, files (or content in general). In my experience the imported posts have links to content residing in the wp-content of the site that I exported from.<\/li>\n<\/ol>\n

    Manual Import Export<\/strong>
    \nI instead choose to do a manual import export of my wordpress blog. Below are the steps that i carried out an exact clone of my blog www.softwareeverydayblog.com on my local box.<\/p>\n

      \n
    1. Take a mysql backup of the my wordpress DB.<\/li>\n

      \"mysql_backup\"<\/a><\/p>\n

      \"mysql_backup2\"<\/a><\/p>\n

    2. Manually create a database ‘softwareeveryday’ on my local mysql instance. Import the db using the mysql back script into this fresh db ‘softwareeveryday’ that we just created.
      \nC:\\scipts>c:\\wamp\\bin\\mysql\\mysql5.5.24\\bin\\mysql -u root -p < softwareeveryday.sql softwareeveryday<\/strong>
      \nEnter password:\n<\/li>\n
    3. Copy the wordpress files using FTP somewhere into our apache home directory. Change wp-config.php to reflect local box settings.<\/li>\n
    4. At this point, we bring up our apache server and the wordpress blog should appear. There is one issue, there are yet some references to https:\/\/www.softwareeverydayblog.com. We’ll need to make some changes in the database to get rid of those references. Change wp_options table, set wp_options to point to localhost address where option_name is ‘siteurl’, ‘home’.<\/li>\n
    5. All the content that I uploaded (like images) is yet pointing to https:\/\/www.softwareeverydayblog.com\/wp-content\/uploads\/2013\/05\/some_image.jpg. Now I notice that within the wp_posts, all posts have href hardcoded to softwareeverydayblog.com. You can use this tool<\/a> to replaces the urls. The advantage over SQL replace is that the tool know how to handle serialized info in the DB. Refer to stackoverflow<\/a> answer for more.<\/li>\n<\/ol>\n

      If you want to skip the last step of making DB changes, we could change our hosts file so that requests to softwareeverydayblog.com point to 127.0.0.1. I personally prefer to change my hosts file. I also soon realized that it\u2019s NOT possible to redirect using hosts file. For example the following entry is NOT possible.<\/p>\n

       \r\n# redirects not allowed in hosts file\r\n127.0.0.1\/softwareeverydayblog\/wordpress-3.4.2\/\t\tsoftwareeverydayblog.com\r\n<\/pre>\n<\/li>\n
      Instead we could add a simple hosts entry, and add redirects in the local apache server to redirect all requests to softwareeverydayblog.com to the wordpress directory.<\/p>\n
        \n
      1. Add the following entries in hosts file.\n
         \r\n127.0.0.1\t\twww.softwareeverydayblog.com\r\n127.0.0.1\t\tsoftwareeverydayblog.com\r\n<\/pre>\n<\/li>\n
      2. Add the following entry to httpd-vhosts.conf for redirects. With this all requests to softwareeverydayblog.com on this apache server will be served files from “C:\/www\/softwareeverydayblog\/wordpress-3.4.2” which is our wordpress directory.\n
         \r\n\r\n    ServerAdmin webmaster@dummy-host.example.com\r\n    DocumentRoot \"C:\/www\/softwareeverydayblog\/wordpress-3.4.2\"\r\n    ServerName softwareeverydayblog.com\r\n    ServerAlias www.softwareeverydayblog.com\r\n    ErrorLog \"logs\/softwareeverydayblog.com-error.log\"\r\n    CustomLog \"logs\/softwareeverydayblog.com-access.log\" common\r\n<\/VirtualHost>\r\n<\/pre>\n<\/li>\n
      3. I also uncommented the following line from httpd.conf\n
         \r\nInclude conf\/extra\/httpd-vhosts.conf\r\n<\/pre>\n<\/li>\n<\/ol>\n
        Blog works fine now. Links yet show https:\/\/www.softwareeverydayblog.com but files are being served from the local box.<\/p>\n","protected":false},"excerpt":{"rendered":"
        WordPress Import\/Export Wordpress allows you to export your ‘content’ in xml format. it then allows you to imports that content in a wordpress instance. The tool allows you to import data from various sources (e.g. Live Journal, Tumblr etc). Seems quite straightforward however the wordpress import\/export have some caveats. It requires you to add users […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-2468","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/www.softwareeverydayblog.com\/index.php?rest_route=\/wp\/v2\/posts\/2468","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.softwareeverydayblog.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.softwareeverydayblog.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.softwareeverydayblog.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.softwareeverydayblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2468"}],"version-history":[{"count":11,"href":"https:\/\/www.softwareeverydayblog.com\/index.php?rest_route=\/wp\/v2\/posts\/2468\/revisions"}],"predecessor-version":[{"id":2473,"href":"https:\/\/www.softwareeverydayblog.com\/index.php?rest_route=\/wp\/v2\/posts\/2468\/revisions\/2473"}],"wp:attachment":[{"href":"https:\/\/www.softwareeverydayblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2468"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.softwareeverydayblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2468"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.softwareeverydayblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2468"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}