Re: myisamchk errors
Hello. Have you stopped MySQL server before executing myisamchk? sirisha gnvg <[EMAIL PROTECTED]> wrote: > [-- text/plain, encoding 8bit, charset: iso-8859-1, 21 lines --] > > hello everybody, > > I used myisamchk /path/to/datadir/mysql/*.* to find memory already in > use and free memory available for all tables in 'mysql' database.where mysql > in above path refers to mysql database. > > I got two types of errors for all tables in that directory. > > They are > myisamchk:error: -1 when opening myisam_table 'abcd.MYD' > > myisamchk1 error:'abcd.frm' doen't have a correct index definition.You need > to create it before u can do a repair.I am using Red hat linux mysql version. > > Please give more information about these errors and the ways to rectify them. > > Thank you, > > yours, > sirisha. > > > > Yahoo! India Matrimony: Find your life partneronline. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
myisamchk errors
hello everybody, I used myisamchk /path/to/datadir/mysql/*.* to find memory already in use and free memory available for all tables in 'mysql' database.where mysql in above path refers to mysql database. I got two types of errors for all tables in that directory. They are myisamchk:error: -1 when opening myisam_table 'abcd.MYD' myisamchk1 error:'abcd.frm' doen't have a correct index definition.You need to create it before u can do a repair.I am using Red hat linux mysql version. Please give more information about these errors and the ways to rectify them. Thank you, yours, sirisha. Yahoo! India Matrimony: Find your life partneronline.
Re: myisamchk errors
The reason we run the check scripts is because in the past we had all sorts of trouble not with the daemon crashing, but with clients (who have no technical skills) using Access & ODBC to update tables, and somehow corrupting them. This way we catch the problems before the client does. Thanks though. I'll give it a go. Don On Wednesday 07 March 2001 17:16, Dan Nelson wrote: > In the last episode (Mar 07), Don Bowyer said: > > I recently upgraded our database from 3.22.32 to 3.23.32 We run a > > ISAM check every night, to check for db problems. Ever since I did > > the change, I get a email from the cron daemon like this: > > > > /usr/bin/myisamchk: MyISAM file /var/lib/mysql/cayn21/customers.MYI > > /usr/bin/myisamchk: warning: 1 clients is using or hasn't closed the > > table properly > > The database is shut down when you do this, right? You should really > never have to run myisamchk unless your server crashes a lot. If you > don't want to shut down mysql to check tables, use the "CHECK TABLE" > mysql command. -- Insidewire Services Inc. www.insidewire.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
Re: myisamchk errors
In the last episode (Mar 07), Don Bowyer said: > I recently upgraded our database from 3.22.32 to 3.23.32 We run a > ISAM check every night, to check for db problems. Ever since I did > the change, I get a email from the cron daemon like this: > > /usr/bin/myisamchk: MyISAM file /var/lib/mysql/cayn21/customers.MYI > /usr/bin/myisamchk: warning: 1 clients is using or hasn't closed the table properly The database is shut down when you do this, right? You should really never have to run myisamchk unless your server crashes a lot. If you don't want to shut down mysql to check tables, use the "CHECK TABLE" mysql command. -- Dan Nelson [EMAIL PROTECTED] - 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: myisamchk errors
Don Bowyer wrote: > > I recently upgraded our database from 3.22.32 to 3.23.32 > We run a ISAM check every night, to check for db problems. Ever since I did > the change, I get a email from the cron daemon like this: > > /usr/bin/myisamchk: MyISAM file /var/lib/mysql/cayn21/customers.MYI > /usr/bin/myisamchk: warning: 1 clients is using or hasn't closed the table > properly > > Is there something I am not doing right? Is this output happening because > these are MyISAM tables rather than ISAM like we used to use, and the > myisamchk program has to run with the database shut down? > > Alternatively, is this something to do with the way the Perl modules are > working? We use the Mysql modules? > > Any thoughts? I would like to try to remove the cause of these warnings. > > Thanks > Don > > - > 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 Hi, If you want to run myisamchk while mysqld is running, you should run mysqld WITHOUT --skip-locking option. Check the manual for details: http://www.mysql.com/doc/C/r/Crash_recovery.html Regards -- Joseph Bueno NetClub/Trader.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
myisamchk errors
I recently upgraded our database from 3.22.32 to 3.23.32 We run a ISAM check every night, to check for db problems. Ever since I did the change, I get a email from the cron daemon like this: /usr/bin/myisamchk: MyISAM file /var/lib/mysql/cayn21/customers.MYI /usr/bin/myisamchk: warning: 1 clients is using or hasn't closed the table properly Is there something I am not doing right? Is this output happening because these are MyISAM tables rather than ISAM like we used to use, and the myisamchk program has to run with the database shut down? Alternatively, is this something to do with the way the Perl modules are working? We use the Mysql modules? Any thoughts? I would like to try to remove the cause of these warnings. Thanks Don - 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