Code

Syn – config automysqlbackup

by
Config Automysqlbackup 

config automysqlbackup.conf
edit  automysqlbackup and set /path/to/automysqlbackup.conf

MySQL aliases
Instead of extending the path variable, you can create a symbolic link to mysql, mysqldump, mysqlshow
cd /usr/local/bin

sudo ln -s /volume1/@appstore/MariaDB10/usr/local/mariadb10/bin/mysql /usr/local/bin/mysql
sudo ln -s /volume1/@appstore/MariaDB10/usr/local/mariadb10/bin/mysqldump /usr/local/bin/mysqldump
sudo ln -s /volume1/@appstore/MariaDB10/usr/local/mariadb10/bin/mysqlshow /usr/local/bin/mysqlshow
reference:

MySQL – change the collation for database and all table columns

by

Changing the collation for a table will only set the collation for the next column that’s added. To change all of the existing columns to the new collation :

ALTER TABLE tablename CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci

ALTER DATABASE dbname COLLATE utf8_general_ci

Configuring Automatic Background Updates – WordPress

by

Update Types

Automatic background updates were introduced in WordPress 3.7 in an effort to promote better security, and to streamline the update experience overall. By default, only minor releases – such as for maintenance and security purposes – and translation file updates are enabled on most sites. In special cases, plugins and themes may be updated.

Read more

WordPress auto update config

by

1. disable FTP commands from config.php
2. add to config.php

// Update core
define( 'WP_AUTO_UPDATE_CORE', true );

optionally for Synology NAS

# reset chown for Synology user nobody
chown -R nobody:nobody /web/wordpress/dir

# reset files and folders chmod in /web/wordpress/dir
find . -type f -exec chmod 0644 {} \;
find . -type d -exec chmod 0755 {} \;