> to flush tables, you're right :
>
> flush table TOTO <= flushes only toto
> flush table TOTO,TITI<= flushes only toto and titi
> flush tables <= flushes ALL
OK, that's good news.
> Have'nt you thought to a master-slave replication and
> 1) Reading TFM (http://dev.mysql.com/doc/mysql/en/flush.html) it appears
> that I do not have to 'FLUSH TABLES WITH READ LOCK' for each individual
> database. This statement flushes and locks all simultaneously. Am I
> correct?
HI,
to flush tables, you're right :
flush table TOTO