Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

In phpMyAdmin there is a tab for configuring Replication and one for Synchronization.

  • What is the difference between Replication and Synchronization?
  • When do you should use the one or the other?

Thanks, Udo

share|improve this question

migrated from Jan 26 '11 at 15:46

This question came from our site for computer enthusiasts and power users.

up vote 8 down vote accepted

After some digging, the answer in the MySQL/phpMyAdmin context is as follows:

  • Synchronization: Brings 2 DBs in sync (schema and data)
    Note: This is a 1-time process, which can be run every time you would like to sync 2 DBs, but is triggered manually.
  • Replication: This is used to continuously (automatically) replicate data between 2 DBs. This is done asynchronously, which means that you do not have to have a permanent connection between the 2 DBs.

To setup replication the sequence is this:

  • Run Synchronization to sync DBs
  • Setup Replication
share|improve this answer

Replication is used to describe the event of copying data. Synchronization is continuous (at least one way) replication that maintains consistency between multiple data sources.

From documentation

9.1 How can I synchronize two databases/tables in phpMyAdmin?

You can now synchronize databases/tables in phpMyAdmin using the Synchronize feature. It allows you to connect to local as well as remote servers. This requires you to enter server host name, username, password, port and the name of the database. Therefore you can now synchronize your databases placed on the same server or some remote server.

This feature is helpful for developers who need to replicate their database’s structure as well as data. Moreover, this feature not only helps replication but also facilitates the user to keep his/her database in sync with another database. Other than the full database, certain tables of the databases can also be synchronized.

share|improve this answer
The question is tagged [mysql] and [phpmyadmin] -- I have the impression the user is asking for more specific information. – Daniel Beck Jan 24 '11 at 10:48
Thanks for the feedback Daniel, I found more specific information and included it and a source link. – Mark Essel Jan 26 '11 at 19:11

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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