How To Move Your Site From Local XAMPP To The Web Server

To move your local WordPress website from XAMPP to a web server you’ll first need to create a backup of your local website’s files and database. Then you will need to purchase a web hosting plan and restore your backed-up website’s files and database on this web server.

There are two methods that you can use to achieve this. The first method which is by far the easiest is to use the All-in-One WP Migration plugin to backup your local website and restore it on the live web server.

The second method which is more difficult is to manually backup your website’s files and database. This method requires a bit of technical knowledge and does not utilize any plugins.

How To Move Your Site From Local XAMPP To The Web Server

Step 1 – Backup Your local WordPress Website

How To Backup A Local WordPress Site Using A Plugin

1. From the WordPress dashboard of your local website, hover your mouse pointer over the plugins menu option and click on “add new” in the slide-out menu. 

How To Backup A Local WordPress Site Using A Plugin Step 1

2. Search for the All-in-One WP Migration plugin then install and activate it. 

How To Backup A Local WordPress Site Using A Plugin Step 2

3. After installing the plugin a new menu option titled “All-in-One WP Migration” will become available in the menu to the left on the WordPress dashboard. Hover your mouse pointer over this option and click on “export”

How To Backup A Local WordPress Site Using A Plugin Step 3

4. On the export page click on the green “export to” button and select the “file” option. 

How To Restore A WordPress Website On A Web Server Using A Plugin Step 3

5. When the file is finished downloading, you would have successfully backed up your local WordPress website. 

How To Backup A Local WordPress Site Manually (Without Plugins)

How To Manually Backup WordPress Website Files

1. Navigate to the location where your local website files are saved on your computer. This location should look like “E:\xampp\htdocs\”.

How To Manually Backup WordPress Website Files Step 1

2. Within the htdocs folder find your local website’s folder and open it. 

How To Manually Backup WordPress Website Files Step 2

3. Highlight all the files and folders within this folder and create a single .zip file. 

How To Manually Backup WordPress Website Files Step 3

How To Manually Backup A WordPress Database

1. Open the XAMPP control panel and click on the admin button under the MySQL option. 

How To Manually Backup A WordPress Database Step 1

2. From the PHPMyAdmin dashboard click on the database tab. 

How To Manually Backup A WordPress Database Step 2

3. Locate the database for your local website and click on it. 

How To Manually Backup A WordPress Database Step 3

4. Within the database options click on the “export” tab. 

How To Manually Backup A WordPress Database Step 4

5. Set the export method as quick and the format as SQL then click on “go”

How To Manually Backup A WordPress Database Step 5

6. This will download your WordPress database in a single SQL file. 

Step 2 – Purchase A Domain And Hosting Plan

After creating a backup of your local WordPress website you will need to purchase a domain name and a hosting plan. If you have not yet decided on a web hosting provider, I highly recommend that you use SiteGround Managed WordPress Hosting. I’ve been using their services for about two years and I must say their service has been excellent. 

1. Head on over to the SiteGround Managed WordPress Hosting landing page and select the start-up plan. This plan is ideal for a new website.  

Purchase A Domain And Hosting Plan Step 1

2. Next if you already have a domain name select “I already have a Domain”. If you don’t have one then you can register one with SiteGround by selecting the “Register a New Domain” option.  

Purchase A Domain And Hosting Plan Step 2

3. Create your SiteGround account by filling in your account, client, and payment information.

Purchase A Domain And Hosting Plan Step 3

4. Under the purchase information section select a hosting period of 12 months and select domain privacy if you would like to hide your personal domain information from Whois services

Purchase A Domain And Hosting Plan Step 4

5. Agree to the terms and conditions and click on pay now.  

Purchase A Domain And Hosting Plan Step 5

Step 3 – Install WordPress On The Live Web Server

1. From the SiteGround welcome screen click on the “set up site” button.  

Installing WordPress on SiteGround Step 1

2. Next select start new website and select WordPress as the application of choice. 

Installing WordPress on SiteGround Step 2a
Installing WordPress on SiteGround Step 2b

3. Create your WordPress admin credential that you would later use to log in to your WordPress dashboard. 

Installing WordPress on SiteGround Step 3

4 Skip the extra addons by clicking finish, then on the next page click on the login admin button. 

Installing WordPress on SiteGround Step 4

