Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

does mysql or phpmyadmin(Server variables and settings?) keep logs of activity? If so where and if not is it something i can turn on?

Some tables in different databases with different users are being emptied?!

any pointer appreciated, Dan

share|improve this question

You're trying to log who is emptying the table? phpMyAdmin won't help here; even if you could turn on logging with it you would only see commands sent through the phpMyAdmin interface. So that's not much help.

Sounds like you want to enable the MySQL binary log. This could generate large log files, but should help.

share|improve this answer

As someone else mentioned, binary logs will give you a log of every change:

If it's your own code that's buggy and doing bad things, you might also try using the binary log in conjunction with marking your queries with comments like is explained here:

That may help you triangulate the issue.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.