is there a way to view past mysql queries with phpmyadmin?

Question

i'm trying to track down a bug that's deleting rows in a mysql table.

for the life of me i can't track it down in my php code, so i'd like to work backwards by finding the actual mysql query that's removing the rows.

i logged in to phpmyadmin, but can't find a way to view the history of past sql operations.

is there a way to view them in phpmyadmin?

Answer 1

I don't think phpmyadmin lets you do that, but I'd like to hear I'm wrong.

On the other end you can enable query logging in mysql http://dev.mysql.com/doc/refman/5.0/en/query-log.html

Answer 2

I may be wrong, but I believe I've seen a list of previous SQL queries in the session file for phpmyadmin sessions

Answer 3

ok, so i actually stumbled across the answer.

phpmyadmin does offer a brief history. if you click on the 'sql' icon just underneath the 'phpmyadmin' logo, it'll open a new window. in the new window, just click on the 'history' tab.

that'll give you the last twenty or so sql operations.