Error on filezilla & question regarding local install of LIVE site using MAMP

  • Resolved CarlaChristineMonson

    (@carlachristinemonson)


    9 years, 2 months ago

    Hello, thanks for coming to my rescue!

    Currently I have MAMP installed and I have a live wordpress site that i’d like to work on locally.
    I’ve exported all of my database’s from my hosting phpmyadmin, currently the file is zipped sitting in my downloads.
    My MAMP preferences are set to save the root file to htdocs as suggested.

    I was advised to download filezilla which i have done and i’ve filled in my correct FTP login/user details. However there I get an error code:
    Error: Could not read from socket: ECONNRESET – Connection reset by peer
    Error: Disconnected from server

    Please can someone explain to me where I need to go from here?
    I’m tempted to get the duplicator plug in but I want to learn this myself!
    I’ve read/watched countless tutorials but I feel like i’m missing one or two little steps.

    My goal is to get this done today! Please help.
    Thank you.
    Carla

Viewing 2 replies - 1 through 2 (of 2 total)

  • I was advised to download filezilla…
    …I get an error code:
    Error: Could not read from socket: ECONNRESET – Connection reset by peer
    Error: Disconnected from server

    Your host would be the best place to get support for getting that working at your specific server.

    I’ve exported all of my database’s from my hosting phpmyadmin, currently the file is zipped sitting in my downloads.

    I think you mean to be saying you have exported all the tables from your single database. After importing those tables into you local database, you will need this SQL code to update the database to your local URL unless you did that at Settings > General prior to the download:

    UPDATE pref_options SET option_value = replace(option_value, 'https://www.olddomain.com', 'https://www.newdomain.com') WHERE option_name = 'home' OR option_name = 'siteurl';
UPDATE pref_posts SET guid = replace(guid, 'https://www.olddomain.com', 'https://www.newdomain.com');
UPDATE pref_posts SET post_content = replace(post_content, 'https://www.olddomain.com', 'https://www.newdomain.com');

    * note: Edit ‘pref’ (three places) to your own table_prefix and change ‘https://www.olddomain.com’ and ‘https://www.newdomain.com’ as required (three places each and with no trailing slashes)

    My MAMP preferences are set to save the root file to htdocs as suggested.

    You should get a default installation of WordPress running before importing anything, and then simply add your tables to the database and edit wp-config.php accordingly while also copying the contents of /wp-content/ into place (or you can do that even beforehand).

    My goal is to get this done today!

    That could be possible, but it typically takes a bit longer the first time.

    Thread Starter CarlaChristineMonson

    (@carlachristinemonson)

    Good morning!
    Thank you for taking the time to respond to me, super helpful!
    I did manage to get there in the end so thank you.
    Have a good day.
    Carla

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Error on filezilla & question regarding local install of LIVE site using MAMP’ is closed to new replies.