View unanswered posts    View active topics

All times are UTC - 6 hours





Post new topic Reply to topic  [ 3 posts ] 
Print view Previous topic   Next topic  
Author Message
Search for:
 Post subject: mysql issue
PostPosted: Tue Dec 01, 2009 4:58 pm 
Offline
Joined: Tue Nov 14, 2006 2:55 pm
Posts: 245
Location: South Jersey
Can someone send me user.frm from /var/lib/mysql/mysql please? Mysql is hosed and googling the issue shows that my file is scrambled. I'm hoping a copy fixes the issue.

Thanks, _Abs

_________________
R6.04, dual core 3ghz, 3 gig memory, Zotac 8400 passive heat sink dvi/hdmi out video, 500 gig sata, dual tuner hdhomerun, streamzap remote

Abby


Top
 Profile  
 
 Post subject:
PostPosted: Tue Dec 01, 2009 5:41 pm 
Offline
Joined: Tue Nov 14, 2006 2:55 pm
Posts: 245
Location: South Jersey
re: 091201 18:30:19 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist

So my /var/lib/mysql/mysql/host* files were screwed up due to a crash on the MBE. I blew them away and ran /usr/bin/mysql_install_db --user=mysql

That brought up the error above. To solve this I copied the entire /var/lib/mysql/mysql directory from my SBE.

Then I had corrupt tables to which I ran: myisamchk -r *MYI from /var/lib/mysql/mythconverg directory.

Then I finally did myisamchk -f -r *MYI.

Then I restarted mysql: /etc/init.d/mysql start

Voila. Hope this helps someone.

Thanks, -Abs

_________________
R6.04, dual core 3ghz, 3 gig memory, Zotac 8400 passive heat sink dvi/hdmi out video, 500 gig sata, dual tuner hdhomerun, streamzap remote

Abby


Top
 Profile  
 
 Post subject:
PostPosted: Wed Dec 02, 2009 8:50 pm 
Offline
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location: Arlington, MA
Great hint. It must be the season for DB errors in the root schema as someone else just posted something very similar here: http://knoppmyth.net/phpBB2/viewtopic.php?t=20630


Top
 Profile  
 

Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 


All times are UTC - 6 hours




Who is online

Users browsing this forum: No registered users and 21 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group

Theme Created By ceyhansuyu