Re: Replication with INNODB

2002-08-15 Thread Heikki Tuuri
Hi! Replication between MyISAM and and InnoDB tables should work, and actually many people use it. The only essential limitation in replication with InnoDB is that LOAD TABLE FROM MASTER does not work. The workaround is to ALTER the table to MyISAM, do LOAD TABLE..., and ALTER back. Best

Re: Replication with INNODB

2002-08-15 Thread Serge Paquin
Hello, I'm not sure I am still using 3.23. Serge. - Original Message - From: "Eric Frazier" <[EMAIL PROTECTED]> To: "Serge Paquin" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, August 15, 2002 10:05 PM Subject: Re: Replicatio

Re: Replication with INNODB

2002-08-15 Thread Eric Frazier
Hi, I am confused. I just tried replication with 4.0.2 on master and slave, and it appeared to work with the InnoDB tables on the Master.. What is the expected issue, or error that happens that causes the manual to say that Replication doesn't work yet with InnoDB at least not when you use LOAD

Replication with INNODB

2002-08-15 Thread Serge Paquin
Hello, I am trying to setup replication to be used basicaly as a hot backup. My production database uses INNODB tables. I would like my Replication database to just my MyISAM since I do not need transactions on that one. Just a copy of the data. I followed the process to create the slave b