DB inconsistency check

[eracha]

hi all,

I have been turning around with this problem for a while now, and do hope some body can help me go about it here.

I need to write s short java class to check for inconsistency in a mysql DB. It is something I thought I could realize using a trigger, but the whole idea flopped.
Basically, it should look like:


public class DbChecker extends TimerTask{
public DbCheck(){ //initialize the connection to database
}

public void run(){
// your algorithm for checking for inconsistency
//if inconsistency found, write in to a log file
//using java.util.Logger
}
}

//class to perform task.
Timer.schedule(DbChecker,intervals)



My java knowledge is limited, that's I am unable to implement that run method as as I am calling it, and that's thing holding me. I will greatly appreciate if some one can help me formulate the algorithm or give me tips on how to go about it.

Thanks
Eric

[WingedPanther]

It depends on what you mean by an inconsistency. Are you looking for data corruption, table structure corruption, other?

[eracha]

hi WingedPanther,

thanks for the respond. You are right. That's exactly what I want, that is, checking for all corrupt data and corrupt table structure including wrong key references in the DB.

I am able to connect to my DB and retrieve data, but how to check for this inconsistency is a challenge for me.

Are the code lines you provided all I need or some further codes needs to be added to it.
I appreciate and thanks.

Eric

[WingedPanther]

A quick search for "mysql metadata" gave me commands for finding the information you need.