WordPress.org

Ready to get started?Download WordPress

Forums

Linking mysql database with local wp instal (8 posts)

  1. erikturner
    Member
    Posted 3 years ago #

    I have a local version of WP running with MAMP, but I already have a WP site I've been using on a server that I'd like to try out different themes with. I've downloaded the sql file from my server, but am not sure how to link it with my wp installation. I'm thinking this has to be a very simple operation that I'm just glossing over. I've read through the "moving wordpress" section but it all seems to be more complicated than I need and applies to moving from one remote server to another. any tips would be greatly appreciated!

    thanks,
    Erik

  2. 123milliseconds
    Member
    Posted 3 years ago #

  3. erikturner
    Member
    Posted 3 years ago #

    thanks-- I'm guessing I need to do the bit under #2, but where do I enter that code? MAMP is just a program that is getting the servers to run right? I'm not sure where I use the code...thanks
    Erik

  4. 123milliseconds
    Member
    Posted 3 years ago #

    Hi

    >>Put the backed-up SQL back into MySQL:

    you have to SSH into your webhost to get to a command line to do this:....

    mysql -h mysqlhostserver -u mysqlusername
    -p databasename < blog.bak.sql

    Enter password: (enter your mysql password)
    user@linux~/files/blog:>

    ==================

    Easiest:

    YOu have to do step one.

    1. Login to phpMyAdmin.

    2. Click databases, and select the database that you will be importing your data into.

    ---

    You have to download and install the free phpmyadmin

    You may end up using it a lot, especially if you are a beginner.

    http://www.phpmyadmin.net/

  5. erikturner
    Member
    Posted 3 years ago #

    If I am running wp locally from my machine (mamp runs local sql and apache servers) how would these steps change?

  6. 123milliseconds
    Member
    Posted 3 years ago #

  7. erikturner
    Member
    Posted 3 years ago #

    ... and if I were to try and stretch out your help even more... for mac I'd look to use the terminal instead of RUN?

  8. 123milliseconds
    Member
    Posted 3 years ago #

    Do not know mac

    I assume so; try

Topic Closed

This topic has been closed to new replies.

About this Topic