Skip to main content

table corrupt in mysql

My server just ran out of space recently, so I do some cleanup.
Then my friend complain about several web app act abnormaly, turn out several db on mysql got table corrupt.
The error sound like "Can't open file: 'TableName.MYD'. (errno: 145)"
So to fix it, logon to mysql console, and type "REPAIR TABLE TableName"
And don't forget to select the db first ;)

Comments

Post a Comment

Popular posts from this blog

django realtime currency rate

Its been a really long time since I post something here For some dumb reason, I forgot my blogger login/password :hammer: Anyway, since I'm now heavily work with django stuff Here are some django related projects that hopefully can benefit anyone who need it * django-currency_rate, simple django app that can give you realtime currency rate base on http://themoneyconverter.com . Owh its even can calculate the rate with templatetag :) https://github.com/avenpace/django-exchange_rate
Post a Comment
Read more

python-oauth2 hack

When you are using python-oauth2 from simplegeo on your Google App Engine instance, you'll get some exception that cause by "ImportError: No module named httplib2" Yes, apparently httplib2 are not supported by GAE and instead they oblige you to use google.appengine.api.urlfetch.fetch instead So I hack python-oauth2 to use google.appengine.api.urlfetch.fetch You can found my python-oauth2 fork on https://github.com/avenpace/python-oauth2
Post a Comment
Read more

Another django cms base

Cooper-cms, a really simple cms built with django that probably suitable for company site. It has testimonial, team, content and blog (of course :) ) modules. I know its not fancy as django-cms but it will suit for some simple company site though https://bitbucket.org/avenpace/cooper-cms
Post a Comment
Read more