Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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 has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

1 Answer 1

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:

http://dev.mysql.com/doc/refman/5.5/en/replication.html

share|improve this answer

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