Tips and Snips: Creative Website Hacks for Creative People
ImageandAspect
About
Work Examples
Contact
Privacy
Terms
Subscribe
Tips and Snips: Creative Website Hacks for Creative People
  • ImageandAspect
  • About
  • Work Examples
  • Contact
  • Privacy
  • Terms
  • Subscribe
Browsing Category
Archive
WordPress

How to Migrate a WordPress site from a local computer to a server

migrate to server
July 14, 2020 by Diane Metcalf, M.S.I.T. No Comments

Migrate a WordPress site

If you’ve wondered how to migrate a WordPress site from a local computer to a live server, read on!

What you need:

A local WordPress site (ie: using WAMP, XAMPP)

A web server that supports PHP and MySQL

An (S) FTP file transfer protocol such as Filezilla

This tutorial demonstrates how to transfer a simple WordPresswebsite, including plugins, from a local computer to a live web server.

  1. Export your database to the live server

On your local installation:

a.) Open phpMyAdmin, then click on the database that contains your WordPress installation. (Mine is dbwordpresswebsite)

phpmyadmin1-1 How to Migrate a WordPress site from a local computer to a server

b.) Click on the _options table. (Your prefix may vary. The default is wp_options.)

c.) Click on Browse.

a-1 How to Migrate a WordPress site from a local computer to a server

phpmyadmin screenshot

d.) Change two rows in the table named siteurl and home. Sometimes they’re right next to each other, and sometimes not. In my case, they are.

(My URL points to http://localhost/wordpresswebsite while developing the site locally on my computer, in XAMPP. Now I need to point it to my live server, http://websitename.com.)

NOTE: If I had to install it in a subdomain, I would point it to: http://websitename.com/subdomain-folder-name

phpmyadmin2 How to Migrate a WordPress site from a local computer to a server

NOTE: Your local site will not work after you make this change. You can change the values back and it will work again.

e.) Go back to your database and click “Export”, then select “Custom”, “Save output to a file”, as below:

NOTE: If your server isn’t running a current version of MySQL, you may need to change “Database system or older MySQL server to maximize output compatibility with” and MYSQL40  set to NONE.

phpmyadmin3 How to Migrate a WordPress site from a local computer to a server

Select Go at the bottom, and your database will download (dbwordpresswebsite.sql in this example). Make note of the saved file’s location.

  1. Import your database to the live server

a.) On your live server, go to MySQL and Create a new database

THESE NEXT STEPS ARE EXTREMELY IMPORTANT. READ THROUGH THEM FIRST TO MAKE SURE YOU UNDERSTAND WHAT TO DO.  DON’T SKIP ANY STEPS.

server How to Migrate a WordPress site from a local computer to a server

b.) Create a database user: You need a user to be able to connect to your new database.

c.) Give the new user full access to the new database you just created. 

(I always create 2 users with full access in case I have an issue logging-in with one of them.)

d.) Find the information for the username and password for MySql. It’s usually located with the FTP settings information. Make a note of this information so you can log in to the database successfully.

e.) Go to server PHPMyAdmin

Find the database you just created and import your saved database into it. (Choose the .sql file you saved in step 1.)

phpmyadmin5 How to Migrate a WordPress site from a local computer to a server

  1. Upload your WordPress files to the server

Use Filezilla or another FTP transfer app. Copy all the WordPress files and folders to the correct server-directory, usually called “public”.

In this example, I’m going to transfer everything that’s inside of C://XAMPP/htdocs/wordpresswebsite to the “Public” folder on the web server.

phpmyadmin4 How to Migrate a WordPress site from a local computer to a server

  1. Change your WordPress configuration wp-config.php file.

a.) Find the local copy of wp-config.php in the root of the local WordPress install, (in my case, it’s in XAMPP/htdocs/dbwordpresswebsite in the screenshot above).

b.) Open wp-config.php with a text editor. Make a copy of wp-config.php in case this first attempt doesn’t go well.

The original file looks like this:

/** The name of the database for WordPress */

define(‘DB_NAME’, ‘dbwordpresswebsite’);

/** MySQL database username */

define(‘DB_USER’, ‘root’);

/** MySQL database password */

define(‘DB_PASSWORD’, ‘root’);

c.) Change wp-config.php to match your server WordPress configuration.

Change these three options to match your live server database, user and password:

/** The name of the database for WordPress */

define(‘DB_NAME’, ‘your-new-database-on-server’);

/** MySQL database username */

define(‘DB_USER’, ‘user-you-just-created-on-server’);

/** MySQL database password */

define(‘DB_PASSWORD’, ‘password-you-created-for-user-to-log-in’);

define(‘DB_HOST’, ‘localhost’); will most likely remain the same, but some hosts create a different host.

 

d.) Now upload the changed wp-config.php to the server and over-write the one that’s there.  It will be where you just uploaded the WordPress files and folders.

5.  Go to the sites URL to check if it’s loading properly.

