How to Migrate WordPress Website From GoDaddy to AWS

Already having a WordPress website up and running on another web host? Now, are you thinking of moving it to a new hosting provider? It can be a little intimidating task. Many people often asked a list questions like: How to Migrate WordPress Website from GoDaddy to AWS? How do I get started? Will my site go down while I’m moving it? What do I do to make sure I don’t lose any files? Well, we’ve put together a guide to help you out.

Benefits of Migrating to AWS

The benefits of AWS and cloud computing overall are significant. … Thus, the total market spend for cloud computing will increase from $23.8B to $39.4B (66%). Cloud computing is here. Leveraging the benefits of AWS can dramatically increase both the effectiveness and efficiency of your company.

  • Cost-Effective – Consume only the amount of compute, storage and other IT resources needed. No long-term commitment, minimum spend or up-front investment is required.
  • Elastic and Scalable – Quickly add and subtract resources to applications to meet customer demand and manage costs. Avoid provisioning resources up-front for projects with variable consumption rates or short lifetimes.
  • Experienced – Leverage Amazon.com’s 15+ years of experience delivering large-scale, global infrastructure. Benefit as AWS continues to hone and innovate its infrastructure management capabilities and skills.
  • Flexible – Use familiar architectures, databases, operating systems and programming languages. Improve overall productivity and time to market without the need for IT to learn new skills.
  • Security – AWS builds and delivers its services in accordance with the industry’s highest and stric security best practices. AWS conducts regular and thorough audits to demonstrate the security of its infrastructure.

How do I Migrate WordPress website from GoDaddy to AWS?

Here are the steps to move your WordPress blog website setup off from Amazon Web Services (AWS) Windows Server 2012 instance to GoDaddy Managed WordPress hosting.

Amazon Web Services (AWS) Windows Server 2012 instance:

  1. Backup your WordPress IIS Web Folder
  2. Backup your WordPress MySQL DB using
  1. Export to Dump Project Folder (recommended if you have large size tables in your DB, generates .SQL file for each table, using this .SQL file you can recreate the same table on other DBs)
  2. Export to Self-Contained File (recommended for small size tables usually for small websites, so that all tables data will be combined into a single .SQL file)

Update .SQL files exported from AWS with the new GoDaddy’s MySQL DataBase and table names

  1. Update your exported .SQL files to reflect the new DataBase and table names
  1. By default when you export your WordPress MySQL tables into .SQL file it will contain your DB and table names.
  2. This results in error if you try to import these files into different MySQL or GoDaddy server
  3. You need to update the exported .SQL files with the new GoDaddy’s MySQL database and table names
  4. Find the SQL Database name and WordPress table prefix from GoDaddy’s setup
  1. Make a note of your phpMyAdmin Url and login Details from GoDaddy WordPress hosting setting page
  2. Login to phpMyAdmin URl with the credentials
  3. You’ll find the database name in the left pane of phpMyAdmin
  4. First you need to find the new Database prefix used on your GoDaddy WordPress installation which you can find in wp-config.php file on GoDaddy SFTP folder.
  5. In wp-config.php file, you can find the prefix mentioned in “$table_prefix”  variable

Update exported .SQL files

  1. You can apply the change either to just Self-Contained File or each .SQL file of exported Dump Project Folder
  2. Given that you’ll have the DB already created, you can DELETE the first line of exported .SQL files which reads DB creation command like below
  1. CREATE DATABASE  IF NOT EXISTS `wordpress0073` /*!40100 DEFAULT CHARACTER SET utf8 */;

Search and REPLACE the WordPress database name to be used in each .SQL file

  1. It’s usually be the second line in your exported .SQL file
  2. it looks as: USE `wordpress0073`;
  3. Replace the DB name with your WordPress MySQL DB name
  4. Replace it across all the .SQL files

Replace the table names since the GoDaddy WordPress uses a different prefix

  1. in each of the .SQL file, search and replace the OLD wp_prefix_<tablename> with NEW wp_prefix_<tablename> globally.

GoDaddy Managed WordPress hosting:

  • Download Pdf
  • Address Changes
  • Well
  • Amazon Web
  • Aristotle Categories
  • Backups
  • Blog Website
  • Buy domain name
  • Credential
  • Dashboard
  • Download Pdf
  • Address Changes
  • Well
  • Amazon Web
  1. Start your new managed WordPress site on a temporary domain/website
  1. Choose “Use the temporary domain <tempodomainname>.myftpupload.com”
  2. Set your temporary site WordPress Adin login details
  1. New WordPress username
  2. Email address
  3. New WordPress password

Use your WordPress admin login to get into the dashboard view of your WordPress site.

Upload your WordPress web site content files

  1. Make a note of your SSH and SFTP hostname and login Details
  2. Using WinSCP, SFTP to the GoDaddy’s SFTP host
  3. Copy your WordPress Folder\wp-content folder to your /home/<your-godaddy-username>/html/wp-content folder
  1. to ensure successful copy, verify the files and folder size and count once copy is complete
  2. do not delete/remove /wp-content/mu-plugins folder

Upload your MySQl DataBase files

  1. Make a note of your phpMyAdmin Url and login Details
  2. Take a backup of the default MySQl tables, just in case if you need to restore anything back.
  3. Delete all the existing tables from your MySQL instance database
  4. Use “Import” option to load all your WordPress MySQL tables
  1. Click on Choose File and select
  1. modified “Self-Contained File” Or
  2. each of the modified SQL files of “Export to Dump Project Folder”

