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

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...

hacking sierra wireless aircard 555 on suse 10

Since there's a lot of changes from pcmcia-cs to pcmciautils, pcmcia operation suppose to be easier because it now work with hotplug. That mean when the card got inserted to the laptop, linux will just recognize it in a zap. But that's just doesn't work for sierra aircard 555 while you using suse 10. To make your aircard 555 work on suse 10, you need to fiddle around a bit with linux kernel. Owww and you will need you kernel source because we need to recompile the serial_cs module! First, make sure when you insert the card to pcmcia slot and the pcmciautils recognize your card type "pccardctl info" then you should get following output on your shell ong@saintlucifer:~> pccardctl status Socket 0: command 'status' not yet handled by pccardctl o3ng@saintlucifer:~> pccardctl info PRODID_1="Sierra Wireless" PRODID_2="AirCard 555" PRODID_3="A555" PRODID_4="Rev 1" MANFID=0192,a555 FUNCID=6 Then you need to get Aircard ...

CapitalizeWords.java

I need to make my string sentence to be capitalize on each first character of word, So far haven't find such function that I can use. So made this simple class, incase someone need it. It's GPL so free to use it and modify it. import java.util.Scanner; import java.util.ArrayList; import java.util.Iterator; import java.lang.StringBuilder; /** * * @author avenpace * I'm using singleton here so, hope you know what that means ;) * license under the GPL so free to use, modify and hack whatever you want * lemme know if this programme benefit you if you had the time */ public class CapitalizeWords { private static CapitalizeWords capinstance; private CapitalizeWords() { } /** * The method will capitalizing every first character on each word on the String sentence * This method take two parameter, * @param source source sentence string that you want to capitalize on the first character if each word. * @param allword this argument...

o3ng weblog...

Search This Blog