Moving a WordPress Website

So you’ve finished working on your local wordpress install and want to upload it to your domain. It’s quite simple but you do need to make a couple of changes in the database once the website has been moved. Steps below:

1. Take a backup of your database using phpmyadmin (save as a .sql.gz)
2. Create a MYSQL5 database and user on your host (note the connection settings)
3. Go into phpmyadmin
4. Open the table wp_options for editing
5. Change the value “siteurl” to your current domain, i.e. http://www.yourdomain.com
6. Change the value “home” to your current domain, i.e. http://www.yourdomain.com
7. Zip up your wordpress folder
8. Upload to your hosts web folder (htdocs, httpdocs, or something like that)
9. Unzip the archive on your host
10. Open your wp-config.php file
11. Change the following settings to match that of your new host
    1. DB_NAME — the name of the database you created
    2. DB_USER — the name of the database user you created or one that has full privileges on that database.
    3. DB_PASSWORD — the password you chose (please don’t use any dictionary words, use a password generator or just mash the keyboard)
    4. DB_HOST — the hosts MYSQL server address