LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 07-15-2006, 07:04 PM   #1
cptnapalm
LQ Newbie
 
Registered: Jul 2006
Posts: 2

Rep: Reputation: 0
mysql crash on startup: Incorrect file format 'host'


Ok, Ubuntu is the distribution.

mysql is crashing on startup. This is the output from running mysqld_safe:

060715 16:44:01 InnoDB: Started; log sequence number 0 43675
060715 16:44:01 [Note] Recovering after a crash using /var/log/mysql/mysql-bin
060715 16:44:01 [Note] Starting crash recovery...
060715 16:44:01 [Note] Crash recovery finished.
060715 16:44:01 [ERROR] Fatal error: Can't open and lock privilege tables: Incorrect file format 'host'

It was working just fine until a few days ago. I've tried looking for similar problems, but I haven't been able to find anything of use. (Sidenote: oddly, one search on Google told me that the search I tried was too similar to automated spyware searches so wouldn't show me anything...)

I have tried re-installing the packages, but to no avail. (It worked for a broken libmono install.)

Any help would be appreciated.

Patrick
 
Old 08-02-2006, 08:00 PM   #2
tim1235
Member
 
Registered: Aug 2004
Location: Melbourne, Australia
Distribution: fc5/Gentoo
Posts: 57

Rep: Reputation: 15
Have you upgraded mysql?

Checkout http://bugs.mysql.com/bug.php?id=66
 
Old 08-03-2006, 09:53 PM   #3
cptnapalm
LQ Newbie
 
Registered: Jul 2006
Posts: 2

Original Poster
Rep: Reputation: 0
I think the problem was that my xfs filesystem did not recover from a hard lock. The system as a whole began to degrade due to it. Eventually, it necessitated an entire reinstall. For the root partition, its all ext3 now...
 
Old 08-04-2006, 12:10 AM   #4
tim1235
Member
 
Registered: Aug 2004
Location: Melbourne, Australia
Distribution: fc5/Gentoo
Posts: 57

Rep: Reputation: 15
An option is to re-setup the mysql table (mysql_install_db) as this has the host table I assume your statup is complaning about, but this would cause you to lose all previous user privlages. Hopefuly your other databases are ok?
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
mySQL starts then Stops, no 'mysql.host' DavidHB Slackware 10 08-08-2006 05:11 AM
Monitor settings incorrect on startup Mosaic Slackware 2 11-30-2005 04:39 AM
Host crash Engmar Linux From Scratch 5 10-10-2005 01:09 PM
crash on X startup macubo Yoper 12 12-18-2004 03:56 AM
MySQL/PHP to SMS File Format Manuel-H Linux - Software 0 09-11-2003 07:57 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 07:39 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration