Different Versions of Sql Not Uploading Properly in Wordpress

Step-by-Step Guide to Migrate Your WordPress Site to a New Host

Last updated on: April 23, 2021

Are you fix to migrate your WordPress site and move to a new host or server? Moving your website to a new host tin exist a daunting and stressful experience, just information technology doesn't need to be. Even though in that location are important steps to migrate your WordPress site if you follow our guide y'all can succeed.

Many people are faced with the need to move to a new host because of problems with their current provider and take just had enough. But all too ofttimes, migrating to a more reliable host is delayed fourth dimension and again for fearfulness of making a mistake and damaging your site(south).

To get around the problem, people will may pay a big fee for a professional to motility their site for them. Or search for a new host that offers a migration service as part of a new hosting package. And then there are the people reading this article who accept the third option of having a go at it themselves.

If you lot spend a fiddling fourth dimension preparing your own website, migrating is zilch to exist concerned about. Information technology can be a very straightforward project if approached correctly and can hands be reversed out of should any issues occur.

Let's run through the steps required to move your WordPress website to a new host, but before we get started showing you how you lot can drift your site, please keep in mind that many of the best WordPress hosting companies will actually move your site for you, and so if y'all have merely purchased a new hosting programme and are looking to move your site cheque with your new hosting provider showtime to run into if they offer gratuitous migration.

Table of Contents

Speedily scroll downwardly to any section or you can even bookmark any of the links beneath to make it easier to come dorsum if you lot have to take a break during the procedure:

1. Back up your website files
2. Export The WordPress Database
3. Create The WordPress Database On Your New Host Server
4. Edit the wp-config.php File
5. Import Your Database
6. Upload The WordPress Files To Your New Host
7. Defining New Domain & Search/Replace Old Domain
8. Concluding Touches

Step ane: Backup Your Website Files

The very offset stride earlier migrating is to back upwards every attribute of your site. This should exist a part of your general WordPress security, and is good practice before whatever major change. Only it is also a requirement of migrating your WordPress installation since there is so much data being moved.

Then how practice y'all back up your site? There are plenty of plugins you can employ to backup WordPress for yous. With a backup plugin you typically install and and then utilize built-in settings to manage which files get backed up, how often and where your backups are stored.

If you want to use a plugin, one of the best options is WPvivid. This plugin offers tons of powerful backup options for scheduling, restore points, limit files, filter large files, backup splitting, backup themes and plugins, remote storage compatibility, multisite support and more.

Alternatively you can take a more manual arroyo. To give yous a quick summary, manual backups require a file transfer tool (FTP) in order to access your website files. Two popular FTP programs are FileZilla (PC) and Transmit (Mac). After installing you'll need to apply SFTP credential (from your web host business relationship) to connect to your website's server. Once you lot've connected select and download all files under your website'southward directory. This includes the .htaccess file that is set to be hidden. Consult your FTP programme'due south help file to have information technology display subconscious files if you are unable to see this file.

Depending on the number of media uploads you have in your site, this could accept some time. While this download is underway nosotros can brainstorm step 2 and make a re-create of your database.

Step 2: Consign the WordPress Database

Exporting your database is a unproblematic process that only requires a few steps to complete. Login to the cPanel account of your web server and open the phpMyAdmin application. Select the database that contains your WordPress installation from the list on the left paw sidebar and once selected click on the Export tab on the navigation menu.

The default settings of a Quick export and the SQL format for the export are sufficient for what we demand. Click the Go button and the database export process will brainstorm and a file will be downloaded to your local computer.

Once the database consign and the FTP transfer of your files have both completed, y'all are ready to movement onto the next phase.

Stride three: Create the WordPress Database on Your New Host Server

Earlier we can begin the migration to the new spider web host, we need to create an environment for a WordPress installation. To do this you must create a database that you can import your SQL information into.

Login to your new web host with the user credentials they have supplied you and connect to the cPanel software. For our guide we will be using the MySQL Databases application. If your web host doesn't take that awarding running then you lot will should contact their support squad to discover their method of creating new databases.

The steps to create a database are quite unproblematic:

• Open up MySQL Database and create a new database with an appropriate proper name for your website.
• Create a new MySQL user (with a secure countersign).
• Add this user account to the new database and grant it All Privileges.

Write down the database name, the new MySQL username and its password. Y'all will need them before long.

Step 4: Edit the wp-config.php File

