WordPress.org

Support

Support » Installation » [Resolved] Help with moving database …

[Resolved] Help with moving database …

  • Hi I am moving my wordpress databases from one system to another. (Both are at home: am moving from my Mac to my Unix Server.)

    I seem to have been partially successful and not sure how to be completely successful. Here is what I did:

    First, I changed the URI settings (Blog/Wordpress) under options to reflect my new IP address. Then I closed the blog, archived the entire folder (in case I need it later) and moved it to my other system.

    Second, on my first system, I went and backed up the mysql database using terminal:

    mysqldump --add-drop-table -h localhost -u root -p wordpress | bzip2 -c > wordpress.backup.sql.bz2

    Then I moved that file to my Unix box and uncompressed it. I then created a new database in mysql on the new system and then ran:

    mysql -h localhost -u root -p wordpress < wordpress.backup.sql

    To load the backed up database (I took this all from the Docs).

    Thanks.

    Damon

Viewing 1 replies (of 1 total)
  • Hmm … nevermind. It is something wrong with my eventcalendar plugin … not sure what the problem is but wordpress works fine with that plugin disable. Scratch it!

Viewing 1 replies (of 1 total)
  • The topic ‘[Resolved] Help with moving database …’ is closed to new replies.
Skip to toolbar