How to Move WordPress from Localhost to Production Server | Tips & Tricks

is arguably the most used CMS in the world. From simple personal blogs to complex ecommerce sites, it has proven to be a winner. This being the case, many developers often create their website on a local host or personal computer, then finalize development before transferring to a live and making it available to the world.

If you belong to this group of people and have finished the development on the , here are the steps to your WordPress from localhost to a live server.

Note: there are plugins that can automate this process. This tutorial will cover the manual steps without requiring the help of a plugin.

If your web host comes with cPanel, log in to the Cpanel, and click on “MySQL databases” in the Databases section.

wordpress-hosting1-2

Under the new database text box, name your database and click the “Create Database” button. On the new window that is displayed, click “Go back.”

wordpress-hosting2

Create new database user

In the next window you have to fill the textbox with a username and (strong) password, then click the “Create user” button. Record the username and password, as you will need it later.

wordpress-hosting3

Once again, hit “Go back” in the newly displayed window.

Add user to database

Scroll down to “Add user to database,” select the user just created from the user dropdown list and also select the database just created from the database dropdown list. Next, click the “Add” button.

wordpress-hosting4a

On the next window that opens, click the “All Privileges” checkbox, followed by the “make changes” button. Once again, click “Go Back” on the window that opens.

In the window that is displayed, double-check to see that your database contains the user you have just created. Once you are done, click on the Home button at the topmost left corner of the page.

wordpress-hosting4

On the local host open phpMyAdmin, or whatever database management program you are using.

Locate your WordPress database.

wordpress-hosting7

Select the database, scroll down and click on “Check all.”

wordpress-hosting7a

On the “Select with” dropdown menu, select “Export.”

wordpress-hosting8

In the next screen ensure that the format is on SQL, then click on “Go.” Save the exported database with the extension “.sql.”

wordpress-hosting9

Importing the database

Go back to cPanel on your live server, and under “Databases” click on “phpMyAdmin.”

wordpress-hosting20

On the left pane you should see a list of databases. From this list click on the name of the database you created at the start of the tutorial and click “Import.” Navigate to the sql file you saved on your local computer and import.

wordpress-hosting21

If everything went well, it should bring you back to the phpMyAdmin main screen. You are now done migrating the database to the live server.

In your localhost, open your file manager and navigate to the WordPress folder (the folder that contains the “wp-admin,” “wp-content” and “wp-includes” folders). Compress the whole WordPress folder into a zip file.

In the cPanel in the live server, open the “File Manager” under the “Files” section. Select “Document root for” and make sure the domain you need to move your website to is selected and hit “Go.”

wordpress-hosting12

Make sure in the next window that “public_html” is selected on the left pane. Click on “Upload.”

wordpress-hosting13

Navigate to the location of the compressed zip file and upload it. Once complete, click the “Back to” link.

Your zip file at this point should display as a file in your “public_html” folder. If it doesn’t, click “Refresh.”

wordpress-hosting14

Select the zip file and click “Extract” at the top-left corner. Once the extraction is complete, delete the zip file.

wordpress-hosting15

The last and final step is to edit the wp-config.php file to change all local host settings to settings.

Return to your “public_html” in the File Manager. Select the file “wp-config.php,” and click “code editor.”

wordpress-hosting22

Replace the database name with the name of the database you created in your cPanel. Also, change the “DB_USER” and “DB_PASSWORD” to the one that you created earlier.

wordpress-hosting23

Check for the “WP_HOME” and “WP_SITEURL” values. If they don’t exist, add the following lines to the wp-config.php file:

Do remember to change the “your-live-url” to your actual domain URL.

Save the wp-config.php file and exit.

Once this is done, type your domain name in the address bar of your browser, and your site should be up and running. Go through every single page and log in to the admin panel to make sure everything is working fine. If not, refer to this tutorial to troubleshoot your WordPress installation.

This is a comprehensive tutorial, and it may seem confusing. But after repeating this process once or twice, it becomes easy to follow for all your WordPress installations. Also, this method is more advisable when you do not have very large databases to upload.

You might also like More from author