How do I go from MAMP to champ?
February 12, 2012 9:36 PM Subscribe
How do I transfer my locally-created Wordpress site (using MAMP) to my live Dreamhost site?
posted by This_Will_Be_Good to computers & internet (13 answers total) 3 users marked this as a favorite
I have been working on a Wordpress site locally using MAMP for a while. Now, I want to transfer this to the live site which is hosted at Dreamhost. I am not a web developer or whatever, so go easy on me.
(It's not a big deal if I botch this, as the site has never been published before. I also just put up an htaccess file on the live remote site so nobody can really access this while I am doing this transfer.)
So, I realize that I can push all the files from the local to the remote site via FTP, but I am pretty sure I also need to transfer all the date on the local SQL database, as that won't go over by just FTP'ing my local Wordpress directory, right?
I installed Wordpress on the live Dreamhost site, and it is up and running. However, it looks like Dreamhost used some odd database naming. Also, all the fields in the table on Dreamhost seem odd. For example, on my local setup I have "wp_posts". However, on Dreamhost, they are called something like "wp_asdlfk_posts". I don't really get what that middle jibberish is for (I just typed that jibberish in case the real jibberish is some password or something).
So, do I need to rename the remote database?
And then, do I need to rename all the fields before I import the local stuff? Or do I just need to delete and then overwrite everything?