shah_ankitb Posted April 6, 2010 Share Posted April 6, 2010 I'm using fedora 11 linux. On my LAMP i'm looking for previously executed query list. I'm following this but not get resulthttp://dev.mysql.com/doc/refman/5.1/en/query-log.html Link to comment Share on other sites More sharing options...
thescientist Posted April 6, 2010 Share Posted April 6, 2010 what part are you having trouble with? what version of MySQL are you using? Link to comment Share on other sites More sharing options...
shah_ankitb Posted April 6, 2010 Author Share Posted April 6, 2010 I'm using Mysql 5.1.37. when i'm running this query i'm unable to see all previous query which are executedSELECT * FROM mysql.general_log g LIMIT 0,1000 If u look at in to the MySQL Query Browser GUI. They are providing history feature i want same thing for command line query Link to comment Share on other sites More sharing options...
justsomeguy Posted April 6, 2010 Share Posted April 6, 2010 when i'm running this query i'm unable to see all previous query which are executedSELECT * FROM mysql.general_log g LIMIT 0,1000Is that because you're only selecting the first 1000 entries? Link to comment Share on other sites More sharing options...
shah_ankitb Posted April 8, 2010 Author Share Posted April 8, 2010 no. it's not because of that. although i'm running 'SELECT * FROM mysql.general_log g". it's not showing my previously executed query logs.If u look at in to the MySQL Query Browser GUI. They are providing history feature i want same thing for command line query Link to comment Share on other sites More sharing options...
justsomeguy Posted April 8, 2010 Share Posted April 8, 2010 although i'm running 'SELECT * FROM mysql.general_log g". it's not showing my previously executed query logs.Are you sure that MySQL is configured to store its logs in a table called mysql.general_log? Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.