技术相关实践记录2

Nginx反向代理无法访问静态文件解决

user  root; #用户worker_processes  1;error_log  logs/nginx_error.log; #要保证有指定的目录和文件，否则nginx启动会报错#error_log  logs/error.log  notice;#error_log  logs/error.log  info;#pid        logs/nginx.pid;events {    worker_connections  1024;}http {    include       mime.types;    default_type  application/octet-stream;    sendfile        on;    #tcp_nopush     on;    #keepalive_timeout  0;    keepalive_timeout  65;    server {        listen       80; #监听80端口,就是直接输入域名就可以        server_name  www.addoiles.com;        #charset koi8-r;        #access_log  logs/host.access.log  main;        location / {        #如果无法加载静态资源是应为这个填写ip没有填写域名的原因，应为网站通过域名DNS解析到ip，直接写ip不走dns，也就访问不到静态资源            #和本地调试不是一回事            proxy_pass http://www.addoiles.com:8080/addoiles.com-1.0/;        }        error_page   500 502 503 504  /50x.html;        location = /50x.html {            root   html;        }    }}

mysql 数据导入导出

-- select * from oil_article;-- 截止2017-9-11 15:19最新数据,后面的都是新增的数据，需要同步select max(id) from oil_article where create_time <= 1502242390;-- 查询出需要同步的数据,即增量的数据select * from oil_article where create_time > 1502242390;-- 增量的数据导出到文件select * from oil_article where create_time > 1502242390 into outfile 'd:/test_add_datas.txt';-- 增量数据导入到sync_oil_article库中的oil_article表load data infile 'd:/test_add_datas.txt' into table sync_oil_article.oil_article;-- REPLACE和IGNORE关键词控制对现有的唯一键记录的重复的处理。如果你指定REPLACE，新行将代替有相同的唯一键值的现有行。如果你 指定IGNORE，跳过有唯一键的现有行的重复行的输入。-- 如果你不指定任何一个选项，当找到重复键键时，出现一个错误，并且文本文件的余下部分被忽略-- repalce load data infile 'd:/test_add_datas.txt' replace into table sync_oil_article.oil_article;-- ignoreload data infile 'd:/test_add_datas.txt' ignore into table sync_oil_article.oil_article;-- 导出导出分隔符要统一select * from oil_article where create_time > 1502242390 into outfile 'd:/test_add_datas_u.txt' fields terminated by ',';load data infile 'd:/test_add_datas_u.txt' into table sync_oil_article.oil_article fields terminated by ',';-- 指定OPTIONALLY ENCLOSED BY CHAR和VARCHAR字段将被""包含select * from oil_article where create_time > 1502242390 into outfile 'd:/test_add_datas_u2.txt' fields terminated by ',' optionally enclosed by '"';-- 同理一行一行select * from oil_article where create_time > 1502242390 into outfile 'd:/test_add_datas_u4.txt' fields terminated by ',' optionally enclosed by '"' lines terminated by '\ndfs';-- 语法: LOAD DATA [LOW_PRIORITY] [LOCAL] INFILE 'file_name.txt' [REPLACE | IGNORE] [FIELDS [TERMINATED BY '\t'] [OPTIONALLY] ENCLOSED BY ''][ESCAPED BY '\\' ]][LINES TERMINATED BY '\n'][IGNORE number LINES][(col_name,...)]-- mysqldump导出整个表的数据，包括建表信息，这也是最基础的用法mysqldump -uroot -proot addoiles oil_article > d:/addoiles_oil_article.txt;