 | | | howto set mysql to readonly | howto set mysql to readonly 2006-06-30 - By Brent Baisley
Back
Instead of "locking" the table, why not just change the privileges for the
specific accounts so they have select only privileges?
Then you still of write access through "admin" accounts if need be.
-- -- Original Message -- --
From: "Jehan PROCACCIA" <Jehan.Procaccia@(protected)>
To: <mysql@(protected)>
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 while backuping and restoring to the new server, I
wish to set the original server in "read only" mode so
> that nobody can write in the databases while transfering to the new one.
> I've seen the LOCK table and flush commands, but I'am not sure if this is the
right method, and how to use them.
> Lock table just locks tables as it's name implies and not a whole database ?
is there a kind of "lock all databases" ?
>
> thanks.
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=brenttech@(protected)
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=mysql@(protected)
|
|
|