This will be not that easy as there is a large array of different
users accessing the DBA at different time during the day/night.
CL
t 11:58 AM 8/3/2007, Edward Kay wrote:
> -----Original Message-----
> From: Clyde Lewis - DBA [mailto:[EMAIL PROTECTED]
> Sent: 03 August 2007 16:55
> To: MySQL List
> Subject: Re: MySQL in read-only mode
>
>
> 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.
> >
Can't you just remove the INSERT/UPDATE/DELETE priviledges from the user(s)
concerned?
Edward
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Clyde Lewis
Database Administrator
General Parts International Inc. / CARQUEST
P.O. Box 26006
Raleigh, NC 27611
Office: (919) 227-5100
Mobile: (757) 952-7331
Fax: (919) 573-2280
E-mail: [EMAIL PROTECTED]
