----- Original Message ----- From: "Dyego Souza do Carmo" <[EMAIL PROTECTED]> To: "Heikki Tuuri" <[EMAIL PROTECTED]> Sent: Thursday, January 23, 2003 12:31 PM Subject: Re[2]: Limitations of InnoDB about REPLICATION
> Dobrư den, > quinta-feira, 23 de janeiro de 2003, 08:28:43, napsal jste: > > HT> Dyego, ... > >> * THE LOAD TABLE FROM MASTER DOES NOT WORK ON INNODB TABLES > > HT> true. > > >> * THE TABLES ARE LOADED AUTOMATICALLY ON SET REPLICATION > > HT> Sorry, I do not understand? Do you mean that when you set up a new slave, > HT> you make a cold or a hot backup of the InnoDB tablespace and log files and > HT> .frm files, and use them to set up the new slave? That is the normal > HT> procedure to set up a new slave. The command LOAD TABLE FROM MASTER is > HT> awkward anyway if you have lots of tables. ... > The Command LOAD TABLE FROM MASTER work on slave with InnoDB tables ? > ( >= 4.0.9 ) sorry, no. The workarounds are: A. 1) convert the table to MyISAM in the master, 2) use then LOAD TABLE FROM MASTER in the slave, 3) convert back to InnoDB in the master. B. Or simply dump the table in the master and import the dumpfile to the slave. > Tanks ;) > > sql,query > > ------------------------------------------------------------------------- > ++ Dyego Souza do Carmo ++ Dep. Desenvolvimento You are welcome :), Heikki --------------------------------------------------------------------- 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
