{"id":325,"date":"2020-03-20T23:47:34","date_gmt":"2020-03-21T03:47:34","guid":{"rendered":"http:\/\/www.reginedeguzman.com\/blog\/?p=325"},"modified":"2020-09-09T23:25:38","modified_gmt":"2020-09-10T03:25:38","slug":"migrating-wordpress-to-aws","status":"publish","type":"post","link":"http:\/\/www.reginedeguzman.com\/blog\/migrating-wordpress-to-aws\/","title":{"rendered":"Migrating WordPress to AWS"},"content":{"rendered":"<style type=\"text\/css\"><\/style>\n<p>How to migrate your WordPress website from a hosted provider to AWS.<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>Download all the website files from the hosted server.<\/li><li>Export your MYSQL database (be sure to select the option to include all tables) into a .sql file<\/li><li>Create a MYSQL database in AWS RDS<\/li><li>Using a database client &#8211; run the .sql file you exported. <ol><li>If you want to use the table you created in RDS, delete this line:<br><code>CREATE DATABASE IF NOT EXISTS &lt;OLD DATABASE TABLE NAME&gt; DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci; USE &lt;OLD DATABASE TABLE NAME&gt;;<\/code><\/li><\/ol><\/li><li>Create a Ubuntu 16.04 AWS EC2 instance. Follow the directions <a rel=\"noreferrer noopener\" aria-label=\"here (opens in a new tab)\" href=\"http:\/\/www.reginedeguzman.com\/blog\/installing-wordpress-on-a-ubuntu-aws-instance-using-a-mysql-rds\/\" target=\"_blank\">here<\/a>.<ol><li>Instead of installing the WordPress tarball, move all the website files you downloaded from the previous hosted server, to <code>\/var\/www\/html<\/code>.<\/li><\/ol><\/li><li>Update the <code>wp-config.php<\/code> with the RDS database info.<ol><li>Under <code>DB_HOST<\/code> include <code>:3306<\/code> after the RDS endpoint.<\/li><\/ol><\/li><li>Create a new Route53 hosted zone for your domain.<\/li><li>Export your DNS hosted zone from GoDaddy DNS management.<\/li><li>Import the exported .txt file into Route53.<\/li><li>In the GoDaddy DNS management, change the Nameservers to the AWS Route53 Nameservers.<\/li><li>Change the domain&#8217;s &#8220;A Name&#8221; to your EC2 instance public IP address.<\/li><\/ol>\n","protected":false},"excerpt":{"rendered":"<p>How to migrate your WordPress website from a hosted provider to AWS. Download all the website files from the hosted server. Export your MYSQL database (be sure to select the option to include all tables) into a .sql file Create a MYSQL database in AWS RDS Using a database client &#8211; run the .sql file&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[38],"tags":[62,69,60],"class_list":["post-325","post","type-post","status-publish","format-standard","hentry","category-tech-2","tag-aws","tag-hosting","tag-wordpress"],"_links":{"self":[{"href":"http:\/\/www.reginedeguzman.com\/blog\/wp-json\/wp\/v2\/posts\/325"}],"collection":[{"href":"http:\/\/www.reginedeguzman.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.reginedeguzman.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.reginedeguzman.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.reginedeguzman.com\/blog\/wp-json\/wp\/v2\/comments?post=325"}],"version-history":[{"count":3,"href":"http:\/\/www.reginedeguzman.com\/blog\/wp-json\/wp\/v2\/posts\/325\/revisions"}],"predecessor-version":[{"id":346,"href":"http:\/\/www.reginedeguzman.com\/blog\/wp-json\/wp\/v2\/posts\/325\/revisions\/346"}],"wp:attachment":[{"href":"http:\/\/www.reginedeguzman.com\/blog\/wp-json\/wp\/v2\/media?parent=325"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.reginedeguzman.com\/blog\/wp-json\/wp\/v2\/categories?post=325"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.reginedeguzman.com\/blog\/wp-json\/wp\/v2\/tags?post=325"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}