Hi Jehan,
OK so it seems to be a bad idea ... I was expecting that I missed a
magic command like set readonly on all databases ...
I think you did:
SET GLOBAL read_only=1;
This will keep all non-SUPER and non-replication users from writing to
the database.
Regards,
Jeremy
--
high
: howto set mysql to readonly
Hello
I need to move my databases from on server to an other.
As lots of data are in production I cannot just stop mysql for 1/2
an hour and reopen it on the new server.
What I expect to do is while backuping and restoring to the new
server, I wish to set
Hello
I need to move my databases from on server to an other.
As lots of data are in production I cannot just stop mysql for 1/2 an
hour and reopen it on the new server.
What I expect to do is while backuping and restoring to the new server,
I wish to set the original server in read only mode
: Friday, June 30, 2006 6:28 AM
Subject: howto set mysql to readonly
Hello
I need to move my databases from on server to an other.
As lots of data are in production I cannot just stop mysql for 1/2 an hour and
reopen it on the new server.
What I expect to do is while backuping and restoring
PROTECTED]
To: mysql@lists.mysql.com
Sent: Friday, June 30, 2006 6:28 AM
Subject: howto set mysql to readonly
Hello
I need to move my databases from on server to an other.
As lots of data are in production I cannot just stop mysql for 1/2 an hour
and reopen it on the new server.
What I expect
still of write access through admin accounts if need be.
- Original Message -
From: Jehan PROCACCIA [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Friday, June 30, 2006 6:28 AM
Subject: howto set mysql to readonly
Hello
I need to move my databases from on server to an other.
As lots