Title: Help with moving database …
Last modified: August 18, 2016

---

# Help with moving database …

 *  Resolved [thornomad](https://wordpress.org/support/users/thornomad/)
 * (@thornomad)
 * [19 years, 8 months ago](https://wordpress.org/support/topic/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)

 *  Thread Starter [thornomad](https://wordpress.org/support/users/thornomad/)
 * (@thornomad)
 * [19 years, 8 months ago](https://wordpress.org/support/topic/help-with-moving-database/#post-447536)
 * 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 ‘Help with moving database …’ is closed to new replies.

## Tags

 * [installation](https://wordpress.org/support/topic-tag/installation/)
 * [moving](https://wordpress.org/support/topic-tag/moving/)
 * [MySQL](https://wordpress.org/support/topic-tag/mysql/)

 * In: [Installing WordPress](https://wordpress.org/support/forum/installation/)
 * 1 reply
 * 1 participant
 * Last reply from: [thornomad](https://wordpress.org/support/users/thornomad/)
 * Last activity: [19 years, 8 months ago](https://wordpress.org/support/topic/help-with-moving-database/#post-447536)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics