Moving WordPress from MAMP to a online web host database (5 posts)

  1. beegongood
    Posted 6 years ago #

    I am a mac user and trying out wordpress for the first time to make my company's website. I am very new to all this. I found great instructions for downloading WP on MAMP and making everything work. Now, we have been provided a web hosting service by terraprime (www.terraprime.co.uk). I was wondering does MAMP allow me to maintain the db locally and then just update via SQL or FTP to the live server?

    There is an option for creating a Stand-alone MySQL User (advanced only)
    "If you want to set up an extra user without a corresponding database and set up its permissions manually (via phpMyAdmin for the database you want to grant privileges on) please fill in the details below."

    So, if I want to move my locally made website which currently is on MAMP, do I use the Stand-alone MySQL? I would really appreciate some idiot proof screenshot type tutorial if there is any. Do I export the WP package on the Host provided FTP or download it directly there from the web and I like not to start all over again.

    Thank you in advance.

  2. figaro
    Posted 6 years ago #

    See if the following video helps...it illustrates how to copy an online site down to XAMPP, but just reverse the process.


  3. beegongood
    Posted 6 years ago #

    @figaro: your video is very good. Thank you for the link.

    I am still experiencing troubles tho.
    I have exported my database from PhPMyAdmin on MAMP to a .sql file. I replaced all instances of localhost address to the remote server url.

    I have imported all the wp-content via an ftp on to the remote server. Installed WP 2.8.2. and got most of the posts now running on the WP remote server. However, all the customised work I had spent hrs doing on the theme, plugin etc is gone.

    I imported the .sql on to the remote server too - using PHPMyAdmin and the tables sure are transported, but do I HAVE to work the look and feel of the website from scratch? I must have missed out on something, but can't really put my finger on it.

    Any further tips wd be very handy!

  4. figaro
    Posted 6 years ago #

    However, all the customised work I had spent hrs doing on the theme, plugin etc is gone.

    If you edited any source code on your local install, you will need to make sure those files are transferred to the server. You may have better luck just transferring the complete WP install (all source code) from your local machine to the server.

  5. beegongood
    Posted 6 years ago #

    Thank you @figaro. There were a string of errors I was encountering in the process - I have finally managed to upload the website: I will post the updated url very soon.

    Many thanks once again!

Topic Closed

This topic has been closed to new replies.

About this Topic