Re: 3.23 "Online Table Maintenance"?
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
Re: 3.23 "Online Table Maintenance"?
Look up "repair table" in the on-line manual. regards, P On Fri, 23 Feb 2001, Hardy Merrill wrote: > 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. > > - 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
Re: 3.23 "Online Table Maintenance"?
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
3.23 "Online Table Maintenance"?
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 - 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
