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