WordPress.org

Ready to get started?Download WordPress

Forums

Local Host Installation Problems (4 posts)

  1. montrealgodzilla
    Member
    Posted 2 months ago #

    Hi there. I'm installing my live site onto my local host. I did this once before, but have largely forgotten the process. Thus far, I've managed to download a fresh copy of wordpress into my MAMP root directory in a folder called devsite. I was able to login to a totally clean copy of wordpress on my local host.

    Of course, I don't want a "clean copy." I want a copy of my live site so I can play around with it and fix it up. So, currently, I am in the process of using FTP to copy the contents of my wp-content folder from the live site to the devsite folder (the localhost) too.

    1) I keep reading about how people need to change URLs and stuff on the localhost using the myPHPstart page database stuff. I'm perplexed by what this is about. Someone please tell me what I should do. Please tell me very specifically what to do step by step how to search and change things if they need to be changed.

    2) Also, for the future, did I need to download my entire wp-content folder or just the theme and its child???

  2. Mark Wilkinson
    Member
    Posted 2 months ago #

    The best thing to do it access your hosting control panel (cPanel?) and create a ZIP file of your entire sites files (assuming they are not going to mega amount of gigabytes!). Download this and extract into the 'devsite' folder making sure the structure is the same.

    Then take a backup of your database from your control panel, or from phpmyadmin on the export tab at the top.

    Create a new database in MAMP and use the import tab at the top to import your database.

    Now change the wp-config.php database connection details to your local database connection details.

    Finely you need to run a search and replace on the database to find all the instances of the live URL and replace them with the local URL (with MAMP probably something like localhost:8888/devsite). This search and replace tool works a treat:

    https://github.com/interconnectit/Search-Replace-DB

  3. montrealgodzilla
    Member
    Posted 2 months ago #

    I get the following error message when trying to import my downloaded database into MAMP's database on the localhost

    SQL query:

    --
    -- Database: information_schema
    --
    CREATE DATABASE information_schema DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

    MySQL said: Documentation

    #1044 - Access denied for user 'root'@'localhost' to database 'information_schema'

  4. montrealgodzilla
    Member
    Posted 2 months ago #

    Went back and downloaded just the wordpress database without the information schema database. Things didn't get better. More error messages. I guess I'm not remotely understanding what Mark is telling me. At any rate, I'm back at square one. I have a MAMP database with a clean copy of wordpress in it. I have FTP access to my wordpress files on my remote server. I use godaddy for my remote server. How do I more or less clone my remote site (www.montrealrampage.com) onto my local version of the site (to "localhost:8888/devsite") from here so I can work on improving my category pages and such.

    Please be really clear about these steps. Even walking me through a few of them would really help!

Reply

You must log in to post.

About this Topic