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

CLI – List of all MySQL command

by

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.

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

How to fix spotlight search on a macOS

by

Important: We have a current backup of your Mac.

Open Terminal:

Now type in the following commands into Terminal, in the exact order they are shown:

sudo mdutil -i off /
sudo mdutil -i on /
sudo mdutil -E /

The first command turns spotlight off
The second command turns spotlight back on
The final command restarts the spotlight index.
If, after a few minutes, spotlight is still not indexing, try running this command, followed by the three commands above:

sudo rm -rf /.Spotlight-V100

macOS not shutting down since upgrading to new security upgrade

by

Send this commands via terminal:

rm -rf ~/Library/Caches/*
rm -rf ~/Library/Saved\ Application\ State/*
sudo rm -rf /Library/Caches/*
sudo rm -rf /System/Library/Caches/*
atsutil databases -removeUser
sudo atsutil databases -remove
sudo atsutil server -shutdown
sudo atsutil server -ping
sudo rm -rf /var/folders/*

Reboot system.

How to change PhotoStation Synology logo

by

Login via ssh:

ssh -2 user@domain.tld
sudo -i

Copy Your logo white template:

cp /yourlogo.png /var/packages/PhotoStation/target/photo/photo_new/images/White/logo_ps6.png

Copy Your logo dark template:

cp /yourlogo.png /var/packages/PhotoStation/target/photo/photo_new/images/Black/logo_ps6.png