shellsql连接mysql

nianzong

shell脚本不能实现mysql的表锁，因为该锁表语句是基于session的，会话断开即解锁。
借助shellsql工具可以解决这个问题：
http://www.edlsystems.com/shellsql/

下载后安装：
./install.sh
B

1.3 - shmysql
This initiates a MySQL connection. The syntax is....
        shmysql connectarg [connectarg] ...
The connectarg(s) are concatonated together separated by spaces. So for example, the following is perfectlly legal....
        shmysql dbname=test user=myuser
which does the same thing as
        shmysql "dbname=test user=myuser"
Either way, the arguments of the engne take the form of name=value where name is one of the following. Most have sensible defaults.
host
The host name or IP address of the server
port
The TCP port number to connect to on the server
dbname
The database name
user
The user name for the connection
password
The password for the user
socket
The name of the UNIX socket if applicable
flag
Usually not defined or zero, but can be used in special circumstances, see the documentation in MySQL for further information.
If you are using the password assignment in the connection then you should use the "password=mysecret" string as a separate parameter. The reason for this is that "shpostgres" will detect it and blank it out in the process table so someone else doing a "ps" cannot see it.
用法举例：
HANDLE=`shmysql user=root password=12345678 dbname=test`
#执行结果是一串数字

shsql $HANDLE "flush tables with read lock"
#执行sql语句，只能同时发布执行一条sql语句，如果要执行多个sql语句，执行多次shsql即可；并且不支持system调用系统命令

shsql $HANDLE "SQL statement"
...

shsql $HANDLE "unlock tables"

shsqlend $HANDLE
#结束本次mysql connection,释放$HANDLE

更具体的例子请看本人写的LVM snapshot mysql backup shell script。






本文来自ChinaUnix博客，如果查看原文请点：http://blog.chinaunix.net/u2/61187/showart_2016520.html