{"id":24858,"date":"2015-10-05T21:01:17","date_gmt":"2015-10-05T13:01:17","guid":{"rendered":"https:\/\/www.hongkiat.com\/blog\/?p=24858"},"modified":"2022-10-18T20:12:41","modified_gmt":"2022-10-18T12:12:41","slug":"sync-db-multiple-wordpress","status":"publish","type":"post","link":"https:\/\/www.hongkiat.com\/blog\/sync-db-multiple-wordpress\/","title":{"rendered":"How to Sync Databases Across Multiple WordPress Installs"},"content":{"rendered":"

Previously, we had a look at how to setup staging environment for WordPress development<\/a>. If you have followed it through, you might find that the process sometimes involves migrating the SQL database to synchronize the discrepancies between the stages<\/strong>. This particular process of migrating database could be tedious.<\/p>\n

You will have to export the database from the first site then import it to another one, which could take a couple of minutes or more for a huge database. This process will need to be repeated each time<\/em> we migrate the database<\/strong>.<\/p>\n

If this is something that you have been struggling with, you certainly would find this post useful. In this post, we are going to see how streamline the database synchronization across multiple WordPress installs<\/strong>. This will help us save a lot of time.<\/p>\n

Getting Started<\/h2>\n

To begin with, I assume that you have had the three development stages \u2013 Local<\/em>, Testing<\/em> and Live<\/em> \u2013 all set up.<\/p>\n

Here, I\u2019ve setup a scenario where I have 5 posts published on a live site, and 2 more posts are in a local site (one that is still being developed). In reality though you will be dealing with a lot of posts, than just 2 or 5.<\/p>\n

<\/figure>\n

Now I would like to update the local<\/em> site with the content on the Live<\/em> site. Having an identical database content as the one found on Live<\/em>, while developing, is encouraged. This is so we could catch any issues<\/strong> regarding the styles, layout, or any thing that may affect the content early on.<\/p>\n

Syncing the Database<\/h2>\n

To sync the database, follow these steps:<\/p>\n

    \n
  1. \n

    Install the WordPress plugin, Database Sync<\/a>. Just install the plugin in the websites where you would perform the database migration, let\u2019s say if you were to pull the database from a Live<\/em> stage into the Testing<\/em> stage, then you should install the plugin in the site for these two stages.<\/p>\n<\/li>\n

  2. \n

    In the Live<\/em> site, go to Tools > Database Sync<\/strong>. Then, generate the secret token key.<\/p>\n

    <\/figure>\n

    You must not share this secret key to anyone as it will allow them to access your database as well.<\/p>\n<\/li>\n

  3. \n

    Add the token in the Tools > Database Sync<\/strong> of the Local<\/em> stage site.<\/p>\n

    <\/figure>\n

    As the Token is added, you will find the Sync<\/strong> next to the linked site, as shown in the above screenshot.<\/p>\n<\/li>\n

  4. \n

    Click the Sync<\/span> button to start synchronizing these two sites.<\/p>\n<\/li>\n

  5. \n

    Click the Pull<\/strong> button to pull the remote site database down and replace the local<\/em> site.<\/p>\n

    <\/figure>\n<\/li>\n<\/ol>\n

    Keep in mind though that the process of pulling<\/em> and pushing<\/em> may take minutes, or longer, depending on the size of the database. Once the pulling<\/em> process is complete, you should see a success message on the screen. And the local<\/em> site should now have the exact same posts, pages, and settings as the Live<\/em> site.<\/p>\n

    <\/figure>\n

    Alternatively, click the Push<\/span> button if you would like copy the current site to remote websites. Install this plugin in multiple web sites as needed and add the tokens to link to their database.<\/p>\n

    This plugin makes database synchronization seamless and sound. I hope that the plugin developer would improve it further with some additional features, such as:<\/p>\n