Title: Syncing a WordPress database between XP and Linux?!
Last modified: August 18, 2016

---

# Syncing a WordPress database between XP and Linux?!

 *  [randyburgess](https://wordpress.org/support/users/randyburgess/)
 * (@randyburgess)
 * [20 years, 3 months ago](https://wordpress.org/support/topic/syncing-a-wordpress-database-between-xp-and-linux/)
 * A very naive question: I have been using a local version of WordPress on Gentoo
   for several months now; recently upgraded to WordPress 2.0 with no problems. 
   I dual-boot the machine with XP (I have to have Windows for various work-related
   reasons), and I would love to be able to have access to the blog on the XP side
   as well. I do a lot of syncing already with unison for ordinary data files so
   I can switch between OS’s without a lot of fuss.
 * As test, I copied over the MySQL database and WordPress install for my blog to
   the XP partition, set up XAMPP Lite and got everything working. I could see the
   blog fine, and was able to create a test post in XP no problem.
 * The next step in the test was to manually copy the database files back to the
   Linux side, massage the permissions as needed, and then see if the new post showed
   up. It didn’t! All my old posts were there, but not the new post. It was in the
   database – I could see it in PhpMyAdmin, and also in WordPress when I went to
   Manage > Posts – but though I could edit it in WordPress and save it as many 
   times as I wanted, it refused to show up as an actual post.
 * The versions of MySQl are both 4.1.x, and the MySQL log isn’t complaining of 
   anything.
 * It may be a doomed, twisted experiment, but is there any way to make this work?
   There must be something wrong with the database entry as created on XP versus
   as it would have been created on Linux – yet that seems strange since all the
   original posts transferred just fine from Linux to XP and survived the return
   trip as well.
 * I don’t want to get into dumping the database and recreating it each time I boot
   from one OS to the other – that’s just too much work for what I want to be a 
   relatively simple process.

The topic ‘Syncing a WordPress database between XP and Linux?!’ is closed to new
replies.

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)
 * [linux](https://wordpress.org/support/topic-tag/linux/)
 * [MySQL](https://wordpress.org/support/topic-tag/mysql/)
 * [xp](https://wordpress.org/support/topic-tag/xp/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 0 replies
 * 1 participant
 * Last reply from: [randyburgess](https://wordpress.org/support/users/randyburgess/)
 * Last activity: [20 years, 3 months ago](https://wordpress.org/support/topic/syncing-a-wordpress-database-between-xp-and-linux/)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics