删除指定分类的文章 测试 SELECT * FROM wp_posts a LEFT JOIN wp_term_relationships b ON ( a.ID = b.object_id ) LEFT JOIN wp_postmeta c ON ( a.ID = c.post_id ) LEFT JOIN wp_term_taxonomy d ON ( d.term_taxonomy_id = b.term_taxonomy_id ) LEFT JOIN wp_terms e ON ( e.term_id = d.term_id ) WHERE e.term_id = 16759 删除 delete a,b,c,d FROM […]
. Read more
rpm -qa | grep -i mysql rpm -e xxxx wget http://dev.mysql.com/get/mysql57-community-release-el6-9.noarch.rpm yum localinstall mysql57-community-release-el6-9.noarch.rpm yum repolist enabled | grep “mysql.*-community.*” yum install mysql yum install mysql-server service mysqld retsart 如果MySQL Daemon failed to start. 最好重命名以下目录 rm -fr /var/lib/mysql/* rm /var/lock/subsys/mysqld killall mysqld service mysqld retsart 查看临时的初始密码 grep ‘temporary password’ /var/log/mysqld.log mysql_secure_installation /etc/init.d/mysqld restart
. Read more
debian 9 apt update apt install apache2 ln -s /etc/apache2/mods-available/cgid.conf /etc/apache2/mods-enabled/cgid.conf ln -s /etc/apache2/mods-available/cgid.load /etc/apache2/mods-enabled/cgid.load 修改/etc/apache2/conf-available/serve-cgi-bin.conf <IfDefine ENABLE_USR_LIB_CGI_BIN> ScriptAlias /cgi-bin/ /var/www/html/cgi-bin/ <Directory “/var/www/html/cgi-bin”> AllowOverride None […]
. Read more
dd bs=64k count=4k if=/dev/zero of=test oflag=dsync 执行命令以后，系统会自动创建一个268M的文件一般来说10M左右对VPS的一般应用无影响。10M以上性能可观。10M以下表示硬盘压力有点大，1M以下…… Hetzner 20O 2 vCPU 8 GB RAM 80 GB SSD DEDICATED VCPU (NVME SSD) 268435456 bytes (268 MB, 256 MiB) copied, 7.06485 s, 38.0 MB/s Reg.ru 23$ 2 vCPU 4 GB RAM 60 GB SSD 268435456 bytes (268 MB) copied, 7.82943 s, 34.3 MB/s Undergroundprivate 30$ 4 vCPU […]
. Read more
Debian 9 1.首先apache开启.htaccess： a2enmod rewrite apachectl -t -D DUMP_MODULES 查看是否有：rewrite_module 不行就修改httpd.conf Options FollowSymLinks AllowOverride None 改为 Options FollowSymLinks AllowOverride All 2. 添加.htaccess 文件 AddDefaultCharset utf-8 RewriteEngine on AddType application/octet-stream .mp3 .mp4 .pdf
. Read more
chrome_options = webdriver.ChromeOptions() chrome_options.add_argument(‘–proxy-server=socks5://localhost:1080’) browser = webdriver.Chrome(chrome_options=chrome_options) browser.get(‘http://myip.ms’)
. Read more
apt-get install pure-ftpd 8.添加ftp用户组 groupadd ftpgroup 9.增加ftp用户 useradd -G ftpgroup music 10.创建一个用户的上传目录 mkdir -p /data/music 11.添加一个pure-ftpd用户 pure-pw useradd music -u music -d /data/music 12.生成数据库文件 pure-pw mkdb 13.添加目录的用户权限 chown music /data/music 14.启动pure-ftpd pure-ftpd -j -lpuredb:/etc/pure-ftpd/pureftpd.pdb & ps -ef|grep pure-ftpd kill -9 xxx 这样你就可以顺利使用pure-ftp了， systemctl status apache2 /etc/apache2/sites-enabled 000-default.conf里面添加 <VirtualHost *:80> ServerName xxx.com DocumentRoot /var/www/html/d2 <Directory /> […]
. Read more
new_data=new_data.replace(‘\\’,’\\\\’).replace(‘”‘,’\\”‘).replace(“‘”,”\\'”) print(new_data)
. Read more
先下载安装 traits‑5.0.0‑cp35‑cp35m‑win_amd64.whl https://www.lfd.uci.edu/~gohlke/pythonlibs/#traits 然后pip install fitz
. Read more