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 pe
l of write access through "admin" accounts if need be.
>>
>> - Original Message -
>> From: "Jehan PROCACCIA" <[EMAIL PROTECTED]>
>> To:
>> Sent: Friday, June 30, 2006 6:28 AM
>> Subject: howto set mysql to readonly
>>
>>
nts so they have select only privileges?
Then you still of write access through "admin" accounts if need be.
- Original Message -
From: "Jehan PROCACCIA" <[EMAIL PROTECTED]>
To:
Sent: Friday, June 30, 2006 6:28 AM
Subject: howto set mysql to readonly
> Hel
Message -
From: "Jehan PROCACCIA" <[EMAIL PROTECTED]>
To:
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
IL PROTECTED]>
To:
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 to do is whil
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
