Re: MySql GUI Tools
The Reference Maual, Sect 16.1.1. lists the steps for replication.
Some tasks can be done with the GUI, some only with the command line.
On the master server.
Provde a "replication user". You can only grant replication privilege with the command line.
Enable binary logging (with the GUI)
Provide a Server id (with the GUI).
On the slave server. (with the GUI)
Provide a Server id
Select whether you want to limit replication to one or more databases.
Select whether you want to limit replication to one or more tables.
On the slave (with command line)
Set Master info with CHANGE MASTER TO ...., which will tell the slave the address of the master, the port the master is listening on, the replication username, and password to use, and the binary log file name and position.
Good luck.
Subject
Written By
Posted
Re: MySql GUI Tools
August 04, 2009 04:20PM
September 25, 2009 04:09AM
September 25, 2009 05:24PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.