bash_history 和 mysql_history

bash history

1 history

查看历史命令

2 export HISTTIMEFORMAT='%F %T '

   history

查看带上时间的历史命令。

3 cat ~/.bash_history | less

 查看历史命令文件。

4 !n

 执行编号为n的历史命令

5 history n

 显示最近n条历史命令。

6 ctrl+R+name

 搜索包含name的历史命令，然后按↑↓键可以看到该命令相邻的命令。

7 !name 

 执行以name开头的命令

8 vim ~/.bash_profile

   HISTFILE=new history name

修改历史命令保存的文件，默认在.bash_history中

9 history -c

  清除所有的历史命令。

MySQL history

On Unix, the mysql client writes a record of executed statements to a history file. By default, the history file is named .mysql_history and is created in your home directory. To specify a different file, set the value of the MYSQL_HISTFILE environment variable. 
If you do not want to maintain a history file, first remove .mysql_history if it exists, and then use either of the following techniques: 
Set the MYSQL_HISTFILE variable to /dev/null. To cause this setting to take effect each time you log in, put the setting in one of your shell's startup files. 
Create .mysql_history as a symbolic link to /dev/null: shell> ln -s /dev/null $HOME/.mysql_history
You need do this only once.