Upon successful import of all .SQL files, verify the overall Rows in each table and table sizes

Update the wp_prefix_usermeta and wp_prefix_options tables with new “wp_prefix_” for below keys:

  1. To find the key with old wp_prefix use below queries
  1. <wp_*>_capabilities:  Select * from wp_prefix_usermeta WHERE meta_key LIKE ‘wp_%’
  2. <wp_*>_user_roles:  Select * from wp_prefix_options WHERE option_name LIKE ‘wp_%’

You’ll primarily need to update below two key names, I recommend manual update to avoid any unexpected updates using SQL queries.

  1. In wp_prefix_usermeta table, rename
  1. <wp_*>_capabilities to <wp_newprefix>_capabilities

In wp_prefix_options table, rename

  1. <wp_*>_user_roles to <wp_newprefix>_user_roles

Update your GoDaddy Managed WordPress domain to use your actual website domain name

  1. Logon to GoDaddy’s WordPress Hosting GateWay to see your managed wordpress site
  2. Click on Settings > Add Domain > provide your domain name, if your domain is also from GoDaddy you’ll see it automatically populated for you.

Ensure your website Domain name is pointing to the correct name server and the DNS zone has entry of your new GoDaddy hosting DNS server IP-address

  1. In case your domain name as well is hosted on GoDaddy, you just need to set your domain name server settings to use Standard option for setup type.
  2. Standard option for GoDaddy’s name servers, automatically connects your domain to GoDaddy’s DNS ZONE FILE.
  3. You’ll notice a preconfigured “A (Host)” record existing and pointing to your WordPress DNS IP-Address.
  4. if you have updated the DNS for your website, you’ll need to wait for couple of hours or days for your domain IP address changes to propagate across the geographical locations.

Now logon to your WordPress website admin dashboard using: www.<Your Domain Name>/wp-admin

Note, since we restored the wp_prefix_users.SQL file from previous AWS installation, the username and password as well will be restored to the WordPress admin setup previously.

AWS vs. GoDaddy

Depending on your needs, you will need to consider which one is better for your site.  Factors such as pricing, customer support, speed, value, the features, and the down/uptime should help you decide.  Here is how those factors can play into your decision.

Customer Support

AWS offers a lot of support with their products.  Blogs, a contact us link, discussion forums, help, live chats, and support allow anyone to connect with a representative.  GoDaddy has online storage, product support, submit support tickets, and transfer a domain.  The customer support from both sides is about equal, with different options for you.  It’s difficult to say which one is better because they offer vastly different types of support.  If you need to connect with someone right away, AWS would be the better option.  If you need some support for products, GoDaddy would be the better choice.

Value

If you can afford the price of AWS, the value would be better.  Since you’re getting a lot more disk space with AWS, it may be worth the higher price tag.  For a lower price tag, GoDaddy has the better price.  You may not get the best features with GoDaddy, but it is certainly easier on the wallet.  It all depends on your needs to accomplish your goals.  GoDaddy does have more domains transferred or deleted, which means you can lose your site domain easier.  You don’t have to worry about it with AWS.

Uptime

AWS has an outstanding uptime, offering up to 100%.  GoDaddy has nearly the same, but they come in second at 99.94%.  Sites hosted by AWS work for a longer time than GoDaddy, but the difference is almost insignificant.  The reason may be in part because GoDaddy hosts nearly a million different sites at the same time.  AWS hosts less than 3000 a day.  This discrepancy won’t cause your site to crash on either host site.  You will get nearly the same results with both, but AWS is the better option if you’re looking for the better uptime.

Speed

Both provide quick speeds for running your website.  The speed of AWS appears to be quicker than GoDaddy since you can connect with a representative faster.  If you’re looking at the rate at which you need your website to run, GoDaddy has some quick speeds to get you up and running.  The speeds vary on your needs, but they will work to get you on your way.  Neither is a terrible option, so you’re going to be good with either one.  If you’re looking for the free year subscription with AWS, the speed is going to be a lot slower than you’ll need.

Features

The 1TB of bandwidth you get with AWS gives you plenty of speed.  The 1TB of disk space you get with AWS is an excellent feature with AWS. GoDaddy has unlimited bandwidth, so you don’t go over your amount of bandwidth.  The 100 GB of disk space isn’t ideal for storing a lot if information, though.  The number of transfers in and out of GoDaddy means you may find a domain name faster than AWS.  The flipside of that means you can also lose your GoDaddy domain faster as well.  More people appear to enjoy the AWS compared to GoDaddy, but they both offer excellent products.

Which is the Best?

Both AWS and GoDaddy are excellent choices to work through a host site.  Depending on your needs, one option is better than the other one.  Overall, GoDaddy is a great option for anyone who can’t afford the price of AWS.  AWS does have a lot of excellent features to help make your site look professional.  If you’re a developer, you may want to go with AWS because you can get live help right away.  As a marketer, GoDaddy will work for you because there are plenty of domain names to drive traffic.  A small business owner will appreciate GoDaddy since their prices are low enough to compete.  An e-commerce company would be wise to go with AWS for growing their products through the host site.

We know this is a lot of steps, but if you follow these instructions you should be good to go. And of course, if you need help at any point in this process, contact the experts from Tutorial Chat! Or else, chat with our experts in JNTU World and get all your queries cleared!

Have you migrated your WordPress website recently? Let us know your experience with the process in the comments section below!

 

Rate this post