Hi Guilhem,
Ok, good. At least this is a confirmed bug and not something on my end. :)
Hopefully, this will be considered a "critical" problem and fixed in 3.23,
since it makes all the replicate_* config commands useless. Was this
introduced recently? Can I downgrade to an older 3.23.x to get rid of this
problem?
Thanks,
--jeff
----- Original Message -----
From: "Guilhem Bichot" <[EMAIL PROTECTED]>
To: "Jeff Kilbride" <[EMAIL PROTECTED]>
Cc: "Heikki Tuuri" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, February 20, 2003 1:06 PM
Subject: Re: BUG? 3.23.55 not replicating LOAD DATA INFILE
> Hi
>
> Thanks for your bug report.
> In latest 3.23 and 4.0, the slave ignores any LOAD DATA INFILE
> as long as one of these options is set on the slave :
>
> replicate_do_table
> replicate_wild_do_table
> replicate_ignore_table
> replicate_wild_ignore_table
>
> regardless of the values of these options, which is a bug.
> This bug will be fixed in the next 4.0 release and probably in the next
> 3.23 release (in version 3.23 we currently fix only really critical bugs,
but
> as this bug is very simple to fix, it may get fixed too).
>
> If you're using a source distribution, here is a patch for 3.23,
> for the sql/slave.cc file :
>
> ===== slave.cc 1.133 vs edited =====
> *** /tmp/slave.cc-1.133-4477 Sat Jan 18 22:38:53 2003
> --- edited/slave.cc Thu Feb 20 22:01:17 2003
> ***************
> *** 1091,1096 ****
> --- 1091,1097 ----
> tables.db = thd->db;
> tables.alias= tables.real_name= (char*)lev->table_name;
> tables.lock_type = TL_WRITE;
> + tables.updating= 1;
> // the table will be opened in mysql_load
> if(table_rules_on && !tables_ok(thd, &tables))
> {
>
> Regards,
> Guilhem
>
---------------------------------------------------------------------
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
