Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

2 Answers 2

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: http://dev.mysql.com/doc/refman/5.0/en/binary-log.html

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: http://37signals.com/svn/posts/3130-mini-tech-note-mysql-query-comments-in-rails

That may help you triangulate the issue.

share|improve this answer

Your Answer

 
discard

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.