Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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

This question is an exact duplicate of:

I have two databases, one in the domain and managed by phpMyAdmin, and the other is located on the local server. I want make the local one as master and the other reside in the domain as slave. With phpMyAdmin, can I synchronous the databases at real time ? How ?

NOTE: both databases are using MySQL.

In other words, Whenever I have add new table or data on the master database, I want to see the change on the slave also.

Other question; If possible, how can I do; If any change occurs on the specified table, namely foo_table, on the Domain database which is slave, I want to see this change on the local one which is master. All other masters, not including foo_table, tables are synchronized with the other tables on the slave database.

share|improve this question

marked as duplicate by Ladadadada, Ward, Jenny D, Dave M, dunxd Apr 14 '13 at 20:08

This question was marked as an exact duplicate of an existing question.

You can use MySQL replication, although it is not synchronous, so there will be a delay (usually seconds).

There is more information on replication in MySQL documentation:

share|improve this answer

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