Technology Questions

Go Back   Technology Questions > Technology Questions Community > Announcements

Announcements We'll post the latest updates to the website in this forum.

Reply
 
LinkBack Thread Tools
  #1 (permalink)  
Old 01-04-2007, 01:14 PM
LPH's Avatar
LPH LPH is offline
Administrator
 
Join Date: Sep 2003
Location: USA
Posts: 3,348
LPH is on a distinguished road
MySQL Trouble Resolved

If you tried to hit the site over the last few hours you may have been greeted with either a site not found or a MySQL error. The post.MYI file was corrupt and the repair was failing. Steve from vBulletin was fantastic with his support and ideas on how to fix the database table. The key was using myisamchk at the command line with the proper switches so that the large database would repair - otherwise there was not enough space in the tmp location for the repair.

I have only checked the site quickly and everything looks to be in order. Hopefully no one's posts have been deleted. More time will be spent to see what went wrong.

PS. The good news from this experience is that backups from the host had failed. Luckily there was a local backup and an FTP backup repository is being created. No more relying on hosts.
__________________
Layne P. Heiny / Administrator for Tux Reports Network

Please do not send private messages requesting technical support. Place your request in the proper forum and hopefully someone can help you.

Computer Sites
Tablet PC Blogs | Technology Questions | Tablet PC Post | Windows Vista | What Is New

Prelaunch
Insane Politics
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote

 
Old 01-04-2007, 01:14 PM
  #2 (permalink)  
Old 01-05-2007, 11:40 AM
LPH's Avatar
LPH LPH is offline
Administrator
 
Join Date: Sep 2003
Location: USA
Posts: 3,348
LPH is on a distinguished road
Re: MySQL Trouble Resolved

Yeah Yeah. Quit hassling me. I thought things were fine until I manually ran a repair/optimize on the post table through vBulletin. The server hung and there was an hour of panic :-)

All should be well.
__________________
Layne P. Heiny / Administrator for Tux Reports Network

Please do not send private messages requesting technical support. Place your request in the proper forum and hopefully someone can help you.

Computer Sites
Tablet PC Blogs | Technology Questions | Tablet PC Post | Windows Vista | What Is New

Prelaunch
Insane Politics
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote

Reply

Bookmarks

Thread Tools

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 On
HTML code is On
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
MySQL Vs. LDAP Michael Everson Linux 3 10-21-2007 04:40 PM
RESOLVED - Explorer shows hidden partitions - RESOLVED Emerald Saint Windows XP 0 10-11-2007 03:10 PM
mysql connector with monodevelop Andreas Duffner Linux 0 05-06-2007 12:12 AM
mySQL and wave files Pachy Desktop Computers 0 02-06-2007 05:04 PM
mySQL and wave files Pachy Desktop Computers 0 02-06-2007 05:04 PM


New To Technology Questions? Do You Need Help with Your Computer or Device? Do You Need Help with this site?

All times are GMT -8. The time now is 08:49 PM.


2003 - 2009 All Rights Reserved. Technology Questions

Search Engine Friendly URLs by vBSEO 3.3.0