Swany, I do indeed have a host.frm file, and the timestamp is from 2000. Unfortunately, I've had to start up 4.1.0 again and leave it up as folks here have to work on the db. Since they won't be working tomorrow, I'll try to remove the host.frm (also perhaps the host.ISD and host.ISM?) file tomorrow and let you know if it works out. Somehow I think it will; your suggestion feels correct to me. Thanks much.
jf On Fri, 9 Jul 2004, Justin Swanhart wrote: > 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] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