5. Before you can access your WordPress dashboard SiteGround will launch its built-in started setup. Follow through with it until you get to the part where it gives you the option to go to your dashboard.   

How To Install WordPress On SiteGround Step 5

Step 4 – Restore Your Local WordPress Website On The Live Web Server

How To Restore A WordPress Website On A Web Server Using A Plugin

1. Now that you’re at the dashboard of your live WordPress website, head on over to the plugins page and install and activate the All-in-One WP Migration plugin. 

2. With the plugin activated select the import option from the All-in-One WP Migration menu item. 

How To Restore A WordPress Website On A Web Server Using A Plugin Step 2

3. On the import page click on the green import button and then select file. 

How To Restore A WordPress Website On A Web Server Using A Plugin Step 3

4. This will open a file explorer window. Locate the backup file of your local website and click on open. 

How To Restore A WordPress Website On A Web Server Using A Plugin Step 4

5. Wait for the process to be completed and you would have successfully moved your local site to a web server. 

How To Restore A WordPress Website On A Web Server Manually (Without Plugins)

How To Manually Restore A WordPress Database

1. After installing your WordPress website return to your SiteGround dashboard. 

2. From here click on the websites tab and then click on site tools. 

How To Manually Restore A WordPress Database Step 2

3. Next from the site tools dashboard click on the site tab to expand it then click on MySQL. 

How To Manually Restore A WordPress Database Step 3

4. On the MySQL manager page click on the user tab and create a new user. Keep a note of the username and password.

How To Manually Restore A WordPress Database Step 4

5. Next click on the “database” tab and click on the create database button. 

How To Manually Restore A WordPress Database Step 5

6. Now that your new database is created, click on manage access and assign the user you’ve just created to it.

How To Manually Restore A WordPress Database Step 6

7. Under the manage database section click on the ellipsis (the three vertical dots) to the right and then select change label. Give your database a label that you would easily remember.

How To Manually Restore A WordPress Database Step 7a
How To Manually Restore A WordPress Database Step 7b

8. Next select the PHPMyAdmin tab and then click on access PHPMyAdmin.

How To Manually Restore A WordPress Database Step 8

9. From the PHPMyAdmin dashboard click on the databases tab. Select the new database we’ve just created. It is named with random alphanumeric characters and your custom label in brackets.

How To Manually Restore A WordPress Database Step 9

10. Before you import your backed-up local database, open the .sql file in your preferred text editor. Using the find and replace function, of your text editor type in your local URL in the find field, and in the replace field enter your new domain name. Click on find and replace all then save the file. For example, if I was doing this import I would find the local URL “http://localhost/webtipstech-local” and replace it with my live URL “https://www.webtipstech.com”

How To Manually Restore A WordPress Database Step 10

11. With your local URLs replaced with the live URLs head on back to PHPMyAdmin. From the dashboard click on the import tab then click on the choose file button and select the .sql file that we just edited. 

How To Manually Restore A WordPress Database Step 11

12. Click on the go button and when the import has been completed the tables and data from your local website’s database will be populated in this database.  

How To Manually Restore A WordPress Database Step 12

13. Select the database again from the list on the left, then open the wp_options table and double-check that the site URL and the home URL have been changed to your live URL.

How To Manually Restore A WordPress Database Step 13

How To Manually Restore WordPress Website Files

1. Return to the site tools dashboard and click on file manager.

How To Manually Restore WordPress Website Files Step 1

2. Within the file manager navigate to the public_html folder. Within this folder upload the .zip file of your local website that we created earlier.

How To Manually Restore WordPress Website Files Step 2a
How To Manually Restore WordPress Website Files Step 2b

3. Extract the contents of the .zip file and replace the folders and files within it the public.html folder.

How To Manually Restore WordPress Website Files Step 3

4. Next open the wp-config file and change the database name, username and password with the ones that we created. 

How To Manually Restore WordPress Website Files Step 4
Final Thoughts

Migrating a local WordPress website from XAMPP is quite simple if you use a plugin like All-in-One WP Migration. For anyone attempting a migration like this, I would always recommend that you use a plugin. You should only attempt the manual method if for some reason you are unable to install plugins on your local website or the plugin that you are using has some limitations.

Add a Comment

Your email address will not be published. Required fields are marked *