RE: Replication Problems/Questions
-Ursprüngliche Nachricht- Von: Guddack Thorsten ICM MP SCM GO 21 Gesendet: Freitag, 31. Januar 2003 20:51 An: 'Gelu Gogancea'; '[EMAIL PROTECTED]' Betreff: Re: Replication Problems/Questions Hi, thank you for you're response, but in the mysql-manual > version 4.0 they said that the Problems with load data, load data infile have been solved. So I'm a little bit confused about that. Best regards -Ursprüngliche Nachricht- Von: Gelu Gogancea [mailto:[EMAIL PROTECTED]] Gesendet: Donnerstag, 30. Januar 2003 20:48 An: Guddack Thorsten ICM MP SCM GO 21; [EMAIL PROTECTED] Betreff: Re: Replication Problems/Questions Hi, - Original Message - From: "Guddack Thorsten ICM MP SCM GO 21" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, January 30, 2003 3:44 PM Subject: Replication Problems/Questions > Hi List > > I'm using 2 WinNT-Servers, Sp6 with mysql 4.0.5. max-nt. > > I ve setup a replication between these two servers as discribed in the > manual and some small problems comes up. > > Maybe someone can give me some help. > > 1.) On the Master I create a user repl with the rights 'replication slave'. > On the slave I used a user with all possible rights. > Starting the replication with 'reset slave', 'change master to.' > and 'start slave', I get an error: > Show slave status says Slave_IO_running no and some entry in mysql.err. > > This Problem I could solve using a user in 'change master to ' that > has also admin rights. > What could cause the problem? > > 2.) The more important Problem: > If the replication is running, and I try to replicate a table where > data was inserted on the master with 'LOAD DATA INFILE...' or > 'LOAD DATA LOCAL INFILE' the server process on the slaves > crushes > The files on the master, for LOAD DATA.were still there. > Any Ideas? IMHO: ...this can happening because on the slave you don't have(...i guess) the file for LOAD DATA.By REPLICATION the slave trying to copy every "movement" of the master and not the data itself.This means that slave trying to execute "LOAD DATA INFILE "YOUR_PATH_TO_FILE ".and not copy the data from the master. > > > At Last one question: > - could anyone explain me the meaning of the fields from show slave status > ( I'm looking for a way to decide if the slave has replicated all the data > from the master ) > > Best regards Best Regards, Gelu > > [EMAIL PROTECTED] > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Replication Problems/Questions
Hi, - Original Message - From: "Guddack Thorsten ICM MP SCM GO 21" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, January 30, 2003 3:44 PM Subject: Replication Problems/Questions > Hi List > > I'm using 2 WinNT-Servers, Sp6 with mysql 4.0.5. max-nt. > > I ve setup a replication between these two servers as discribed in the > manual and some small problems comes up. > > Maybe someone can give me some help. > > 1.) On the Master I create a user repl with the rights 'replication slave'. > On the slave I used a user with all possible rights. > Starting the replication with 'reset slave', 'change master to.' > and 'start slave', I get an error: > Show slave status says Slave_IO_running no and some entry in mysql.err. > > This Problem I could solve using a user in 'change master to ' that > has also admin rights. > What could cause the problem? > > 2.) The more important Problem: > If the replication is running, and I try to replicate a table where > data was inserted on the master with 'LOAD DATA INFILE...' or > 'LOAD DATA LOCAL INFILE' the server process on the slaves > crushes > The files on the master, for LOAD DATA.were still there. > Any Ideas? IMHO: ...this can happening because on the slave you don't have(...i guess) the file for LOAD DATA.By REPLICATION the slave trying to copy every "movement" of the master and not the data itself.This means that slave trying to execute "LOAD DATA INFILE "YOUR_PATH_TO_FILE ".and not copy the data from the master. > > > At Last one question: > - could anyone explain me the meaning of the fields from show slave status > ( I'm looking for a way to decide if the slave has replicated all the data > from the master ) > > Best regards Best Regards, Gelu > > [EMAIL PROTECTED] > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Replication Problems/Questions
Hi List I'm using 2 WinNT-Servers, Sp6 with mysql 4.0.5. max-nt. I ve setup a replication between these two servers as discribed in the manual and some small problems comes up. Maybe someone can give me some help. 1.) On the Master I create a user repl with the rights 'replication slave'. On the slave I used a user with all possible rights. Starting the replication with 'reset slave', 'change master to.' and 'start slave', I get an error: Show slave status says Slave_IO_running no and some entry in mysql.err. This Problem I could solve using a user in 'change master to ' that has also admin rights. What could cause the problem? 2.) The more important Problem: If the replication is running, and I try to replicate a table where data was inserted on the master with 'LOAD DATA INFILE...' or 'LOAD DATA LOCAL INFILE' the server process on the slaves crushes The files on the master, for LOAD DATA.were still there. Any Ideas? At Last one question: - could anyone explain me the meaning of the fields from show slave status ( I'm looking for a way to decide if the slave has replicated all the data from the master ) Best regards [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: replication problems & questions
On Wed, Aug 15, 2001 at 10:55:53PM +0100, Neil Tompkins wrote: > Hello, > > I'm very new to MySQL and have posted a few mails regarding > replication in mySQL. I'm still having problems ! Can someone > please send me a step by step guide on how I can setup replication > between my ISPs MySQL database and one I wish to have and use > locally. I have already a database created on my ISP's server and > have created a table with data to test. If the instructions are not clear in the manual, please tell us how they can be improved. I made changes several months ago to improve them and will gladly do so again. But in order to do so, I need to know what's missing. At what step in the process it is unclear? I really would like the docs to be good. So we need to make an effort to fixing them if they're not--and helping you in the process. Thanks, Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.29: up 60 days, processed 572,260,825 queries (108/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Fw: replication problems & questions
Also regarding this matter, is it possible that I would on a local copy of the data on my own computer and it is then replicated automatically back to the ISP database ? Thanks Neil - Original Message - From: "Neil Tompkins" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, August 15, 2001 10:55 PM Subject: replication problems & questions > Hello, > > I'm very new to MySQL and have posted a few mails regarding replication in > mySQL. I'm still having problems ! Can someone please send me a step by > step guide on how I can setup replication between my ISPs MySQL database and > one I wish to have and use locally. I have already a database created on my > ISP's server and have created a table with data to test. > > My ISP runs RedHat and I have a username, password, database name and web > address to access my own database. I run Win2K Professional and have just > installed ver 1.2 (I think). I have not done anything else with the mySQL > on my own computer. > > Thanks for any useful information > > Neil > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
replication problems & questions
Hello, I'm very new to MySQL and have posted a few mails regarding replication in mySQL. I'm still having problems ! Can someone please send me a step by step guide on how I can setup replication between my ISPs MySQL database and one I wish to have and use locally. I have already a database created on my ISP's server and have created a table with data to test. My ISP runs RedHat and I have a username, password, database name and web address to access my own database. I run Win2K Professional and have just installed ver 1.2 (I think). I have not done anything else with the mySQL on my own computer. Thanks for any useful information Neil - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
