Viewing 8 posts - 1 through 8 (of 8 total)
  • Author
    Posts
  • April 1, 2015 at 11:27 am #421829
    Frank

    Hi guys,
    I’m trying to setup a local server for my sites with Enfold, Flashlight and Propulsion. Therefore I installed MAMP. In oder to make the sites run locally I did the following:

    1. Download of all Files and Database from Webhoster Server via FTP
    2. Open up a new database on local server with the same name as on the live server
    2a. Import all data from live database sql file in this local database
    3. Changed WP Config.php: Databasename: New Database, Username: root, PW: root, Host: localhost

    But, whatever I do, I always get the same error indication: Fehler beim Aufbau einer Datenbankverbindung (Mistake by building up a connection to a database). What is wrong or missing? Probably local SQL URL, but where do I have to put it in and where is it to find? Or do you have any idea for a approved workaround? Below you will find the content of WP config.

    Thank you,
    Frank

    • This topic was modified 9 years, 7 months ago by Frank.
    April 1, 2015 at 1:18 pm #421858
    Frank

    Update: It seems, that everything is ok until I import the content of the online database. This still seems to point to the online URL.
    Even if I put in that code into SQL:

    UPDATE wp_options
    SET option_value = ‘http://localhost:8888/styleandrestyle/’
    WHERE option_name = ‘siteurl’ or option_name = ‘home’;

    Frank

    April 1, 2015 at 1:52 pm #421868
    Yigit

    Hey Frank

    It would be a lot easier if you use a plugin such as the ones we suggested here to move your database – http://kriesi.at/documentation/enfold/move-from-a-local-installation-to-a-live-server/

    Cheers!
    Yigit

    April 1, 2015 at 2:06 pm #421880
    Frank

    Hey, thank you Yigit. I will try this. Another Plugin that seems to be helpful is “Duplicator”. WP MigrateDB or WP MigrateDB PRO is only for migration of the database, right? Have you any experience with “Duplicator”?

    April 1, 2015 at 2:15 pm #421893
    Yigit

    Hi!

    I am not very experienced with Duplicator plugin but WP MigrateDB or WP MigrateDB PRO works totally fine for me. Yes, it does migrate your database so all you need to do is to create a new installation and to migrate your database. I copy&paste wp-content file as well

    Best regards,
    Yigit

    April 2, 2015 at 10:09 am #422367
    Frank

    Hi Yigit, I’ve tried the following:
    1. Set up an new local Database (same name as from the live site) = works
    2. Set up a new clean WordPress Installation locally in a folder called “dev.styleandrestyle.de” and connect to above named database = works
    3a. Export Database from the live site with WP MigrateDB PRO, = works (I put the development folder in the folder sites), Settings
    New URL: localhost/dev.styleandrestyle.de/
    New Place: /Users/Frank/Sites/dev.Styleandrestyle.de
    3b. Import that Database into local Database from step 1 = works
    4. Download the complete Installation from Webhoster by ftp = works
    5. Replace the wp-content folder in local WP Installation from step 2 with wp-content folder from the server = works
    6. Login under URL: localhost/dev.styleandrestyle.de (WP login mask came up)
    6a. After login with username and password, I got the following error message:
    Not Found
    The requested URL /dev.styleandrestyle.de/localhost/dev.styleandrestyle.de/wp-admin/ was not found on this server.
    It seems, that the name of the local folder (dev.styleandrestyle.de) get doubled in requested URL. But why?

    Frank

    btw – This is a Flashlight Installation. If this is working I will go to Enfold and Propulsion Sites
    Additional Info – I set local host in MAMP to standard ports 3306 for MySQL and 80 for Apache

    April 2, 2015 at 3:50 pm #422538
    Yigit

    Hi!

    Please install plugin on both installations and check URL and file path – http://i.imgur.com/jOriDzF.png
    Copy content of “find” new installation and paste it into “replace” in old installation. Everything else seems to work fine

    Best regards,
    Yigit

    March 1, 2016 at 11:11 am #591453
    Frank

    I’m still working on this. But topic can be closed by now. Thanks for you help.

    Regards,
    Frank

  • Author
    Posts
Viewing 8 posts - 1 through 8 (of 8 total)
  • The topic ‘Local Server Set-Up for MAMP’ is closed to new replies.