Re: Adding a second slave and Load Data from master questions

2006-05-05 Thread sheeri kritzer
LOAD DATA FROM MASTER only works for MyISAM tables. Is tracking.session an InnoDB table? -Sheeri On 5/4/06, Hunter Peress [EMAIL PROTECTED] wrote: Hi. im trying to add a second slave using load data from master ,and it seems to me that when i run this command on the new slave that its simply

Adding a second slave and Load Data from master questions

2006-05-04 Thread Hunter Peress
Hi. im trying to add a second slave using load data from master ,and it seems to me that when i run this command on the new slave that its simply picking up from where the first slave is replicating from. Does this make sense? Also interesting is that when both the IO and SQL threads are No on