linux mysql 常用脚本

./login-mysql.sh
use isdb;

mysqldump -uroot -pxxx isdb tb_d_uniskuser > tb_d_uniskuser.sql
mysqldump -t isdb -uroot -pxxx --tables tb_d_rubbish tb_d_rubbish_appeal tb_d_rubbish_appeal_verify tb_d_rubbish_dealwith tb_d_rubbish_decide tb_d_rubbish_appeal_dispose > rubbishAll.sql
导出表：不用登录mysql
mysqldump -uroot -pxxx isdb tb_s_work_order > tb_s_work_order20170118.sql
导入数据：登录mysql
source /home/aiuap_jc/user.sql;

nginx 中转服务器
cd /usr/local/nginx/
cd /opt/issystem/logs/nginx/
sudo tail -f -n 1000 access.log
sudo ./nginx -s reload

log_format main '$remote_addr - $remote_user [$time_local] "$http_host" "$request" '
'"$uri" $upstream_addr $upstream_response_time $request_time '
'$status $body_bytes_sent "$http_referer" '
'"$http_user_agent" "$http_x_forwarded_for"';

access_log /opt/issystem/logs/nginx/access.log main;

--修改用户权限
chown -R unisk_rubbish *
chown root:root *
chown unisk_rubbish:unisk_rubbish *
chgrp unisk_rubbish *
chmod 755 *
chmod 777 *