[resolved] Help with moving database ... (2 posts)

  1. thornomad
    Posted 8 years ago #

    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).



  2. thornomad
    Posted 8 years ago #

    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!

Topic Closed

This topic has been closed to new replies.

About this Topic