Browse to the folder on your local estimator where yous downloaded your website files to. In that folder there is a file called wp-config.php that controls the access between WordPress and your database.

Brand a re-create of this file and store it in another folder on your local computer. This is necessary for restoring the changes we are about to make should something become wrong after.

Open up the original version of the file with your favorite text editor and make the following 3 changes:

i. Change the Database Name

Locate the following line:

ascertain('DB_NAME', 'db_name');

The db_name portion of this line will currently exist set to the MySQL database name of your old spider web host. This must be changed to the name of the new database you lot accept just created.

two. Change the Database Username

Beneath this you will find the line:

define('DB_USER', 'db_user');

In this line you demand to change the db_user portion from the username of your one-time host to match the new username y'all have just created.

3. Change the Database User Password

Finally, edit the third line:

define('DB_PASSWORD', 'db_pass');

Every bit with the others the db_pass section of this line must be changed to the new secure password you created for your MySQL user.

Salve wp-config.php and close the file.

Stride 5: Import Your WordPress Database

Now that you have a new database to work with we can begin the import process.

Launch phpMyAdmin from the cPanel software on your new server and select your new database from the list on the left hands sidebar. Once information technology opens select the Import tab from the navigation menu.

In the File to Import department click the Choose File push button and select the SQL file y'all exported previously.

Un-tick the Partial Import bank check box, brand certain the format is set to SQL and and then click the Get button. The database import will now begin.

The time this import takes varies depending on the size of your database. Yous should receive a message informing you of the success of the import when it has finished.

Step 6: Upload The WordPress Files To Your New Host

Now that yous have the new database prepared and you've reconfigured the wp-config.php file, information technology is time to begin uploading your website's files.

Connect to your new spider web host using your FTP program and browse to the folder that your website is going to be held. If this is the primary, or only site being installed on this web server so uploading the files to the public_html binder is the usual directory.

With the remote directory selected you can upload your website files that should at present include the updated version of wp-config.php. Every bit with the before download, this process tin can take some time.

Don't delete these files from your local computer once the upload finishes. They are yet needed until the final steps accept been completed.

Step vii: Defining New Domain & Search/Supplant Old Domain

If you are moving to a new/different domain and then you should read over this footstep, if not, and so you can skip this because you don't have to update your site to betoken to a different domain.

Ane issue people always seem to have when moving their site is that they've added links to other posts on their site or inserted images directly by pointing to a URL on the server, causing these to interruption when moved over to a new domain. If you want to quickly and easily search for any instances of your old domain name and replace with the new proper noun nosotros suggest yous take a look at the Search Replace DB script on github. This will permit you lot to do this with slap-up ease. Only make certain y'all DELETE it when your are done (for security reasons) and don't place it in your root domain, create a temp folder with a random proper noun to host the script.

Changing Site URL: By doing a search and supersede for the old domain and replacing with the new domain you'll too exist altering the site_url and habitation url values in the database (Changing the Site URL) which will ensure that when you effort to log into your site on the new domain it doesn't try and redirect you over to the old domain.

Footstep viii: Final Touches

This step actually includes 2 separate mini steps with (potentially) several days betwixt them.

First – before you can employ the site on your new host y'all volition need to reconfigure your domain'due south DNS settings. They will be set up to signal to your old host and you will demand to bespeak the right records to the new server IP accost.

This process will depend on where you have your domain registered. The details of completing this process are too varied to hash out in this post, but your domain registrar should accept all of the details you demand to make this change.

DNS changes can accept upward to 48 hours to fully propagate. Information technology's all-time to practice this at a menstruation when you await lower levels of traffic. During this 48 hour window you should avoid making any changes to your website equally you may be changing the old version of the site.

2nd – after the 48-hour period has expired you should at present be accessing the new spider web host when you go to your website. It'southward at this bespeak yous tin connect to your erstwhile web host to delete the files and database. You should notwithstanding have a local backup copy of these files and the database consign, along with the original wp-config.php file in case you need to roll back the migration. Information technology can be a good thought to concord onto these files for a an extended menstruum just to be on the condom side.

---

As you tin run into, when broken downward into the to a higher place simple steps, the process isn't that hard. All it really requires is for you to exist conscientious at each step and requite yourself the option to become back to the original version until the terminal possible moment (in case of any problems).

Have you migrated your WordPress website recently? Permit the states know your feel with the process in the comments section below!

dunnbrank1992.blogspot.com

Source: https://www.wpexplorer.com/migrating-wordpress-website/

Share this post