Km.Van kmvan

SERVER

[Service]
ProtectHome=false

	<?php

	/**
	* Get the average pixel colour from the given file using Image Magick
	*
	* @param string $filename
	* @param bool $as_hex Set to true, the function will return the 6 character HEX value of the colour.
	* If false, an array will be returned with r, g, b components.
	*/
	function get_average_colour($filename, $as_hex_string = true) {

	ssl_certificate /etc/letsencrypt/live/DOMAIN/fullchain.pem;
	ssl_certificate_key /etc/letsencrypt/live/DOMAIN/privkey.pem;

	if ($scheme = http) {
	return 301 https://$server_name$request_uri;
	}

	if ($host != DOMAIN) {
	return 301 $scheme://DOMAIN$request_uri;
	}

	<!DOCTYPE html>
	<html lang="en">

	<head>
	<meta charset="UTF-8">
	<meta name="viewport" content="width=device-width, initial-scale=1.0">
	<meta http-equiv="X-UA-Compatible" content="ie=edge">
	<title>FontAwesome 预览页面 - INN STUDIO</title>
	<link rel="stylesheet" href="https://fontawesome.inn-studio.com/releases/v5.9.0/css/all.css">
	<style>

	mysqldump是mysql官方机型逻辑备份的工具，作用非常多，可以进行全量备份，结合binlog还以做增量备份，也是做从库的利器，正确理解它非常有用。

	今天列举我目前比较关心的几个点。

	1：是否要锁表

	默认的情况下它是锁表的，相当于调用—add-locks参数，在每个表备份前后增加LOCK TABLES和UNLOCK TABLES语句，这样数据库表就只读了。

	去年我做副库的时候，以防万一，喜欢调用FLUSH TABLES WITH READ LOCK语句，让全库只读，实际上增加—lock-all-tables即可。

	git rm -r --cached .
	git add .
	git commit -m "ignore take effect"

	location / {
	try_files $uri $uri/ /index.php?$args;
	}
	rewrite /wp-admin$ $scheme://$host$uri/ permanent;

	update mysql.user set plugin='mysql_native_password' where user='root';
	update mysql.user set password=password("pwd") where user='root';
	FLUSH PRIVILEGES;