MySQL: LOAD DATA FROM MASTER: too eager

how do I make it LOAD DATA only on demand?

[heisters]

I setup replication between my production and development servers so that all I need to do is LOAD DATA FROM MASTER on the production server to load all the changes made on development to the production environment. The problem is that it does this automatically, so that both sites may as well be connected the same database--defeating the purpose of having a development server for previewing changes. Is there any way I can make the slave database load data only on demand, eg. when I log in and type LOAD DATA FROM MASTER?

TIA.

[heisters]

Well, I found the answer elsewheres. A simple <code>STOP SLAVE;</code> on the development server makes sure it stops downloading changes. Then <code>START SLAVE;</code> to download the changes, followed by another <code>STOP SLAVE;</code> to turn it back off. Not perfect, but definitely does the trick.