I have development and production versions of my website (on the same hosting). I want to easily synchronize the content between these versions. On the production website, content is updated daily.

I cannot use the XML export function because duplicate posts would be created on the development website.

Currently both websites uses different databases, but if there is a solution that allows for usage of only one database I gladly will go through it.

1 Answer 1


If you never send/sync Production posts to live.

Then just pull/copy the live database to the development database via mysqldump (or similar) and use wp-config vars to force the site and blog URL.

Use the following in the dev versions wp-config.php to force the URL's

define('WP_SITEURL', 'http://example.com');

You may as well sync the entire database, rather than just posts, so then you get all the post revisions as well as any plugin configurations/data.

This is my normal method of developing a live site, locally. (Grab live DB drop Dev DB import Live DB into Dev) (The only fun bit is sending specific plugin configs up to the live site from the dev site)

  • 1
    Thanks! I found a very useful plugin called SitePush which do all this job for me, plugin use mysqldump for database management, but also have options for sync theme or plugin files. Here is the plugin page: wordpress.org/extend/plugins/sitepush/installation Commented Nov 21, 2012 at 23:08
  • To be honest and this is my opinion. If you are using a plugin to do this, you are not developing your site properly. As your development site won't be a true model of the live site. You should look at using version control for file management. Commented Nov 22, 2012 at 15:36
  • Let alone the likely hood that using a plugin relies on PHP/Apache's memory limit to export the database from a command line application Commented Nov 22, 2012 at 15:45

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.