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 regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB ----- Original Message ----- From: ""Serge Paquin"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Friday, August 16, 2002 8:15 AM Subject: Re: Replication with INNODB > 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: Replication with INNODB > > > > 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 > DATA > > FROM MASTER? That is how I updated my slave, and as I said it seemed to > work > > fine. > > > > I need to Replicate InnoDB tables, but I am worried that the manual says > > LOAD DATA FROM MASTER won't work. So is Replication ok with InnoDB, once > you > > get the servers synced? > > > > > > Thanks, > > > > Eric > > > > At 12:48 AM 8/16/02 -0400, Serge Paquin wrote: > > >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 but > > >since I am using INNODB tables tar'ing up the mysql directory and moving > it > > >to the slave does not work. > > > > > > What must I do? Would I be best to export everything to a file using > > >mysqldump then reimport it? > > > > > >Thanks, > > >Serge. > > > > > > > > > > > >--------------------------------------------------------------------- > > >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 > > > > > > > http://www.kwinternet.com/eric > > (250) 655 - 9513 (PST Time Zone) > > > > "Inquiry is fatal to certainty." -- Will Durant > > > > > > > > > > > --------------------------------------------------------------------- > 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 > --------------------------------------------------------------------- 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