After installing certbot:
sudo service nginx stop
sudo ./certbot-auto certonly --standalone -d sub.example.com --standalone-supported-challenges http-01
sudo service nginx start
Modified the ngnix site conf:
server {
listen 80;
After installing certbot:
sudo service nginx stop
sudo ./certbot-auto certonly --standalone -d sub.example.com --standalone-supported-challenges http-01
sudo service nginx start
Modified the ngnix site conf:
server {
listen 80;
zfs list -r -H -t snapshot -o name stream/lxc/stash | xargs -n1 zfs destroy |
# For each database: | |
ALTER DATABASE database_name CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci; | |
# For each table: | |
ALTER TABLE table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; | |
# For each column: | |
ALTER TABLE table_name CHANGE column_name column_name VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; | |
# (Don’t blindly copy-paste this! The exact statement depends on the column type, maximum length, and other properties. The above line is just an example for a `VARCHAR` column.) |
#!/usr/bin/env ruby | |
# Converts an InnoDB database that uses a shared InnoDB tablespace file (e.g. ibdata1) to use | |
# a separate file per table. | |
# | |
# - First change your my.cnf file to use separate files by adding "innodb_file_per_table" to | |
# the [mysqld] section. (This is safe: MySQL will revert to the giant file if it cannot find | |
# the per table file.) | |
# - Restart the MySQL server | |
# - cd to the directory of your database (cd /opt/mysql/data/mydb) |