I'm a neophyte with this stuff, but after reading the doc files here:
I was getting more familiar with what to do. HOWEVER, I want to use my existing WP site that is hosted; So I found this link:
that helped, somewhat. Here's where I stand:
I downloaded my WP site folders and put them in Appications/MAMP/htdocs. The folder inside htdocs is labeled xxxxwordpress. (all my wp-admin, wp-content, wp-includes folders and all the wp-xx.php files are in there). In MAMP, I told it the document root of /Applications/MAMP/htdocs. Is that correct or should it say /Applications/MAMP/htdocs/xxxxwordpress?
I created a database using Launch myPHPadmin from MAMP dialogue box; I then imported the data that I had exported from my live site. All went well with that. Out of curiosity I typed in my browser window: localhost:8888xxxxwordpress/wp-admin. It brings me to my WP admin login page but if I log in there, anything I do affects my live version still. That's because the database hasn't been updated with the local host site name, correct?
So I have to do those changes in the myphpadmin. However, in the database, I clicked on sql, and pasted the code from the documentation. Now, I should be replacing 'hosted version.com' with my real site name, correct? and the 'localhost' with the local name, but I'm unsure whether I should just be using http://localhost/xxxxwordpress or if I need more path information there. I used 'http://localhost/xxxxwordpress' just to see. That change took (I checked by browsing the sql wp-options table). So I went to the next step, pasting code into wp_posts, for 'guid'. I hit the go button and I get a yellow bar at the top of the window with the spinning wheel, saying LOADING. But how long does that take? I let it run for 10 minutes and it didn't stop….still going in fact! what should I do next? I will have to force it to stop somehow, by clicking on another table in left column perhaps, but I need to get past this and get the changes made in the db...thanks for any help any of you can give....