Syncronising MySQL databases

How do I syncronise two mysql servers?

[andylarks]

Hi

I've read through the mysql documentation on syncronising two machines, setting up a slave and a master, but it didn't make a whole lot of sense :(

Can anyone give me/point me towards a step-by-step guide to setting up a slave and master.

(My problem is that what will be the master is already live, so I don't really want to screw it up!)

Thanks heaps

Andy

[bakedjake]

Here's a good one (albeit a bit old, but still valid), with info on modifying your connect strings in php as well:

[phpbuilder.com...]

[jamesa]

backup first

[panoylis]

Andy,

I feel more comfortable running a cron job with a mysqldump every now and then through the day, than to follow the synchronize steps :-)

there is something telling me that your way is the way to do it but...

Panos

[edited by: panoylis at 1:48 pm (utc) on Dec. 9, 2003]

[andylarks]

Thanks, all, for your replies.

I've managed to do it now by combining bakedjake's link and the Mysql instructions. Actually, it wasn't anything like as difficult as I thought it was going to be :o)

Thanks again

Andy