Hello.
Why are you afraid of shutting down the server for a while? Is it so critical? If yes, send more detailed description of your situation. Replication shouldn't break. From: http://dev.mysql.com/doc/refman/5.0/en/replication-features.html "It is safe to shut down a master server and restart it later." Tedy Aulia wrote: > Hi Gleb, > > Thanks for your reply. > > I am using MySQL 3.23.33. > > The ones that I will need to add in my.cnf are the syncronisation > parameters as follow: > > binlog-do-db=XYZ > replicate-do-db=XYZ > replicate-ignore-table=XYZ.table1 > replicate-ignore-table=XYZ.table2 > replicate-ignore-table=XYZ.table3 > > > Database XYZ was in synch for the past 12 months, I have found database > is not in synch anymore as the parameters I mentioned above are missing > in my.cnf. I want to put back those parameters but I can't afford to > restart the server as MySQL server is also used by other database which > is currently in synch and runs happily. > > > > > Cheers, > TA > > > Hello. > > You can change some variables without restarting the server. See: > http://dev.mysql.com/doc/refman/5.0/en/dynamic-system-variables.html > > Tedy Aulia wrote: > >> Hi All, >> >> I will need to change my.cnf in master machine, but I can't afford to >> restart MySQL server as the server has been used for heavy traffic >> databases. >> Can anyone tell me how to do it? >> >> >> Cheers, >> >> *Tedy Aulia* >> >> > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
