Hi, please


(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:

Installing Wordpress Locally using MAMP

2. Hosting

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


  1. mushon 14:32, May 8th, 10

    thanks for the tutorial, I have a few questions though.
    1. What is local? What is live? Why should I care?
    2. What is MAMP?
    3. What is this weird interface you have? I only use Windows
    4. What is Dreamhost?
    5. I host my site on GoDaddy any tips on how to import there?
    6. Would you really help me if I run into troubles?

    Jane Smith, Alabama.

  2. joan 01:35, May 9th, 10

    Hi Jane,

    Check this out, it might help clarify some things: http://lmgtfy.com/?q=MAMP


  3. jonathan 21:29, May 10th, 10

    Hey, Miriam. I have a few suggestions for improvement. As you know, I’m having trouble with the config.php file not connecting to my database, so that will have to be taken into consideration somehow. Though, at this point it is still unclear whether that was user error on my part or if importing the local database to the live server requires that you change your config.php settings.

    Comments for the rest of the tutorial:

    step 3. may want to tell me to click on my database name instead of using current language.

    step 5. image does not have save as file checked. i clicked go without checking the save as file box and it just brought me to a page of text on the browser, which was probably the txt version of the sql contents. wasn’t hard to figure out, but better get a new screen capture in there.

    step 6. may want to say what the live server address will look like. kinda stupid, but would add clarity. is it just a url? maybe you could just format that into the example image?

    step 7. why am i downloading the config.php file? I think you just need one more sentence letting me know this is for backup.

    step 8. it’s also bringing plugins and upgrades and such, but there isn’t any note of that.

    step 9. i ran into the same problem you experienced wit not knowing my password for the database on my live server. the earlier post from our blog about resetting password for your live mysql database, should definitely be mentioned here. you could just summarize and then link to the previous post about this subject.

    note: when uploading my wp content folder i got errors uploading the records created for my git repository. food for thought, but probably outside of the scope of your tutorial…

    usability note about slideshare:

    don’t know if it is worth reworking, but slideshare was not a great medium for the tutorial. i though a slide show would be better. More organized. Better looking. And you did make it look great.

    However when at the embedded size on our blog and on their site the text is too small to read, which means i have to open to full screen ever time I return to the tutorial from executing steps. If I leave the page and come back, the slide show automatically goes back to the original embed size. Grrrrr.

    In the end i think listing the images on the site interspersed with text would probably be easier to navigate for a user implementing the tutorial step by step. especially when our blog has the feature to click and enlarge images on the spot, which i’m pretty sure stay open even if you move between applications on your computer.

    good luck!

  4. Brook 18:41, Oct 18th, 10

    Worked a charm. I use 1and1 and the tutorial fits right in.

  5. Len 23:34, Nov 19th, 10

    I see different versions of this tutorial floating around in the ether. I am going to reference the one I found on YouTube that has 14 steps but step 10 is repeated on two slides.

    Slide 7, “Let’s Get Live” says to install wordpress on the live server. I take that to mean you ARE NOT recommending uploading an entire site, i.e., WP, premium theme and content developed on the local site to the live server. I assume you are saying to do a fresh WP install into the live site AND a fresh install of any theme involved, THEN continuing with this step??? This is a critically important question.


  6. kevin 09:16, Mar 10th, 11

    very handy tutorial! Thanks for the pointers. My website is now live. Yay!

Post a Comment

You must be logged in to post a comment.