Synology – config Automysqlbackup

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:

Postfix Queue commands

Goal: To find which mails are stuck in mail queue and why?

If emails are getting delayed, its better to inspect postfix mail queues, coupled with postfix mail log.

Read more

Protected: streaming-rpl

This content is password protected. To view it please enter your password below:

MySQL – change the collation for database and all table columns

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

CLI – List of all MySQL command

List of all MySQL commands:
Note that all text commands must be first on line and end with ‘;’

?         (\?) Synonym for `help'.
clear     (\c) Clear the current input statement.
connect   (\r) Reconnect to the server. Optional arguments are db and host.
delimiter (\d) Set statement delimiter.
edit      (\e) Edit command with $EDITOR.
ego       (\G) Send command to mysql server, display result vertically.
exit      (\q) Exit mysql. Same as quit.
go        (\g) Send command to mysql server.
help      (\h) Display this help.
nopager   (\n) Disable pager, print to stdout.
notee     (\t) Don't write into outfile.
pager     (\P) Set PAGER [to_pager]. Print the query results via PAGER.
print     (\p) Print current command.
prompt    (\R) Change your mysql prompt.
quit      (\q) Quit mysql.
rehash    (\#) Rebuild completion hash.
source    (\.) Execute an SQL script file. Takes a file name as an argument.
status    (\s) Get status information from the server.
system    (\!) Execute a system shell command.
tee       (\T) Set outfile [to_outfile]. Append everything into given outfile.
use       (\u) Use another database. Takes database name as argument.
charset   (\C) Switch to another charset. Might be needed for processing binlog with multi-byte charsets.
warnings  (\W) Show warnings after every statement.
nowarning (\w) Don't show warnings after every statement.

How to find all files containing specific text on Linux?

Do the following:

grep -rnw '/path/to/somewhere/' -e 'pattern'

-r or -R is recursive,
-n is line number, and
-w stands for match the whole word.
-l (lower-case L) can be added to just give the file name of matching files.

Along with these, –exclude, –include, –exclude-dir flags could be used for efficient searching:

This will only search through those files which have .c or .h extensions:

grep --include=\*.{c,h} -rnw '/path/to/somewhere/' -e "pattern"

This will exclude searching all the files ending with .o extension:

grep --exclude=*.o -rnw '/path/to/somewhere/' -e "pattern"

For directories it’s possible to exclude a particular directory(ies) through –exclude-dir parameter. For example, this will exclude the dirs dir1/, dir2/ and all of them matching *.dst/:

grep --exclude-dir={dir1,dir2,*.dst} -rnw '/path/to/somewhere/' -e "pattern"

For more options check man grep

Configuring Automatic Background Updates – WordPress

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