[clue] MySQL Question

Warren W. Weiss warren at guano.org
Fri Nov 30 16:29:48 MST 2012


I've inherited a complex LAMP application.

A script runs nightly to dump the databases for a backup.  After the
dumps and before emailing the results, the script issues the following
commands on each database:

 mysql -u <user> -p<password> -h <DB Server> -e "reset master"
 mysql -u <user> -p<password> -h <DB Server> -e "flush logs"

What does "reset master" and "flush logs" do to a running database?  At
no time does the script stop and restart the instances, BTW.

TIA

--

</W>


More information about the clue mailing list