Category Archives: Blog
How to Transfer Wordpress Database to New Hosting
The Simple Guide to Moving Your WordPress Site to a New Domain
How to migrate your site without the help of a paid plugin.
1. Choosing Your New Host
Choosing the right web host for your needs is a big decision. Since you’re switching to a new host this probably means you’re dissatisfied with your current hosting provider, or you’ve outgrown what they can provide for you.
Below we profile a few of our favorite hosting providers, to help you make the most informed decision possible. Ultimately, the decision you make is up to you, but any of the three below are great choices.
Bluehost
Bluehost is a great choice for those seeking a simple shared hosting environment. Of course, shared hosting isn’t perfect for every kind of website, especially if you’re receiving high levels of traffic, but it can be a great place to start.
As a bonus shared hosting usually offers the most setup assistance when it comes to getting your site up and running.
If you’re looking for a cheap hosting solution for a newer website, then Bluehost is one of the best beginner WordPress hosts out there.
Plus, Bluehost is actually on the list of hosting providers that WordPress recommends to their users. You can’t get a higher recommendation than that, especially if your site runs on WordPress.
WP Engine
If you’re looking for a more extensive and customized hosting environment, then WP Engine might be a great choice for your needs. WP Engine is a managed WordPress hosting environment, which means that they handle everything for you. A lot of big WordPress websites trust WP Engine to provide them with the level of support their sites require.
WP Engine is the equivalent to having a team of WordPress experts on your side, optimizing your site, managing your hosting environment, and protecting your site from the onslaught of online threats.
Some offerings included with a WP Engine hosting package include:
- Automatic security updates
- Daily website backups
- High-level of WordPress security
Plus, WP Engine is great for sites that are looking to scale. They’re a hosting provider that can grow with your website and doesn’t hold you back if your traffic levels continue to grow.
According to most existing hosting reviews WP Engine’s support staff is consistently rated one of the best.
SiteGround
SiteGround is a managed WordPress hosting environment, which means all of the technical aspects of the hosting environment are taken care of for you. If you’re a very technical person and love the challenge of setting up and customizing your own servers, then this probably isn’t for you.
But, if the thought of having all of the heavy technical elements of your site taken care of fills you with glee, then it’s worthwhile to pursue this option. Face it, as a website owner you have a lot on your plate, do you really want to add managing your server to this list as well?
In terms of managed WordPress hosting they do offer some of the most flexible options. Some managed WordPress hosts are set in stone and don’t allow any customization whatsoever, this hosting provider isn’t one of those.
They have very fast host performance and have a variety of hosting options to suit your needs. Plus, SiteGround has already been around for 10 years, so you know they’re doing something right.
Have you chosen your new host yet? Good, let’s move forward.
2. Backing and Migrating Up Your Existing Site Files
It’s important that you actually purchase your new hosting before you move forward with the switch. You’ll need to have login credentials with your new site to actually make the site transfer.
Once you’ve made the decision about which host you’re going to use it’s time to backup every element of your website. This is a good thing to do on a regular basis, just to ensure you can restore your site in case something tragic happens. But, it’s absolutely necessary to do before you move forward with any of the steps below.
When the time comes to backup and migrate your site you’re going to be able to use a FTP client like, Filezilla, or the cPanel that comes with your existing host. We’ll outline both methods below.
Migrating Using Filezilla
If you’re going to utilize an FTP manager like Filezilla, then follow the steps below. First, download and install the free software from this link. To move forward you’ll need the login information for both your current and new hosting accounts.
1. Connect to Your Site
2. Navigate to public_html
Once you’re browsing through your site’s files navigate to the public_html file. This is where all of your site’s files are contained. Download all of your existing site’s files. This can take some time depending upon the size of your site and your Internet connection.
3. Upload to Your New Host
Once all of the files are downloaded, you’ll want to login to your new host. Navigate to your public_html folder for your new domain and upload all of the site files you just downloaded.
If you downloaded the right files, then your new site will be migrated to your new host.
Migrating Using cPanel
Transferring your site via cPanel is much faster and can be less intimidating. Plus, it doesn’t require installing any software on your local computer. But, it only works if both your existing host and new host are utilizing cPanel.
1. Locate the File Manager
The first thing you’ll want to do is locate the ‘File Manager’. This is where all of your site’s files will be held. Double-click to open this.
2. Download Your Site’s Files
Inside the file manager locate the public_html folder, then click on the folder where all of your site’s information is contained. This will either be the public_html folder, or it’ll be named something like yourdomain.com, depending if you have multiple domain installs.
Click ‘Select all’, then ‘Compress’.
Then, create a .zip file and save the zip file to a same location on your computer. It can also be helpful to create a copy of this file and store it in a safe place as a website backup.
3. Create a New Domain On Your New Host
Now, you’re going to login to your cPanel in your new host. If you haven’t done so already, then you’ll want to add your domain to your new host.
Navigate to ‘Addon Domains’
On the next screen you’ll add your new domain name. Fill out all of the necessary details and click ‘Add Domain’.
4. Upload Your Old Site to Your New Host
You’ve made it to the final step. Now you’re going to add the files you downloaded above to the new domain you’ve just created.
Navigate back to your ‘File Manager’ and navigate to the public_html folder of the new domain you created. Now you’ll upload the .zip file to that folder and use the built-in unzip function.
If you’ve done that successfully, now you’ll have migrated your site’s content to your new domain.
If you’ve followed all of the steps above, then your new site should be correctly uploaded to you new host. Now, all you have to do is move over your WordPress database to make the file transfer complete.
5. How to Move Your WordPress Database
The final step of the site transfer process involves moving over your WordPress database to your new host. To do this we’ll be using a tool called ‘phpMyAdmin’.
In your cPanel navigate to ‘phpMyAdmin’, as shown in the image below.
1. Find the Right Database
On this screen you might see a bunch of different databases listed. If you’re not sure which database you’ll need to access and download, then follow the steps below.
Navigate back to your site’s files via ‘File Manager’ and find a file called wp-config.php. You can open this file using the built-in code editor, or your editor of choice. With the file open look for a line of code titled: define(‘DB_NAME’, ‘the name of your database’). This will show you the name of the database you’ll want to download on the previous screen.
2. Export Your Database
Select the database you found in the step above and select the ‘Export’ option on the top navigation bar, then click on ‘Go’ and save it to your computer.
3. Login to Your New Account
Now, login to your cPanel on your new hosting account, and look for an app titled ‘MySQL Database Wizard’.
The setup wizard will walk you through the process of creating a new database. This will create an empty database which you will fill with the database information you downloaded earlier.
Make sure you keep track off the new database information as you create it, you’ll need this information to complete the final step in the migration.
4. Import Your Database
To fill in your empty database you’ll want to access the ‘phpMyAdmin’ app in the cPanel of your new host. Now, navigate to the empty database you created earlier and select upload from the top navigation menu.
Find the database you downloaded from your old host and click ‘Go’. This will upload your old database to your database on your new host.
Now, you just have one final step to go.
5. Update Your Configuration File
The final thing you’ll need to do is update the wp-config.php file on your new host with your latest database information.
Navigate to your ‘File Manager’ and locate the file titled ‘wp-config.php’. Open this file and you’ll need to change three things: your database name, username, and password. You’ll have created these in step number three above. It’ll look something like the image below.
Once you’ve updated those you can save your file and the migration process will be complete!
6. Switching to Your New Nameservers
If you want to avoid any downtime in switching over your site, then this should be the final step in the process.
The final step in the website migration process is switching over your nameservers. To do this you’ll need to login to the dashboard of your existing domain name provider.
When you signed up for your new host you should have received an email that contains your nameserver information. Your nameservers will commonly look like this:
ns1.mynewhost.com
ns2.mynewhost.com
Find your existing nameservers, then simply copy over your new nameservers, then click save. Sometimes it can take up to 24 hours for your nameservers to point to your new host, but usually they’ll transfer over immediately.
For a quick review, to ensure you’ve completed every step of the process we’ll review them, so you can make sure your transfer goes smoothly:
- Choose a new host and sign up for a new hosting package.
- Backup and download a copy of your site’s files via cPanel or Filezilla.
- Login to your new host and create a new domain (if needed) and upload your site’s files via cPanel or Filezilla.
- Download your WordPress database through the tool phpMyAdmin.
- Create a new WordPress database with your new host through MySQL Database Wizard.
- Upload your downloaded database into the empty database you’ve created.
- Change your wp-config.php file using Filezilla, or File Manager inside cPanel, and update the information to reflect your newly uploaded database.
- Finally, change your nameservers to those provided by your new hosting account.
If you’ve successfully completed every step outlined above, then you’ll have successfully migrated your WordPress site.
In Closing
Hopefully, the steps above will help you seamlessly migrate your site from one WordPress host to another. If the above process is to technical for you, you can always get in touch with your new host, and often they’ll walk you through the migration process, or will even do it for you for a fee.
At the very least, the information above will help you understand the host migration process a little better, and what actually happens behind the scenes.
Related search : how to transfer wordpress database to new hosting, moving wordpress site to new domain,how to copy a wordpress website from one domain to another, how to migrate wordpress website data to new hosting
