WordPress.org

Ready to get started?Download WordPress

Forums

Moving your database- how to? (6 posts)

  1. akanowicz
    Member
    Posted 7 years ago #

    I'm doing WP development on my Mac- running the webserver, mysql, etc- it's great.

    When I'm done, not only will I move the WP files to the actual webserver, but I would also like to move the mysql database as well since all the categories, etc will be setup.

    How do I move a local mysql database to a webserver? I suppose I'll need to create the database remotely, first, and then import (?) the existing db into the new one?

    thanks for your help-
    Ron

  2. ekusteve
    Member
    Posted 7 years ago #

    Not sure about the Mac environment, but essentially what you would need to do is export (dump) your database and then you can create the database on the webserver and import the sql file. This is pretty easy to do with phpMyAdmin...again, not sure if you have this in the Mac environment.

    Steve

  3. akanowicz
    Member
    Posted 7 years ago #

    I can open a terminal session and login to mysql and run commands from the command line. I think I can also use phpMyAdmin on my Mac too...it's unix at the core :-)

  4. Chris_K
    Member
    Posted 7 years ago #

    Moving_WordPress is worth a look.

  5. akanowicz
    Member
    Posted 7 years ago #

    Thank you, I'll check that out.

    My next question is this:
    Can I create a db on a remote webserver, but run WP locally on my machine, adding the db info into my config file?

  6. moshu
    Member
    Posted 7 years ago #

    Usually - no. Hosts don't let you to connect remotely to DB servers.

Topic Closed

This topic has been closed to new replies.

About this Topic