Clyde Lewis - DBA a écrit :
The idea here is to perform this change without restarting the server.
Is that possible? I know that by updating the config file, then
restarting will allow the database to be in read-only mode, but need to
know if it is possible without restarting.
Thanks,
CL
At 11:46 AM 8/3/2007, Clyde Lewis - DBA wrote:
Is this possible with MYSQL using the innodb engine? If so, what is
the command/process to make this happen.
Thanks in advance,
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Clyde Lewis
Database Administrator
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Clyde Lewis
Database Administrator
This question was old, but I saw that no "good" response was giving so I
decided it was worth answering.
You can set the read-only property at runtime, from what I know it work
with all storage engine. This prevent all user from modifying the data
except the user that have "super" privilege and the replication thread.
Depending of your exact version to set it it's something in the line of
"set GLOBAL read_only=true;"
You can also remove it in case you need it.
Regards,
--
Mathieu Bruneau
aka ROunofF
===
GPG keys available @ http://rounoff.darktech.org
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
