mysql people, (thanks all for their help before!)

So replication used to be working on our two 4.1.7-standard mysql database
servers, but someone messed it up. I'd like to restart the whole thing
from scratch.

Can I just do this:

on master:
mysql> RESET MASTER;

on slave:
mysql> STOP SLAVE;
mysql> LOAD DATA FROM MASTER;
mysql> START SLAVE;

will that delete all crud from the slave and get new copies of everything
from the master and then start replicating from then on?

ideas?

mrb



--------------------
BYU Unix Users Group 
http://uug.byu.edu/ 

The opinions expressed in this message are the responsibility of their
author.  They are not endorsed by BYU, the BYU CS Department or BYU-UUG. 
___________________________________________________________________
List Info: http://uug.byu.edu/cgi-bin/mailman/listinfo/uug-list

Reply via email to