Make sure mysql owns all the directories and files in its database
directory.
If you have never seen host.ISM on your .22 server, then you never looked.
It sounds like you also ran mysql_install_db and overwrote your
privilege tables. That is why they are now .MYD and .MYI.
You also probably ran it without the --user=mysql option, so root owns
the directories and files.
Skot wrote:
> Werner Stuerenburg wrote:
>
>>> I just updated MySQL 2.22 to 2.23 and when I went to restart the server,
>>> I got this error message in the /var/lib/mysql/err.log file:
>>> 010627 11:19:22 /usr/sbin/mysqld: Can't open file: 'host.ISM'. (errno:
>>> -1)
>>> mysqld ended on Wed Jun 27 11:19:22 PDT 2001
>>
>> See http://www.mysql.com/doc/R/e/Repair.html
>
>
> I can't use any SQL commands, I can't even connect to mysql database
> without a running server, and the server won't start because it's
> looking for 'host.ISM' file, which I have never seen on my server. I
> only have host.MYD and host.MYI files there, no .ISM anythings.
>
> Thanks.
>
> ---------------------------------------------------------------------
> 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
--
Gerald L. Clark
[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
