where can I find the mysql logs (errors, queries, etc) in the phpmyadmin interface?
Answers
Open your PHPMyAdmin, don't select any database and look for
Binary Log
tab . You can select different logs from a drop down list and press GO
Button to view them.
In phpMyAdmin 4.0, you go to Status > Monitor. In there you can enable the slow query log and general log, see a live monitor, select a portion of the graph, see the related queries and analyse them.
If you are using XAMPP as your server, you'll find a logs directory as a child of the XAMPP directory. If you have not tried XAMPP, which runs on any system (Windows, Mac OS & Linux) find more here: http://www.apachefriends.org/en/xampp.html
0 comments:
Post a Comment