MySQL Forums
Forum List  »  Replication

plzzzzzzz help me (how 2 do replication using mysql and windows)
Posted by: daisy m
Date: December 18, 2008 01:58AM

common information
-----------------------------


master ip=192.168.10.65
slave ip=192.168.10.67
replication slave user =replicant
replication slave pasward=my_pwd

step 1

(on master's my.ini file)
log-bin=mysql-bin
server-id=1
innodb_flush_log_at_trx_commit=1
sync_binlog=1

step 2

(on master's mysql console)
GRANT REPLICATION SLAVE, REPLICATION CLIENT
ON *.*
TO 'replicant'@'192.168.10.67'
IDENTIFIED BY 'my_pwd';

FLUSH TABLES WITH READ LOCK;
SHOW MASTER STATUS;

UNLOCK TABLES;

step3

(on master's command prompt)


C:\Program Files\MySQL\MySQL Server 5.0\bin>mysqldump.exe -h192.168.10.65
-ureplicant -pmy_pwd -P3306
--all-databases --master-data >dumpfilename.sql



step4
(on slave's my.ini file)
server-id=2

step5

(on slave's mysql console)


CHANGE MASTER TO
MASTER_HOST="192.168.10.65",
MASTER_USER="replicant",
MASTER_PASSWORD="my_pwd",
MASTER_PORT=3306,
MASTER_LOG_FILE="mysql-bin.0000001",
MASTER_LOG_POS=0,
MASTER_CONNECT_RETRY=10

show slae status;
START SLAVE;
show slave status;

step6



(on slave's command prompt)

C:\Program Files\MySQL\MySQL Server 5.1\bin>mysqlimport -h192.168.10.65 -ureplicant -pmy_pwd
-P3306 >--all-databases --master-data >dumpfilename.sql;

*******************************************************************
my doubts:-
---------

1.
is it correct all steps?
2.
plz edit this document it anything wrong in this.
3.
how i create dump file in master?
4.
my master and slave are 2 different systems, how i import master's dumpfile from slave?

Options: ReplyQuote


Subject
Views
Written By
Posted
31092
March 29, 2005 07:27AM
14753
March 30, 2005 12:32AM
92731
March 30, 2005 06:38AM
30686
April 01, 2005 01:35AM
20185
April 01, 2005 03:21AM
16821
April 01, 2005 09:31PM
26214
April 18, 2006 12:07AM
19437
April 21, 2006 07:18PM
13667
June 14, 2006 03:04PM
11827
January 08, 2008 03:50PM
11435
January 08, 2008 04:47PM
11821
March 08, 2008 07:40PM
10558
March 09, 2008 07:59AM
11124
December 15, 2008 11:43AM
plzzzzzzz help me (how 2 do replication using mysql and windows)
6475
December 18, 2008 01:58AM


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.