(Disclaimer: this tutorial is work in progress and is being tested)
This tutorial is for those operating Mac Os X.
In this post, you will find a slideshow tutorial explaining how to export your developing wordpress site from your local MAMP server to your live server (and to the world!). Before you begin this tutorial, you should be familiar with a few concepts.
1. Working Locally
When developing (coding) a website, it is very helpful to work locally. What this means is that you are working on files on your own personal computer and not working directly onto your live server. This is good practice because you might want not want your site to be accessible to others during development. This is where MAMP comes in. What MAMP is is a program that installs a local server environment to your computer. Using MAMP, you can assign a local url address to your site. This means you can develop the code and check the appearance and function of your coding immediately by visiting this local site in a browser on your computer and you don’t have to upload your files to a live server. This saves time and is safer than working from a server or uploading your files every time you want to check your code. In this tutorial, we are going to be specifically dealing with the development of a wordpress site. For more information on how to install and work on a wordpress site with MAMP, take advantage of the following resources:
Most webhosts provide phpMyAdmin in their control panels. If you are confused about whether you have this function, you should contact your webhost. This tutorial is for hosting sites that provide phpMyAdmin.
3. What this tutorial will teach you how to do is to export the site you have developed locally onto your live server. This is something you can do as often as you like as you develop your site. I hope it is helpful.
After going over the comments from my tester, Jonathan, I have decided to provide an alternate tutorial experience. The embedded slideshow is not working as well as one would hope. So, I have broken down the pages to see if perhaps this is easier to work with.
For step five, if you press “go” and are taken to a page full of code and not a prompt to download the .sql file, you have not checked “save as file” in the lower left hand corner of the page (above “file name template).
If you are having a problem accessing your phpMyAdmin through dreamhost, you might find this post helpful: cache problems