Install macOS 10.15 using a bootable installer

    1. Get an external hard drive that has at least 12 GB of available storage and plug it in your Mac.
    2. Launch the Disk Utility app and erase your hard drive selecting Mac OS Extended format.
    3. Open Terminal (Applications > Utilities).
    4. Paste this command and press Enter:
  1. sudo /Applications/Install\ macOS\ Catalina.app/Contents/Resources/createinstallmedia --volume /Volumes/MyVolume
  2. If prompted, enter your administrator password and press Enter again.
  3. When Terminal says “done”, your hard drive should have the same name as the installer you downloaded (for example, Install macOS Catalina).
  4. Open System Preferences > Startup Disk. Choose your bootable installer as a startup disk and press Restart.
  5. Your Mac should start up to macOS Recovery.
  6. Make sure your Mac has an internet connection to download firmware updates (you can use the Wi-Fi menu in the menu bar).
  7. In the Utilities window, select Install macOS.
  8. Your Mac will then start installing macOS Catalina and will restart when it’s done.

Syn – 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

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 fix spotlight search on a macOS

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