List:General Discussion« Previous MessageNext Message »
From:jbfink Date:July 9 2004 11:18pm
Subject:Re: problem upgrading from 4.1.0-alpha to 4.1.3-beta on Solaris 9
View as plain text  
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 <jbfink@stripped> 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/mysql?unsub=1
> >
> >
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
Thread
problem upgrading from 4.1.0-alpha to 4.1.3-beta on Solaris 9John Fink9 Jul
  • Re: problem upgrading from 4.1.0-alpha to 4.1.3-beta on Solaris 9Justin Swanhart10 Jul
    • Re: problem upgrading from 4.1.0-alpha to 4.1.3-beta on Solaris 9jbfink10 Jul
RE: problem upgrading from 4.1.0-alpha to 4.1.3-beta on Solaris 9Victor Pendleton9 Jul
  • RE: problem upgrading from 4.1.0-alpha to 4.1.3-beta on Solaris 9jbfink9 Jul
RE: problem upgrading from 4.1.0-alpha to 4.1.3-beta on Solaris 9Victor Pendleton9 Jul
  • RE: problem upgrading from 4.1.0-alpha to 4.1.3-beta on Solaris 9jbfink9 Jul
RE: problem upgrading from 4.1.0-alpha to 4.1.3-beta on Solaris 9Victor Pendleton9 Jul
  • RE: problem upgrading from 4.1.0-alpha to 4.1.3-beta on Solaris 9jbfink9 Jul
  • RE: problem upgrading from 4.1.0-alpha to 4.1.3-beta on Solaris 9jbfink9 Jul