Re: FWD: Fw: Load data infile & replication - 3.23.56

Hi Guilhem,

Certainly. Here is the info:

MASTER
| list | CREATE TABLE `list` (
`listID` int(10) unsigned NOT NULL auto_increment,
`info` char(80) NOT NULL default '',
`domain` char(25) NOT NULL default '',
`sourceID` int(10) unsigned NOT NULL default '0',
`initDate` date NOT NULL default '0000-00-00',
`lastUpdate` timestamp(14) NOT NULL,
PRIMARY KEY (`listID`),
UNIQUE KEY `ix_l_info` (`info`),
KEY `ix_l_sourceID` (`sourceID`),
KEY `ix_l_domain` (`domain`)
) TYPE=MyISAM |

SLAVE
| list | CREATE TABLE `list` (
`listID` int(10) unsigned NOT NULL auto_increment,
`info` char(80) NOT NULL default '',
`domain` char(25) NOT NULL default '',
`sourceID` int(10) unsigned NOT NULL default '0',
`initDate` date NOT NULL default '0000-00-00',
`lastUpdate` timestamp(14) NOT NULL,
PRIMARY KEY (`listID`),
UNIQUE KEY `ix_l_info` (`info`),
KEY `ix_l_sourceID` (`sourceID`),
KEY `ix_l_domain` (`domain`)
) TYPE=MyISAM |

I edited out all the "---" output. Hopefully that's not significant.

Thanks,
--jeff

----- Original Message -----
From: "Guilhem Bichot"
To:
Cc:
Sent: Wednesday, March 26, 2003 1:16 PM
Subject: Re: FWD: Fw: Load data infile & replication - 3.23.56


> > > Replication doesn't seem to be replicating LOAD DATA INFILE correctly
in
> > > 3.23.56. Starting with a master and slave that were in sync, I
imported a
> > > file:
> > >
> > > ---------------------------
> > > MASTER
> > > mysql> select count(*) from list where sourceID=0;
> > > +----------+
> > > | count(*) |
> > > +----------+
> > > | 0 |
> > > +----------+
> > > 1 row in set (0.01 sec)
> > >
> > > mysql> load data infile '/home/stuff/new50001.txt'
> > > -> ignore
> > > -> into table list
> > > -> (info);
> > > Query OK, 189662 rows affected (1 min 18.43 sec)
> > > Records: 190660 Deleted: 0 Skipped: 998 Warnings: 0
> > >
> > > mysql> select count(*) from list where sourceID=0;
> > > +----------+
> > > | count(*) |
> > > +----------+
> > > | 189662 |
> > > +----------+
> > > 1 row in set (0.24 sec)
> > >
> > > SLAVE
> > > mysql> select count(*) from list where sourceID=0;
> > > +----------+
> > > | count(*) |
> > > +----------+
> > > | 190660 |
> > > +----------+
> > > 1 row in set (0.21 sec)
> > > ---------------------------
> > >
> > > Notice that the slave doesn't skip the records that the master does
>
> Hi,
>
> could you please send me the output of
> 'SHOW CREATE TABLE list;'
> run on the master and then on the slave.
> Please take the time to run this command on the two machines and send
> the two exact outputs.
> Thank you.
>
> Regards,
> Guilhem
>


--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org