• Hi guys, i am having issues with migrating my wordpress site from one computer (Windows) to another computer(Mac OS X). I used WAMP to develop my sites locally (none of my site is live as i am still learning how to use wordpress efficiently) now i want to migrate the websites to MAMP on Mac. I exported my database from the WAMP and imported it into MAMP then i transferred all my wordpress site files into the second computer (Mac) and put the files into the MAMP htdocs folder. After doing all this, the site is not still working. I am new to wordpress and i am not so techy. Please is there anyone that can put my through by explaining how i can get this sites to work on my Mac via MAMP in simple words that i can easily comprehend? thank you so much as you assist me.

Viewing 15 replies - 1 through 15 (of 15 total)
  • In both cases you still have the same mysql database in use so there should not be any problems if you have all the password and site urls configured correctly.

    Check in the wp_options database that the urls are correct. If the url is different with MAMP you can change them from your db file with a tool like Peach for example, https://petesaia.github.io/Peach/

    Without any specific information about the exact error that you’re having It is quite difficult to help more. Maybe post a screentshot.

    If you are using the default settings for MAMP (document root and server ports), then that is the issue.

    MAMP for Mac uses port 8888 for Apache so your URL would be:

    https://localhost:8888/folder-name

    As tero2000 mentioned, using phpMyAdmin, edit the siteurl and home fields in the wp_options table to reflect the above-noted URL (using the folder name you are using). This will then allow you to log into the Dashboard where you install and run this plugin:

    https://www.ads-software.com/plugins/better-search-replace/

    This will update all the other URLs/links. Once that is done, go to Settings > Permalinks and just click Save Changes; this rebuilds the .htaccess file.

    Cheers!
    Lyle

    Thread Starter craigable09

    (@craigable09)

    /Users/BlackIce/Desktop/screenshots/Screen Shot 2016-08-28 at 2.20.06 AM.png

    @terro2000 attached is the screenshot of what it shows when i key in this like in my safari url https://localhost:8888/wordpress2/ and where will i configure the site url and the password? and where can i locate the wp_options database to check if the urls are correct. sorry i am not so techy ?? i need to understand this in the simplest terms as i am not so familiar on how to use mysql all i know is the phpadmin where i imported the sql file into my MAMP

    Thread Starter craigable09

    (@craigable09)

    @terro2000 @ Learn WP Basics i have located the wp_options in my database and i have changed the site url and home to https://localhost:8888/folder-name and i am still getting error messages like “Error establishing a database connection” i have also restarted the WAMP server and refreshed the page but it says the same thing. The WAMP MyPHPadmin did not have a password, it had only username which was “root” but i have noticed that MAMP has “root” as it’s MyPHPadmin username and password. where can i locate this password and change it? when i was settling up my WAMP i set up the db name, username and password in the wp_config.php in my wp contents folder. Should i also edit those files as well?

    Thread Starter craigable09

    (@craigable09)

    @terro2000 @ Learn WP am i suppose to create a new database in MyPHPadmin then import the sql zipped file into the newly created database?

    Thread Starter craigable09

    (@craigable09)

    *phpMyAdmin

    “folder-name” was just a place holder and not an actual value to use ??

    You said you copied the files into the MAMP htdocs folder. Did you create a folder within there and place them in it or are they already in a folder that you copied from the PC?

    Are they like:

    htdocs
    wp-admin
    wp-content
    wp-includes

    If like this, the URL is https://localhost:8888

    Or like this:

    htdocs
    /wordpress/wp-admin
    wp-content
    wp-includes

    If like this, the URL is https://localhost:8888/wordpress <that is, wordpress is the folder name ?? >

    And if all else fails, just use the Duplicator plugin ??

    https://www.ads-software.com/plugins/duplicator/

    Thread Starter craigable09

    (@craigable09)

    @learn WP Basics thank you for getting back to me. I did not create a new folder nor database. All i did was to copy all the wordpress folders(with the files inside) from the www folder of the WAMP where the wordpress files were housed and then pasted the whole folders/files inside the htdocs folder of the MAMP. i understood what you meant by the URL which i have changed both in the site and home table of only one of the website database via phpMyAdmin which i am using to test to see if it will connect. Now after changing the table, i also changed the value in the config.php file to localhost:8888 which did not work so i set it back to how it was before. Now the url i key in is https://localhost:8888/wordpress (the folder name of my site is wordpress) and all i get is a white blank screen. no more error message that states that it can’t connect to database. what should i do now please?

    Thread Starter craigable09

    (@craigable09)

    now i am still getting the “Error establishing a database connection” message

    Can’t see the attachment.

    You can also change the port from MAMP if you previously had it on localhost which is same as localhost:80. In MAMP preferences go to Port tab and change the port from 8888 to 80.

    In MAMP you can also change the folder where you choose to start the Apache. So you can also modify that as well.

    In Peach (see the link I previously posted) you can change the urls in your db dump. Just upload the dump file there and then change the url.

    You might also have modify the .htaccess file which is in your wordpress root.

    Thread Starter craigable09

    (@craigable09)

    @tero2000 thanks but how do i locate the .htaccess file which is in your wordpress root and where can i locate my db dump? i have tried to change the port before and it didn’t still work.

    Thread Starter craigable09

    (@craigable09)

    Hi guys i have succeeded in migrating the site based on your ideas, thank you very much. But i have one problem, after moving the site and opening the website on my local machine my contents whereat showing. like the pictures i used on the site, logo etc but every text was showing and i noticed that the pictured are on my media folder yet they are not showing on the site, they display like broken icons. Please how can i rectify this?

    Thread Starter craigable09

    (@craigable09)

    Hey guys just so you know, i have succeeded in the migration and replacement of URLs. Thanks for your support.

    arjunmr

    (@arjunmr)

    Hey craigable09, I am in the exact situation as you are. Just can’t get the migration to work. Getting database connection error. Could you please tell what worked for you finally, I mean the steps. I have the project folder from WAMP installed in htdocs and also have database with same name imported to phpmyadmin. wpconfig.php I have set it up exactly as I had in WAMP. So password is blank. Can you please help?

Viewing 15 replies - 1 through 15 (of 15 total)
  • The topic ‘Migration from WAMP to MAMp localhost’ is closed to new replies.