RE: Load data question in cross database replication
Thanks ! -Original Message- From: Gleb Paharenko [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 08, 2004 3:18 AM To: [EMAIL PROTECTED] Subject: Re: Load data question in cross database replication Hello. It seems to be a bug: http://bugs.mysql.com/bug.php?id=6353 "Sanjeev Sagar" <[EMAIL PROTECTED]> wrote: > Hello Gleb, > > My question was related to LOAD DATA INFILE, not LOAD DATA FROM MASTER.=20 > > LOAD DATA INFILE work those slaves which are not using > --replicate-rewrite-db. It do not work for those which are using this. > > Thanks for you reply. > > -Original Message- > From: Gleb Paharenko [mailto:[EMAIL PROTECTED] > Sent: Friday, December 03, 2004 4:14 AM > To: [EMAIL PROTECTED] > Subject: Re: Load data question in cross database replication > > Hello. > > --replicate-rewrite-db is not taken into account while executing LOAD > DATA > FROM MASTER. See: > http://dev.mysql.com/doc/mysql/en/LOAD_DATA_FROM_MASTER.html > > > > "Sanjeev Sagar" <[EMAIL PROTECTED]> wrote: > > > --=20 > For technical support contracts, goto > https://order.mysql.com/?ref=3Densita > This email is sponsored by Ensita.NET http://www.ensita.net/ > __ ___ ___ __ > / |/ /_ __/ __/ __ \/ /Gleb Paharenko > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET > <___/ www.mysql.com > > > > > --=20 > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Load data question in cross database replication
Hello. It seems to be a bug: http://bugs.mysql.com/bug.php?id=6353 "Sanjeev Sagar" <[EMAIL PROTECTED]> wrote: > Hello Gleb, > > My question was related to LOAD DATA INFILE, not LOAD DATA FROM MASTER.=20 > > LOAD DATA INFILE work those slaves which are not using > --replicate-rewrite-db. It do not work for those which are using this. > > Thanks for you reply. > > -Original Message- > From: Gleb Paharenko [mailto:[EMAIL PROTECTED] > Sent: Friday, December 03, 2004 4:14 AM > To: [EMAIL PROTECTED] > Subject: Re: Load data question in cross database replication > > Hello. > > --replicate-rewrite-db is not taken into account while executing LOAD > DATA > FROM MASTER. See: > http://dev.mysql.com/doc/mysql/en/LOAD_DATA_FROM_MASTER.html > > > > "Sanjeev Sagar" <[EMAIL PROTECTED]> wrote: > > > --=20 > For technical support contracts, goto > https://order.mysql.com/?ref=3Densita > This email is sponsored by Ensita.NET http://www.ensita.net/ > __ ___ ___ __ > / |/ /_ __/ __/ __ \/ /Gleb Paharenko > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET > <___/ www.mysql.com > > > > > --=20 > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- 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]
RE: Load data question in cross database replication
Hello Gleb, My question was related to LOAD DATA INFILE, not LOAD DATA FROM MASTER. LOAD DATA INFILE work those slaves which are not using --replicate-rewrite-db. It do not work for those which are using this. Thanks for you reply. -Original Message- From: Gleb Paharenko [mailto:[EMAIL PROTECTED] Sent: Friday, December 03, 2004 4:14 AM To: [EMAIL PROTECTED] Subject: Re: Load data question in cross database replication Hello. --replicate-rewrite-db is not taken into account while executing LOAD DATA FROM MASTER. See: http://dev.mysql.com/doc/mysql/en/LOAD_DATA_FROM_MASTER.html "Sanjeev Sagar" <[EMAIL PROTECTED]> wrote: -- 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Load data question in cross database replication
Hello. --replicate-rewrite-db is not taken into account while executing LOAD DATA FROM MASTER. See: http://dev.mysql.com/doc/mysql/en/LOAD_DATA_FROM_MASTER.html "Sanjeev Sagar" <[EMAIL PROTECTED]> wrote: -- 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]
Load data question in cross database replication
Hello Everyone, I have a question on using LOAD DATA command in cross database replication setup. MySQL version is 4.0.21 I have replication farm where few slaves have been set up as cross database replication slave by using (replicate-rewrite-db). When Load data command get executed on central master, it get replicated fine in those slave which are not cross database but it abort with error saying that database do not exist in those slave, which are configured with replicate-rewrite-db. This is my understanding that it has hard coded database name in .ini file, which it generate for load data command. Is there any way to make it happen that load data should get executed irrespective of replicate-rewrite-db configuration. Any parameter or any work around? Regards,