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

User · Answer

Yes  you can log queries to a special phpMyAdmin DB table   See SQL history

User · Answer

why dont you use export  then click  Custom - display all possible options  radio button  then choose your database  then go to Output and choose  View output as text  just scroll down and Go  Voila

User · Answer

There is a Console tab at the bottom of the SQL  query  screen  By default it is not expanded  but once clicked on it should expose tabs for Options  History and Clear  Click on history    The Query history length is set from within Page Related Settings which found by clicking on the gear wheel at the top right of screen   This is correct for PHP version 4 5 1-1

User · Answer

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 will give you the last twenty or so SQL operations

User · Answer

you can run your past mysql with run  PATH PAST MYSQL bin mysqld exe  it run your last mysql and you can see it in phpmyadmin and other section of your system   notice  stop your current mysql version   S F My English

User · Answer

I am using phpMyAdmin Server version  5 1 41   It offers possibility for view sql history through phpmyadmin pma history table   You can search your query in this table   pma history table has below structure

User · Answer

There is a tool called Adminer which is capable of doing all phpmyadmin job packed in single tiny php file   http   www techinfobit com how-to-import-export-database-without-any-extra-installation

User · Answer

Here is a trick that some may find useful  For Select queries  only   you can create Views  especially where you find yourself running the same select queries over and over e g  in production support scenarios  The main advantages of creating Views are   they are resident within the database and therefore permanent they can be shared across sessions and users they provide all the usual benefits of working with tables they can be queried further  just like tables e g  to filter down the results further as they are stored as queries under the hood  they do not add any overheads   You can create a view easily by simply clicking the  quot Create view quot  link at the bottom of the results table display

User · Answer

You have to click on query window just below the phpMyAdmin logo  a new window will open  Just click on SQL History tab  There you can see history of SQL Queries

User · Answer

I don t think phpMyAdmin lets you do that  but I d like to hear I m wrong   On the other hand you can enable query logging in MySQL  The General Query Log

User · Answer

You just need to click on console at the bottom of the screen in phpMyAdmin and you will get the Executed history

User · Answer

To view the past queries simply run this query in phpMyAdmin   SELECT   FROM  general log    if it is not enabled  run the following two queries before running it   SET GLOBAL log output    TABLE   SET GLOBAL general log    ON

User · Answer

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

User · Answer

OK so I know I m a little late and some of the above answers are great stuff   As little extra though  while in any PHPMyAdmin page    Click SQL tab Click  Get auto saved query    this will then show your last entered query

[mysql] Is there a way to view past mysql queries with phpmyadmin?

Examples related to mysql

Examples related to phpmyadmin