#!/bin/bash
currenttime=$(date "+%Y-%m-%d")
/mysql/mysqlsoft/bin/mysql -uwangya -pwangya -hx.x.x.x -P3306 -Ne "use caihui1;select * from chdquote where ENTRYDATE='$currenttime 00:00:00';" >/tmp/chdquote.txt
#/mysql/mysqlsoft/bin/mysql -uroot -proot --socket=/mysql/tmps/mysql.sock3306 -e "use caihui_test;load data infile '/tmp/chdquote.txt' into table chdquote";
为什么没有写成select * into outfile '/tmp/xxx'的形式呢?
可能是wangya这个账号是缺少相应的权限的,因为我用本地root账号是没有问题的;
currenttime=$(date "+%Y-%m-%d")
/mysql/mysqlsoft/bin/mysql -uwangya -pwangya -hx.x.x.x -P3306 -Ne "use caihui1;select * from chdquote where ENTRYDATE='$currenttime 00:00:00';" >/tmp/chdquote.txt
#/mysql/mysqlsoft/bin/mysql -uroot -proot --socket=/mysql/tmps/mysql.sock3306 -e "use caihui_test;load data infile '/tmp/chdquote.txt' into table chdquote";
为什么没有写成select * into outfile '/tmp/xxx'的形式呢?
可能是wangya这个账号是缺少相应的权限的,因为我用本地root账号是没有问题的;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29620572/viewspace-1807474/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29620572/viewspace-1807474/