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
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 PD
> 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/