MySQL Forums
Forum List  »  MySQL Administrator

Re: MySql GUI Tools
Posted by: Barry Galbraith
Date: August 04, 2009 04:20PM

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.

Options: ReplyQuote

Written By
August 02, 2009 06:06PM
August 02, 2009 06:52PM
August 03, 2009 02:31AM
August 03, 2009 03:25AM
August 03, 2009 03:37AM
August 03, 2009 05:14AM
August 03, 2009 07:53AM
August 04, 2009 07:39AM
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.