wtech Posted January 23, 2006 Share Posted January 23, 2006 HiAm usingWindows-2000Apache-2.0.52Mysql-4.0.20PHP-4.3.8Versions in two servers. I would like to synchronize the my local database to the remote database server.for that We need to add some lines to the my.cnf file. /mysql/etc/my.cnf(path). [b]Master[/b]1) I created one user for replication with file permissions. like GRANT FILE ON *.* TO repl@"%" IDENTIFIED BY '<password>';2) Added these lines to my.cnf file of serverlog-binserver-id=1[b]Slave[/b]1)master-host=myhostmaster-user=myusermaster-password=****master-port=3306server-id=2After restarting the both mysql servers actually replication should start.But replication is not wokring. I have checked the log files on both the systems. No errorl messages r thr. I could not understand wts the problem here.Can anybody please suggest me...thanksRegardsShashiKumar Bandari Quote Link to comment Share on other sites More sharing options...
fenway Posted January 24, 2006 Share Posted January 24, 2006 Not sure why you chose the FILE permission -- you need the REPLICATION permission. I suggest you re-read [a href=\"http://dev.mysql.com/doc/refman/5.0/en/replication-howto.html\" target=\"_blank\"]this tutorial[/a] on getting replication up and running.Hope that helps. Quote Link to comment Share on other sites More sharing options...
wtech Posted January 25, 2006 Author Share Posted January 25, 2006 [!--quoteo(post=339508:date=Jan 24 2006, 02:15 PM:name=fenway)--][div class=\'quotetop\']QUOTE(fenway @ Jan 24 2006, 02:15 PM) [snapback]339508[/snapback][/div][div class=\'quotemain\'][!--quotec--]Not sure why you chose the FILE permission -- you need the REPLICATION permission. I suggest you re-read [a href=\"http://dev.mysql.com/doc/refman/5.0/en/replication-howto.html\" target=\"_blank\"]this tutorial[/a] on getting replication up and running.Hope that helps.[/quote]HiThanks for ur reply.Replication is working fine in both the servers.If there is any problem in one server. replication will stop.logging following error into log fileresumed in log 'wtjobser-bin.003' at position 16380how can i replicate the data from this position.Shashi Kumar Quote Link to comment Share on other sites More sharing options...
fenway Posted January 25, 2006 Share Posted January 25, 2006 Sorry -- my experience with replication is rather limited; if it's not in the man pages, I'm not sure. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.