synchronizing two mysql db's...(newbie)

[Aerodyne]

Hi all,

I hope some one can point me in the right direction here...

I need to synchronizing one db on a server (server A) to another db on a seprate server (server B). There both MySQL 4.1.*, is there any way to sync these from the command line (no gui tools)... and what's the easyist MySQL admin tool to help me do this. Much Obliged.


TIA

 

[KarveR]

replication, an inbuilt feature of mysql will keep these up to date (one way only) provided a permanent connection between them is available, otherwise I guess a scheduled mysqldump could do it.

There are plenty of ways, just really depends on how they are set up and what you really want to do.

If you mean sync server A with server B and server B with server A, then that might prove a tad tricky*.


*understatement(tm)

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.

 

[Aerodyne]

Thanks for your reply...

What I want to do is use C-JDBC between them, and in order to have that db A & db B need to be the same... so I need to get B==A. I hope this makes sence.


TIA for any help.

 

[lgarner]

Replication is what you're looking for in order to have some or all databases on two servers "in sync".

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

Bi-directional replication is possible, but not supported and not recommended.