Enable Reverse Search of MySQL History

vikas027 · 05-02-2010, 02:07 PM

Hi,

I am sorry to post here, if in case this is not the right forum.

I am new to MySQL.

I just installed MYSQL 5.0.90 from http://www.sfr-fresh.com/unix/misc/mysql-5.0.90.tar.gz/
on my RHEL 5.0 machine.

I have seen "Reverse Searching of MySQL History" , but however I am unable to do so in my MYSQL 5.0.90.

Can someone help me out please ?

vikas027 · 05-18-2010, 06:53 PM

Any ideas gurus ?

jschiwal · 05-18-2010, 07:21 PM

I believe that the mysql client uses the same readline function as the bash shell, but uses a .myql_history file instead of .bash_history. It is the client rather than the server that would be the reason for your lack of command history.

First question is do you use the bash shell. Does CTRL_R in the console work?

Are you using the --quick or --batch options? If you do, mysql doesn't use the ~/.mysql_history file.

Run `echo MYSQL_HISTORY'. Does it equal /dev/null?
Run `ls -l ~/.mysql_history'. Is it linked to /dev/null?

vikas027 · 05-21-2010, 12:59 PM

Quote:

Originally Posted by jschiwal

First question is do you use the bash shell. Does CTRL_R in the console work?

Yes, CTRL+R is working perfectly with bash shell.

Quote:

Originally Posted by jschiwal

Are you using the --quick or --batch options? If you do, mysql doesn't use the ~/.mysql_history file.

How can I check this ?
By the way, I have installed mysql using these options.

Code:

./configure \
--prefix=/usr/local/mysql \
--localstatedir=/usr/local/mysql/data \
--disable-maintainer-mode \
--with-mysqld-user=mysql \
--with-unix-socket-path=/tmp/mysql.sock \
--without-comment \
--without-debug \
--without-bench

Quote:

Originally Posted by jschiwal

Run `echo MYSQL_HISTORY'. Does it equal /dev/null?

Code:

[root@server ~]# echo $MYSQL_HISTORY

[root@server ~]#

Quote:

Originally Posted by jschiwal

Run `ls -l ~/.mysql_history'. Is it linked to /dev/null?

No

Code:

[root@server ~]# ls -l ~/.mysql_history
-rw------- 1 root root 23958 May  6 03:36 /root/.mysql_history

vikas027 · 05-26-2010, 02:32 AM

Dear jschiwal,

Any idea.

vikas027 · 06-16-2010, 02:06 AM

Any update Gurus/Jschiwal ?

EricTRA · 06-16-2010, 02:21 AM

Hello Vikas,

Is there content in your .mysql_history file? Check using

Code:

cat /root/.mysql_history

If there is content then you can reverse search when in your MySQL console by pressing CTRL R as indicated by jschiwal.

You should see something like this:

Code:

(reverse-i-search)`':

at which point you can start by typing the first letters of the command you're looking for.

Normally if mysql_history is enabled you can browse through the commands already executed with the arrow up and down keys also, just like in bash.

Kind regards,

Eric

vikas027 · 07-06-2010, 01:39 PM

Quote:

Originally Posted by EricTRA

Hello Vikas,

Is there content in your .mysql_history file? Check using

Code:

cat /root/.mysql_history

If there is content then you can reverse search when in your MySQL console by pressing CTRL R as indicated by jschiwal.

Hi Eric,

Sorry for long delay.
Yes, there is content in /root/.mysql_history.

Code:

[root@server ~]# ls -l /root/.mysql_history 
-rw------- 1 root root 335 Jul  6 23:57 /root/.mysql_history
[root@server ~]# tail -5 /root/.mysql_history
show\040tables;
show\040tables;
\134q
\134q
\134q

Quote:

Originally Posted by EricTRA

Normally if mysql_history is enabled you can browse through the commands already executed with the arrow up and down keys also, just like in bash.

Yes, I can use up-down arrow keys, but not the Ctrl+R feature.

I have tested the same on many machines, it is NOT working in any machine. May be I have missed out something at compiling OR in config file.