View unanswered posts    View active topics

All times are UTC - 6 hours





Post new topic Reply to topic  [ 5 posts ] 
Print view Previous topic   Next topic  
Author Message
Search for:
 Post subject: MySQL need help!
PostPosted: Tue Dec 01, 2009 3:49 am 
Offline
Joined: Tue Feb 21, 2006 7:24 am
Posts: 396
Location: Dushanbe, Tajikistan
cat KnoppMyth-version
KnoppMyth R5F27

I hope someone can help me! I had a power outage today and now MySQL dies with sig 11.
This was after having to run a fsck.

something in /var/lib/mysql/mysql has gotten corrupted. How can rebuild files for this directory. I am hoping that everything under mythconverge is still good.

When I did the initial install, I went with all the defaults for database install.

Thanks,
M


Top
 Profile  
 
 Post subject:
PostPosted: Tue Dec 01, 2009 4:43 pm 
Offline
Joined: Wed Nov 16, 2005 8:55 pm
Posts: 1381
Location: Farmington, MI USA
Start here: http://knoppmyth.net/phpBB2/viewtopic.php?t=1043


Top
 Profile  
 
 Post subject:
PostPosted: Wed Dec 02, 2009 1:08 am 
Offline
Joined: Tue Feb 21, 2006 7:24 am
Posts: 396
Location: Dushanbe, Tajikistan
Now is good time for me to pick up a UPS. I have had tons of crashes, this is the first time that I have really been bit.

Here is how I solved this issue.

I have had corrupt tables in mythconverg before, but this is the first time that that a data file got mucked in /var/lib/mysql/mysql. I tried to repair the tables to no avail.

I figured this out doing a "strace mysqld" and I could see that last thing it read before the segfault was host.frm. I then tested this by moving all of files out of /var/lib/mysql/mysql and recreated them by doing a:

/usr/bin/mysql_install_db

and running starting mysqld. It started fine without the segfault.

I then ran "dpkg-reconfigure mysql-server-5.0" to reset the msql maintenance and root accounts.

After that I added the mythtv user to mysql and gave the account the correct privileges and password.

The system has been rock solid now several years, so I have not worried about upgrading or anything. Why mess with a good thing..

I have had it working great now in KL Malaysia using the Astro service, in Kabul using a custom cable system (bank of AFN boxes muxed into a cable.) and now again with AFN in Tajikistan.. :)


Top
 Profile  
 
 Post subject:
PostPosted: Wed Dec 02, 2009 12:16 pm 
Offline
Joined: Sun Sep 25, 2005 3:50 pm
Posts: 1013
Location: Los Angeles
mac wrote:
I have had it working great now in KL Malaysia using the Astro service, in Kabul using a custom cable system (bank of AFN boxes muxed into a cable.) and now again with AFN in Tajikistan.. :)


I just wanted to wish you safe travels wherever your mythbox calls home.

Dushanbe as in the "Dushanbe Road" in the movie "Spies Like Us"?

_________________
Mike
My Hardware Profile


Top
 Profile  
 
 Post subject:
PostPosted: Thu Dec 03, 2009 7:33 am 
Offline
Joined: Tue Feb 21, 2006 7:24 am
Posts: 396
Location: Dushanbe, Tajikistan
Quote:
Dushanbe as in the "Dushanbe Road" in the movie "Spies Like Us"?

One and the same!


Top
 Profile  
 

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


All times are UTC - 6 hours




Who is online

Users browsing this forum: No registered users and 15 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