Dyego, ----- Original Message ----- From: "Dyego Souza do Carmo" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, January 23, 2003 12:13 PM Subject: Limitations of InnoDB about REPLICATION
> Hello guy ! > > The limitations about InnoDB on replication is present in >= 4.0.9 release > ? > > * THE LOAD TABLE FROM MASTER DOES NOT WORK ON INNODB TABLES true. > * THE TABLES ARE LOADED AUTOMATICALLY ON SET REPLICATION Sorry, I do not understand? Do you mean that when you set up a new slave, you make a cold or a hot backup of the InnoDB tablespace and log files and .frm files, and use them to set up the new slave? That is the normal procedure to set up a new slave. The command LOAD TABLE FROM MASTER is awkward anyway if you have lots of tables. > is true this limitations on >= 4.0.9 ? > > > sql,query > > ------------------------------------------------------------------------- > ++ Dyego Souza do Carmo ++ Dep. Desenvolvimento Regards, Heikki > ------------------------------------------------------------------------- > E S C R I B A I N F O R M A T I C A > ------------------------------------------------------------------------- > The only stupid question is the unasked one (somewhere in Linux's HowTo) > Linux registred user : #230601 > -- > $ look into "my eyes" Phone : +55 041 296-2311 r.112 > look: cannot open my eyes Fax : +55 041 296-6640 > ------------------------------------------------------------------------- > Reply: [EMAIL PROTECTED] > > --------------------------------------------------------------------- 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