MYSQL SQL Statements HIstory Tracker

Hi , Is there a tool that can be used to retrieve all the past sql statements executed on a MYSQL database assuming no logs were stored. Regards,

If the general query log is not activated, I doubt if there is such a tool. The MySQL manual says that you have to explicitly enable it. http://dev.mysql.com/doc/refman/5.1/en/server-logs.html But maybe the slow query log might have been activated by default? However, the thread post below suggests using mytop http://www.webmasterworld.com/forum112/185.htm On Fri, Jul 17, 2009 at 9:50 AM, Esther Shayo <eshayo@afripayments.com>wrote:
Hi ,
Is there a tool that can be used to retrieve all the past sql statements executed on a MYSQL
database assuming no logs were stored.
Regards,
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Skunkworks announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science - http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi - http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general
participants (2)
-
Esther Shayo
-
Peter Karunyu