List:General Discussion« Previous MessageNext Message »
From:sheeri kritzer Date:February 20 2006 4:44pm
Subject:Re: Problem starting
View as plain text  
Well, it says the "host.frm" file has the "wrong information".

Have you tried mysql_fix_permissions?  Or starting the server with
--skip-grant-tables?  It's possible the table itself is corrupt.

You could also try backing up the data you have and running
mysql_install_db to re-create the hosts file.

-Sheeri

On 2/12/06, DonM <munsonjr@stripped> wrote:
> On Saturday 11 February 2006 21:53, CasperLinux wrote:
> > I had a working database then had a power glitch shutdown the computer.
> > Afterwards I began receiving all sorts of errors.  I cleaned through most
> > of them but this one is stumping me.  I tried to uninstall and reinstall
> > mysql-server to no avail.  Anyone have any kind words?
> >
> I have now tried to restore from a backup and get the same results.  I really
> don't know how to get this working.  Tried the install_db script and it fails
> for essentially the same problems.  Anyone have a solution. I know this has
> to be easy that's why I can't figure it out.  Even a hint where to find
> proper documentation cause I can't get the answer off google.
>
> > arthur:/etc/X11# mysqld
> > 060211 21:50:22  InnoDB: Database was not shut down normally!
> > InnoDB: Starting crash recovery.
> > InnoDB: Reading tablespace information from the .ibd files...
> > InnoDB: Restoring possible half-written data pages from the doublewrite
> > InnoDB: buffer...
> > 060211 21:50:22  InnoDB: Starting log scan based on checkpoint at
> > InnoDB: log sequence number 0 43690.
> > InnoDB: Doing recovery: scanned up to log sequence number 0 43736
> > InnoDB: Last MySQL binlog file position 0 79, file
> > name /var/log/mysql/mysql-bin.000032
> > 060211 21:50:22  InnoDB: Flushing modified pages from the buffer pool...
> > 060211 21:50:22  InnoDB: Started; log sequence number 0 43736
> > 060211 21:50:22 [ERROR] mysqld: Incorrect information in file:
> > './mysql/host.frm'
> > 060211 21:50:22 [ERROR] mysqld: Incorrect information in file:
> > './mysql/host.frm'
> > 060211 21:50:22 [ERROR] Fatal error: Can't open and lock privilege tables:
> > Incorrect information in file: './mysql/host.frm'
> >
> > Don
> > --
> > - Powered by Debian Linux -
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>
Thread
Problem startingCasperLinux12 Feb
  • Re: Problem startingDonM12 Feb
    • Re: Problem startingsheeri kritzer20 Feb