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

Yet another online shop launch

For housewife who use to work, daily activities are dull and boring. So I've been persuade my wife to run online shop to add variation on her daily routine. Finally we decided to start selling clothing goods and knick knacks, some are airbrush paint t shirt, woman snake leather handbag are there also Since I've been working with python, I came out to use satchmo for our online shop framework After doing customizing here and there and build some payment modules, we lauch WarungRupa.com  on early January 2012 We have some ideas which are still in our thoughts and we keen to work on it Hope WarungRupa.com  can have many visitors and buyers Next to do are SEO and promotions ^_^
1 comment
Read more

java MessageDigest

If you use MessageDigest in java to encrypt string, you wont get hash like other language does. So you need to convert the result so that you can compare the hash result with other output that produce by diff language. Found the function on the java net forum private static String baToHexString(byte byteValues[]) { byte singleChar = 0; if (byteValues == null || byteValues.length String entries[] = { "0", "1", "2", "3", "4", "5", "6", "7", "8", "9", "a", "b", "c", "d", "e", "f" }; StringBuffer out = new StringBuffer(byteValues.length * 2); for (int i = 0; i singleChar = (byte) (byteValues[i] & 0xF0); singleChar = (byte) (singleChar >>> 4); // shift the bits down singleChar = (byte...
Post a Comment
Read more
1 Desember 2003 Spider admin diinstall dari karena situs cvs di midgard tidak dapat diakses dan situs spider sendiri berbahasa Rusia sehingga mencari di www.google.com dengan keyword "spider-admin.xml.gz". Spider dan aegir dapat berjalan dengan baik.
Post a Comment
Read more