PHPackages                             pixelstudio/wp-sync-db - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [Database & ORM](/categories/database)
4. /
5. pixelstudio/wp-sync-db

ActiveWordpress-plugin[Database & ORM](/categories/database)

pixelstudio/wp-sync-db
======================

WordPress plugin to sync database between different installs

1.7.1(6y ago)472.5k91GPL-2.0PHPPHP >=7.0.0

Since Mar 8Pushed 6y ago6 watchersCompare

[ Source](https://github.com/hrsetyono/wp-sync-db)[ Packagist](https://packagist.org/packages/pixelstudio/wp-sync-db)[ Docs](https://github.com/hrsetyono/wp-sync-db/)[ RSS](/packages/pixelstudio-wp-sync-db/feed)WikiDiscussions master Synced 4d ago

READMEChangelog (4)Dependencies (1)Versions (6)Used By (1)

WP Sync DB
==========

[](#wp-sync-db)

> Note: This is the combination of WP-Sync-DB and 2 of its Addons: Media Files and CLI.

Copy your database from one WP install to another with a few clicks in your dashboard.

Especially handy for syncing a local development database with a live site.

[![](https://camo.githubusercontent.com/308b8bb3b5562708b9975527382ea50ef26a6d1018a4cd072c827b89cad128e4/68747470733a2f2f7261772e6769746875622e636f6d2f6872736574796f6e6f2f63646e2f6d61737465722f73796e632d64622f6d6967726174696f6e2d70726f636573732e706e67)](https://camo.githubusercontent.com/308b8bb3b5562708b9975527382ea50ef26a6d1018a4cd072c827b89cad128e4/68747470733a2f2f7261772e6769746875622e636f6d2f6872736574796f6e6f2f63646e2f6d61737465722f73796e632d64622f6d6967726174696f6e2d70726f636573732e706e67)

**TABLE OF CONTENTS**

1. [How to Use](#how-to-use)
2. [Sync Media Files](#sync-media-files)
3. [WP-CLI Integration](#wp-cli-integration)
4. [Help Videos](#help-videos)
5. [How it Works](#how-it-works)
6. [Features Detail](#features-detail)

How to Use
----------

[](#how-to-use)

The guide below assume you're using it to sync online db with local one.

1. Install this plugin on BOTH your online and local installation.
2. In your online installation, go to Tools > Migrate DB > Settings tab. Tick all: "Accept pull", "Accept push", and "Enable SSL".
3. Copy the **Connection Info**.
4. In your local installation, go to Tools > Migrate DB > Migrate tab. Choose Pull or Push and paste in the Connection Info.

    > **PULL** means downloading the online db and use it to overwrite your local db.
    > **PUSH** is uploading your local db to overwrite online db.
5. Configure the Search & Replace. Usually you also need to replace "https" to "http" or vice versa.
6. Click "Migrate DB" and wait for it to finish.

Sync Media Files
----------------

[](#sync-media-files)

Tick "Media Files" when pulling / pushing.

[![](https://camo.githubusercontent.com/e18be806227f91352d58b7de788125252f835e864e443a524a9686a8b16c9f05/68747470733a2f2f7261772e6769746875622e636f6d2f6872736574796f6e6f2f63646e2f6d61737465722f73796e632d64622f6d656469612d66696c65732e706e67)](https://camo.githubusercontent.com/e18be806227f91352d58b7de788125252f835e864e443a524a9686a8b16c9f05/68747470733a2f2f7261772e6769746875622e636f6d2f6872736574796f6e6f2f63646e2f6d61737465722f73796e632d64622f6d656469612d66696c65732e706e67)

Currently doesn't seem to work for multisite.

WP-CLI Integration
------------------

[](#wp-cli-integration)

1. First you need to install WP-CLI. ([Guide for Windows10 »](https://github.com/hrsetyono/wordpress/wiki/Installing-WP-CLI-on-Windows-10))
2. Create a migration profile in WP-Admin.

    [![](https://camo.githubusercontent.com/2b1372071b727e25e989ef120a98d5e0090ae8aad76067e8935578cfc12b731e/68747470733a2f2f7261772e6769746875622e636f6d2f6872736574796f6e6f2f63646e2f6d61737465722f73796e632d64622f70726f66696c65732e706e67)](https://camo.githubusercontent.com/2b1372071b727e25e989ef120a98d5e0090ae8aad76067e8935578cfc12b731e/68747470733a2f2f7261772e6769746875622e636f6d2f6872736574796f6e6f2f63646e2f6d61737465722f73796e632d64622f70726f66696c65732e706e67)
3. Choose the migration profile you want to do and take note of the number. You will use it in the command:

    ```
    wp wpsdb migrate [profile-number]

    ```

    For example `wp wpsdb migrate 2` will do the migration "Pull from example production".

---

Help Videos
-----------

[](#help-videos)

TitleDescriptionLinkFeature WalkthroughA brief walkthrough of the WP Sync DB plugin showing all of the different options and explaining them.[Youtube](https://www.youtube.com/watch?v=u7jFkwwfeJc)Pulling Live Data Into Your Local Development EnvironmentThis screencast demonstrates how you can pull data from a remote, live WordPress install and update the data in your local development environment.[Youtube](http://www.youtube.com/watch?v=IFdHIpf6jjc)Pushing Local Development Data to a Staging EnvironmentThis screencast demonstrates how you can push a local WordPress database you've been using for development to a staging environment.[Youtube](http://www.youtube.com/watch?v=FjTzNqAlQE0)Media Files Addon DemoA short demo of how the [Media Files addon](https://github.com/hrsetyono/wp-sync-media) allows you to sync up your WordPress Media Libraries.[Youtube](http://www.youtube.com/watch?v=0aR8-jC2XXM)How it works
------------

[](#how-it-works)

WP Sync DB exports your database as a MySQL data dump (much like phpMyAdmin), does a find and replace on URLs and file paths, then allows you to save it to your computer, or send it directly to another WordPress instance. It is perfect for developers who develop locally and need to move their WordPress site to a staging or production server.

Features Detail
---------------

[](#features-detail)

- **Selective Sync**

    WP Sync DB lets you choose which DB tables are migrated. Have a huge analytics table you'd rather not send? Simply deselect it and it won't be synced.
- **Pull: Replace a Local DB with a Remote DB**

    If you have a test site setup locally but you need the latest data from the production server, just install WP Sync DB on both sites and you can pull the live database down, replacing your local database in just a few clicks.
- **Push: Replace a Remote DB with a Local DB**

    If you're developing a new feature for a site that's already live, you likely need to tweak your settings locally before deploying. Once you've perfected your configuration on your development machine, it's easy to send the settings to your production server. Just push to the server, replacing your remote database with your local one.
- **Database Export & Backup**

    Not only can WP Sync DB pull and push your DB: it can export your DB to an SQL file that you can save and backup wherever you want. No need to ssh into your machine or open up phpMyAdmin.
- **Encrypted Transfers**

    All data is sent over SSL to prevent your database from being read during the transfer. WP Sync DB also uses HMAC encryption to sign and verify every request. This ensures that all requests are coming from an authorized server and haven't been tampered with en route.
- **Automatic Find & Replace**

    When migrating a WordPress site, URLs in the content, widgets, menus, etc need to be updated to the new site's URL. Doing this manually is annoying, time consuming, and very error-prone. WP Sync DB does all of this for you.
- **Stress Tested on Massive Sites**

    Huge database? No prob. WP Sync DB has been tested with tables several GBs in size.
- **Detect Limitations Automatically**

    WP Sync DB checks both the remote and local servers to determine limitations and optimize for performance. For example, we detect the MySQL `max_allowed_packet_size` and adjust how much SQL we execute at a time.

###  Health Score

36

—

LowBetter than 82% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity29

Limited adoption so far

Community23

Small or concentrated contributor base

Maturity62

Established project with proven stability

 Bus Factor1

Top contributor holds 59.8% of commits — single point of failure

How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window.

**Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores.

**Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement.

**Maturity (30%)** — Project age, version count, PHP version support, and release stability.

###  Release Activity

Cadence

Every ~139 days

Total

4

Last Release

2194d ago

### Community

Maintainers

![](https://www.gravatar.com/avatar/4ef32322d0bfb4c0bf00b283c6dc1013b9fbf4bc9da57dce540f4cff6474e394?d=identicon)[pixelstudio](/maintainers/pixelstudio)

---

Top Contributors

[![notslang](https://avatars.githubusercontent.com/u/1049204?v=4)](https://github.com/notslang "notslang (52 commits)")[![bradt](https://avatars.githubusercontent.com/u/190095?v=4)](https://github.com/bradt "bradt (19 commits)")[![hrsetyono](https://avatars.githubusercontent.com/u/3876541?v=4)](https://github.com/hrsetyono "hrsetyono (8 commits)")[![zamoose](https://avatars.githubusercontent.com/u/862531?v=4)](https://github.com/zamoose "zamoose (2 commits)")[![etcook](https://avatars.githubusercontent.com/u/2329397?v=4)](https://github.com/etcook "etcook (2 commits)")[![jaredh159](https://avatars.githubusercontent.com/u/7050938?v=4)](https://github.com/jaredh159 "jaredh159 (1 commits)")[![joshlevinson](https://avatars.githubusercontent.com/u/2895131?v=4)](https://github.com/joshlevinson "joshlevinson (1 commits)")[![ipmidev](https://avatars.githubusercontent.com/u/13798481?v=4)](https://github.com/ipmidev "ipmidev (1 commits)")[![dseguy](https://avatars.githubusercontent.com/u/170418?v=4)](https://github.com/dseguy "dseguy (1 commits)")

---

Tags

pluginwordpressdatabasesync

### Embed Badge

![Health badge](/badges/pixelstudio-wp-sync-db/health.svg)

```
[![Health](https://phpackages.com/badges/pixelstudio-wp-sync-db/health.svg)](https://phpackages.com/packages/pixelstudio-wp-sync-db)
```

###  Alternatives

[olliejones/index-wp-mysql-for-speed

Speed up your WordPress site by adding high-performance keys (database indexes) to your MySQL database tables.

1481.8k](/packages/olliejones-index-wp-mysql-for-speed)[kmi/db-sync-tool

Python script to synchronize a database from and to client systems.

323.5k](/packages/kmi-db-sync-tool)[devgeniem/better-wp-db-error

Better WordPress database error handling.

1161.3k](/packages/devgeniem-better-wp-db-error)[williarin/wordpress-interop

Interoperability library to work with WordPress database in third party apps

6610.9k2](/packages/williarin-wordpress-interop)[andreagroferreira/laravel-sync-tracker

A Laravel package for tracking entity synchronization status between systems

113.0k](/packages/andreagroferreira-laravel-sync-tracker)

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)