If it’s not, go back and make sure you’ve done every step. If you haven’t skipped any, then it’s most likely an issue with  wp-config.php . Make sure the 3 items you changed are correct. Correct them and re-upload wp-config.php to the root again.

6. Load the WordPress Backend

a.) Click Settings > Permalinks and update permalinks.

7. Find and replace URLs in database

*Backup your database before applying any changes.

Posts that contain links using URLs may need to be changed. There are plugins to do this: The  Better Search Replace plugin enables you to search for database “strings” of data, and replace them.

For broken links, you can use these tips, or use a SQL query to fix it.

To use SQL to do fix links, go to phpMyAdmin, click on your database and then click “SQL” in the top menu. Write this query but use your own file names and domain:

UPDATE wp_posts SET post_content = REPLACE(post_content, ‘localhost/folder/’, ‘www.yoursite.com/’);

phpmyadmin6-1 How to Migrate a WordPress site from a local computer to a server

8. Regenerate thumbnails to correct the images size

Use a thumbnail re-generator plugin to correct the display size of your images.

TA-DAAAAAA!

Now you know how to migrate a WordPress site!

Not too shabby, eh?

Questions? Contact me:

[email protected]

or

My Contact Page

Other articles you might like:

-How your personal brand makes the difference

-Using images: Tips to improve your SEO rankings

-10 Things to Do After Creating Your Website

 

About the author

diane-author-300x181 How to Migrate a WordPress site from a local computer to a server

I developed Image and Aspect because I believe that professionals need to have an impactful web presence. One that showcases their unique talents, skills, and abilities as well as their values and style. A presence that focuses on social engagement and connection.

I’m passionate about what I do; I like helping fellow humans, I like having all kinds of social connection with others, and I want to give back, to make the world a better place.

I do much of the designing and coding myself, and I also have a wonderful network of professionals that may contribute as well; photographers, copywriters, branding experts.

I love designing and coding beautiful, elegant and responsive web creations. I ALSO teach and help others who want to learn how to do it themselves.

‘Tips and Snips’ is my blog, and it’s full of information and inspiration to help transform any online persona from “meh” to AMAZING! Sign-up HERE to get blog posts right to your in-box every Friday! I write about Design, Marketing, Search Engine Optimization, Branding, Vlogging, Color Theory, HTML5, CSS3, Bootstrap, WordPress, Social Media…anything you’d want to know to get yourself noticed online.

Visit Image and Aspect to learn more about your web presence options

Diane M. Metcalf, M.S.

Read more

Reading time: 5 min

Find Topics

 Image and Aspect is a solution-based web presence development service for creatives, entrepreneurs and solopreneurs. We create impactful online presences that showcase your talents, skills, values & style, while focusing on influencing, engagement & connection.

 

It’s a collaborative process; we use streamlined project-management & communications tools so you’ll always know what’s happening with your project. And by adding personalized service, you get  one-on-one support. We want you to feel equipped, educated & empowered to ask questions & make decisions about your web presence & web platform.

 

Tips and Snips was born from the desire to give back; to support anyone who has an interest in learning the art and science of  web design and coding.

 

Thanks for your interest!

~Diane Metcalf, MS

Image and Aspect logo

Connect with me on Twitter!

Follow @MetcalfDiane

Categories

  • bootstrap
  • CSS
  • Design
  • Entrepreneurs and Creatives
  • HTML
  • Marketing
  • security
  • SEO
  • Thoughts
  • WordPress

Recent Posts

  • 6 Tips to make your Blog Post SEO Friendly May 6, 2022
  • The correct order for using Bootstrap tags April 4, 2022
  • Basic HTML (Hypertext Markup Language) Vocabulary Rules March 4, 2022
  • How to make a hover-able drop-down menu February 23, 2022
  • 10 things to do after creating your site January 8, 2022

Older Posts

  • May 2022
  • April 2022
  • March 2022
  • February 2022
  • January 2022
  • December 2021
  • November 2021
  • October 2021
  • August 2021
  • July 2021
  • June 2021
  • May 2021
  • April 2021
  • March 2021
  • February 2021
  • January 2021
  • December 2020
  • November 2020
  • October 2020
  • September 2020
  • August 2020
  • July 2020
  • June 2020

Tags

  • bootstrap
  • CSS
  • Design
  • Entrepreneurs and Creatives
  • HTML
  • Marketing
  • security
  • SEO
  • Thoughts
  • WordPress

Image and Aspect on Instagram

To see the Instagram feed you need to add your own API Token to the Instagram Options page of our plugin.
Oops, something is wrong. Instagram feed not loaded

recent posts

  • 6 Tips to make your Blog Post SEO Friendly
  • The correct order for using Bootstrap tags
  • Basic HTML (Hypertext Markup Language) Vocabulary Rules
  • How to make a hover-able drop-down menu
  • 10 things to do after creating your site

ImageAndAspect.com © 2021 Designed by ImageandAspect