hi thanks for giving me solution instanlty !!
Is'nt there any shortcuts to be executed in mysql prompt itself ?
for eg. in psql i give \s in psql prompt to get all my command history....
like that
Thanks once again!!
On Thu, Jun 17, 2010 at 5:11 PM, Salvadesswaran P.S. <
salvadesswaran@xxxxxxxxx> wrote:
On Thu, Jun 17, 2010 at 16:55, Usha Murali <ushapramoth@xxxxxxxxx> wrote:
hi,prompt
can any one just tell how to view all the commands executed in mysql
You can accomplish this by:
$ cd ~
$ cat .mysql_history
This is similar to .bash_history file that is logged for each user.
You can direct the history to another log file by using:
$ export MYSQL_HISTFILE=/home/webtest/dblog
--
Salvadesswaran Srinivasan
Chennai
_______________________________________________
ILUGC Mailing List:
http://www.ae.iitm.ac.in/mailman/listinfo/ilugc