Database data missing...

hawthorne

Hi all,
For one of my client,the data from a table is missing time and again. It is reported that client didn't changed anything but despite filling up data,we seeing this situation occuring. Can anyone say what may be issue and how to solve it parmanently,since filling the data again and again make no sense?

Thank You

zabmilenko

If it is a mysql database, check to see if checksums are enabled and look for corrupted tables.

See:
http://dev.mysql.com/doc/refman/5.0/en/checksum-table.html
http://dev.mysql.com/doc/refman/5.0/en/create-table.html
http://dev.mysql.com/doc/refman/5.0/en/alter-table.html

Since you didn't say what database server environment you use or a schema of the table that is having issues, it will be hard to come up with something useful to tell you. Your question is akin to: "My wife keeps losing her house key, over and over again. What could be causing it?"

hawthorne

How can I check whether checksum is enabled in My mysql database?What kind of information you need about databse environment? giving table schema may not be possible since my client doesn't want publication of any kind code or database code so without directly giving table schema,can I help any other way? Thank You for your response.

Piranha

hawthorne wrote:
can I help any other way?

I thought that you were the one wanting help. And I doubt that anyone will spend their time to help you out if you can't provide tools for it.

Of course you should not post if your client does not allow you to do it. But they and you have to understand that if you can't solve it it is virtually impossible to know what the problem is.

hawthorne

Thank You for your suggestions piranha. I understand what you said. I will try to google the keywords given by zab and also try to solve the problem using tips given.