Re: Replication with HEAP tables & slave insert error

2004-02-03 Thread Egor Egorov
"Vinod Panicker" <[EMAIL PROTECTED]> wrote: > > "Vinod Panicker" <[EMAIL PROTECTED]> wrote: > >> Also, the slave stopped due to an error of a duplicate key! Why >> should it have a problem with inserting data that went through fine on the > master? > > Could you describe your problem more deta

RE: Replication with HEAP tables & slave insert error

2004-02-02 Thread Vinod Panicker
Hi Egor, Thanks for the reply. My responses below - "Vinod Panicker" <[EMAIL PROTECTED]> wrote: > Hi, > > Had a query regarding replication with HEAP tables. It seems like I > cannot use LOAD DATA FROM MASTER to update the stopped slave with data > from the master since it apparently work

Re: Replication with HEAP tables & slave insert error

2004-02-02 Thread Egor Egorov
"Vinod Panicker" <[EMAIL PROTECTED]> wrote: > Hi, > > Had a query regarding replication with HEAP tables. It seems like I cannot > use LOAD DATA FROM MASTER to update the stopped slave with data from the > master since it apparently works only for MyISAM tables. Any other way of > updating the s

Replication with HEAP tables & slave insert error

2004-02-01 Thread Vinod Panicker
Hi, Had a query regarding replication with HEAP tables. It seems like I cannot use LOAD DATA FROM MASTER to update the stopped slave with data from the master since it apparently works only for MyISAM tables. Any other way of updating the slave with a snapshot of the data? Since a HEAP table do