Command Line

Set Up SFTP Chroot Jail using OpenSSH

By Mike Goh July 29, 2022Developers Technical TutorialsCommand Line, SecurityNo Comments

Introduction You may want to use one of your existing servers as a SFTP server without subscribing to another EC2 instance. Or you would like to have multiple SFTP users/vendors on a single SFTP server to save on resources and…

Bash Script Backup MySQL Databases

By Mike Goh June 10, 2021Developers Technical TutorialsBackup, Command LineNo Comments

Introduction Back in the good old days, when Git was not invented, database administrators will use a bash script to backup their MySQL databases periodically. This method is not true anymore because GitHub, GitLab and Bitbucket provide free plans and…

Automated Checks: Send Email when Product in Stock

By Mike Goh June 29, 2020Daily Rants and Excitement BlogCommand Line, EmailNo Comments

Introduction Have you ever wanted to buy that pretty dress or gadget really bad but disappointed at it being currently out of stock? Then, you check the listing once every few hours in hope to snap it up when it…

Bash Script to Sync WordPress Docker Production to Demo

By Mike Goh June 6, 2020Developers Technical TutorialsCommand Line, Docker, WordPressNo Comments

Introduction After we had upgraded a website from development to production status, we will need to put up a maintenance notice if we are required to make further changes. It is unpleasant to let visitors see the down-time or on-going…

How to Resolve iptables: No chain/target/match by that name

By Mike Goh April 24, 2020Developers Technical TutorialsCommand Line, SecurityNo Comments

Introduction If you encounter such error, it means that the CONFIG_NETFILTER module was not complied in your kernel. All VPS (virtual private server) that I owned from DigitalOcean, AWS, Google Cloud and other lesser-known host providers have it by default…

How to Backup Databases and Files, Rotate and Rsync to Remote

By Mike Goh April 19, 2020Developers Technical TutorialsBackup, Command LineNo Comments

We should always schedule backups for our website files and databases but should never keep the backups only in the server which your websites and databases reside in. If you are on solid cloud providers like Amazon Web Services (AWS)…

How to Make ‘docker-compose’ Short and Quick Using Aliases

By Mike Goh April 12, 2020Developers Technical TutorialsCommand Line, DockerNo Comments

Have you at times need to type docker-compose repeatedly to bring containers up and down or to check processes while in development? Here is a neat trick to shorten docker-compose to just 2 letters dc. This is a one-time change…

Set Up SFTP Chroot Jail using OpenSSH

Bash Script Backup MySQL Databases

Automated Checks: Send Email when Product in Stock

Bash Script to Sync WordPress Docker Production to Demo

How to Resolve iptables: No chain/target/match by that name

How to Backup Databases and Files, Rotate and Rsync to Remote

How to Make ‘docker-compose’ Short and Quick Using Aliases

How to Resolve iptables: No chain/target/match by that name

Asus Router Setup – Wifi Settings

Create Helpdesk Ticketing System with Google Apps Script

Host Multiple Websites with jwilder nginx-proxy and letsencrypt-companion