Jan, Thursday, July 11, 2002, 1:25:11 PM, you wrote: JK> I am running MySQL 3.23.49 on Red Hat Linux 7.3 (installed from rpm included JK> in RH distribution). I am using ext3 file system. In my my.cfg is JK> "skip-locking".
JK> The system is Intel i810, Intel Celeron 433 MHz, 64 MB RAM. It is used only JK> as a database server which is accessable only from our web (apache, php). JK> I would like to do some operation automatickly and periodicly (with a JK> crond): JK> - check all databases / tables JK> - optimize all databases / tables JK> According to documentation JK> (http://www.mysql.com/doc/C/o/Command-line_options.html) I can't use JK> myisamchk, as long as mysqld is running. I have try somethong like this: JK> mysqld stop JK> myisamchk -swr /path/to/datadir/*/*.MYI JK> myisamchk -swm /path/to/datadir/*/*.MYI JK> mysql start JK> But I don't want to stop sql server every time. JK> Could you help me how to solve this issue? JK> Has somebody experience with MySQL on RedHat 7.3 with ext3? Take a look at CHECK TABLE: http://www.mysql.com/doc/C/H/CHECK_TABLE.html REPAIR TABLE: http://www.mysql.com/doc/R/E/REPAIR_TABLE.html You can also copy with mysqlhotcopy and check files in 'offline', but usage of CHECK and REPAIR TABLE is better. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.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
