Hello.
Putting this variables into configuration file works for me. Have you tried slave_net_timeout? Please send the output of SHOW SLAVE STATUS statement. [EMAIL PROTECTED] wrote: > Hallo > I have some problems loading data from Master. I am using the circular > replication procedure for example a->b->c->a. Since I ran out of disk in > my main server, my other servers started reporting duplicate entries > later. > > I thought going it from scratch to take the complete data from the > Master server to the slave machines. I used the following command. > "LOAD DATA FROM MASTER" after clearing the data folders in the slave > machines. > > But if shows me a timeout error. I then tired to increase the > net_read_timeout, net_write_timeout and the wait_timeout. But this > doesn't seem to work since I get the same error's. > > And the settings that I made has not been assigned permanently. When I > tried for "Show Variables". It shows me the default settings. > > How can I make my changes permanent until I move my Data from the Master > to the Slave machine. > > Thanks for your suggestions in advance, please. > > Kind Regards > Raj > > -- 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]
