What privileges does a MySQL user need to execute the CHECK TABLES
command on a table? Is it possible to GRANT very limited privileges
to a "chktbl" user so that all that user can do is "CHECK TABLES"?
But privs that will also allow that user to CHECK TABLES on tables
for *any* database in MySQL?
TIA.
--
Hardy Merrill
Mission Critical Linux, Inc.
http://www.missioncriticallinux.com
Sinisa Milivojevic [[EMAIL PROTECTED]] wrote:
> Hardy Merrill writes:
> > In the 3.23 news article, at the bottom it says this:
> >
> >
> >
> > Online Table Maintenance
> >
> > MySQL 3.23 now incorporates many of the table maintanence
> > features of the (previously only external) utilities
> > `(my)isamchk' directly into the MySQL server. The use of
> > these newly incorporated features can help to eliminate
> > system downtime, by allowing the Database Administrator to
> > repair damaged tables without shutting-down the MySQL server.
> >
> > Where can I find additional information about the table maintenance
> > features that have now been incorporated into the MySQL server?
> >
> > TIA.
> >
> > --
> > Hardy Merrill
> > Mission Critical Linux, Inc.
> > http://www.missioncriticallinux.com
> >
>
>
> Hi!
>
> In the manual. Look for CHECK TABLE and REPAIR TABLE commands.
>
>
> Regards,
>
> Sinisa
>
> ____ __ _____ _____ ___ == MySQL AB
> /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
> /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
> /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
> /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____
> ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^
> /*/ \*\ Developers Team
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php