Re: Extended insert syntax and replication

2005-06-23 Thread mfatene
t: Thursday, June 23, 2005 2:51 PM > Subject: Re: Extended insert syntax and replication > > > > Hi, > > this is a perl script converter for inserts to simple form. if you work > > from a > > mysqldump, you can try it to see if the converted inserts do not genrate > &g

Re: Extended insert syntax and replication

2005-06-23 Thread Jeremiah Gowdy
; To: "Jeremiah Gowdy" <[EMAIL PROTECTED]> Cc: Sent: Thursday, June 23, 2005 2:51 PM Subject: Re: Extended insert syntax and replication Hi, this is a perl script converter for inserts to simple form. if you work from a mysqldump, you can try it to see if the converted insert

Re: Extended insert syntax and replication

2005-06-23 Thread mfatene
Hi, this is a perl script converter for inserts to simple form. if you work from a mysqldump, you can try it to see if the converted inserts do not genrate errors : http://platon.sk/cvs/cvs.php/scripts/perl/mysql/mysqldump-convert.pl Mathias Selon Jeremiah Gowdy <[EMAIL PROTECTED]>: > I have two

Extended insert syntax and replication

2005-06-23 Thread Jeremiah Gowdy
I have two servers doing replication for logs. When I do extended insert syntax on the master to combine multiple log entries, the slave complains about duplicate primary key numbers, even though my inserts don't set the primary key and the primary key is auto_increment. So any time I use ext