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.<br><a href="http://dev.mysql.com/doc/refman/5.1/en/server-logs.html">http://dev.mysql.com/doc/refman/5.1/en/server-logs.html</a><br>
<br>But maybe the slow query log might have been activated by default?<br><br>However, the thread post below suggests using mytop<br><a href="http://www.webmasterworld.com/forum112/185.htm">http://www.webmasterworld.com/forum112/185.htm</a><br>
<br><div class="gmail_quote">On Fri, Jul 17, 2009 at 9:50 AM, Esther Shayo <span dir="ltr">&lt;<a href="mailto:eshayo@afripayments.com">eshayo@afripayments.com</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">









<div link="blue" vlink="purple" lang="EN-US">

<div>

<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>

<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">Hi ,</span></font></p>

<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>

<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">Is there a tool that can be used to retrieve all the past
sql statements executed on a MYSQL </span></font></p>

<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">database assuming no logs were stored.</span></font></p>

<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>

<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>

<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>

<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">Regards,</span></font></p>

<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>

<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>

</div>

</div>


<br>_______________________________________________<br>
Skunkworks mailing list<br>
<a href="mailto:Skunkworks@lists.my.co.ke">Skunkworks@lists.my.co.ke</a><br>
<a href="http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks" target="_blank">http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks</a><br>
Other services @ <a href="http://my.co.ke" target="_blank">http://my.co.ke</a><br>
Other lists<br>
-------------<br>
Skunkworks announce: <a href="http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce" target="_blank">http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce</a><br>
Science - <a href="http://lists.my.co.ke/cgi-bin/mailman/listinfo/science" target="_blank">http://lists.my.co.ke/cgi-bin/mailman/listinfo/science</a><br>
kazi - <a href="http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general" target="_blank">http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general</a><br>
<br></blockquote></div><br>