Do you have a hosts.MYD, or a hosts.frm file? If you do, and there is no .MYI file, perhaps the older version is just ignoring the table and not making it available while the newer version errors out.
If those files exist, try removing them from the data directory (move them somewhere else) then starting the new version. Hope that helps, swany --- John Fink <[EMAIL PROTECTED]> wrote: > > Hey folks, > > My mysql-fu is minimal to the point of nonexistent, > so please forgive any > vagaries that come across: > > I've recently compiled 4.1.3 to replace 4.1.0 on a > machine here where I > work. The compile and install went fine (as far as > I can tell, anyway), > but when I try to start mysqld via the init script > it dies almost > immediately and I get the following lines in my .err > file: > > 040709 13:41:04 mysqld started > 040709 13:41:04 InnoDB: Started; log sequence > number 0 43912 > 040709 13:41:04 Fatal error: Can't open privilege > tables: Can't find file: 'host.MYI' (errno: 2) > 040709 13:41:04 mysqld ended > > Indeed, I have no host.MYI -- I thought perhaps it > might be a directory > permissions error or something, but it's not. 4.1.0 > trundled happily > along without a host.MYI file in my db's mysql > directory. Furthermore, > none of our other machines with MySQL (running > various 3.23 and 4.0) have > them either. > > Thanks for any help you can provide, > > jf. > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
