RE: FLUSH TABLES /w READ LOCK vs. GLOBAL READ_ONLY in making backups

2005-06-20 Thread Martijn van den Burg
> 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

Re: FLUSH TABLES /w READ LOCK vs. GLOBAL READ_ONLY in making backups

2005-06-20 Thread mfatene
> 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