Adding a New Slave to a Live Replication Master

[Gabriel Ricard]

I've got two database servers in production, one of which is a master 
for a handful of tables and the other is a slave for these few tables. 
I want to add an additional slave server without taking down the master 
to create a snapshot. Is it possible to just setup the replication for 
the slave and then issue a LOAD DATA FROM MASTER command to pull in any 
existing data?

Is there a recommended procedure for this?

- Gabriel

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]