Re: How to fix not cleanly closed mysql?

["Horacio Goetendia" <horacio.goetendia@gmail.com>]

Hi

I know two methods to repair

If you have MyISAM tables you can use: 

To check:
myisamchk 
<the path of the myi file of your table>

To Repair:
myisamchk --recover  
<the path of the myi file of your table>
or with --safe-recover instead --recover

Also
There are some SQL sentences for MyISAM and InnoDB tables that can help you, these are:

 CHECK TABLE_NAME
 REPAIR TABLE_NAME


Atte

Horacio Goetendia B.

2006/9/6, Jeff Zhang < idealbsd@gmail.com>:

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

After an abnormally shutdow, /etc/init.d/mysql start givs the message:
Stopping MySQL database server: mysqld.
Starting MySQL database server: mysqld.
Checking for corrupt, not cleanly closed and upgrade needing tables..

how to fix it? Need I rebuild all the databases?
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (GNU/Linux)

iD8DBQFE/5TFexs2apGZoVgRAizOAJ4ofKhxiSCW1HGTdV/ABGJM8M6HbQCgyHoT
hiNRmOAHq+0yTKuQlLvxbFM=
=z43u
-----END PGP SIGNATURE-----


--
To UNSUBSCRIBE, email to debian-user-REQUEST@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org

-- 
         Atentamente

Horacio Goetendia Bonilla