Linux Conquering Cloud
Learn .. Conquer .. Share
Pages
(Move to ...)
Home
▼
Thursday, April 10, 2014
Setting the Mysql into a ReadOnly mode..
whole database to read only mode by this commands:
In the MySQL Prompt
FLUSH TABLES WITH READ LOCK;
SET GLOBAL read_only = 1;
and back to normal mode with:
SET GLOBAL read_only = 0;
UNLOCK TABLES;
No comments:
Post a Comment
‹
›
Home
View web version
No comments:
Post a Comment