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. < salvadesswa...@gmail.com> wrote: > On Thu, Jun 17, 2010 at 16:55, Usha Murali <ushapram...@gmail.com> wrote: > > hi, > > > > can any one just tell how to view all the commands executed in mysql > prompt > > > > 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 > _______________________________________________ ILUGC Mailing List: http://www.ae.iitm.ac.in/mailman/listinfo/ilugc