How do I set up a cronjob to work with PHP or Shell Scripts

Feb 24, 2019
A cronjob is a program that is set up to run according to a pre-determined schedule. It can be used to execute a PHP application or a shell script (#!/bin/sh, #!/bin/csh, etc). The examples I give here should work on a Linux, UNIX, BSD operating system. In my crontab I add the followin Continue reading...

Use 'tr' in a shell script to translate text case

Feb 24, 2019
This tip is applicable to UNIX / Linux operating systems 'tr' is a command line utility which you can use to convert text to UPPER or lower case. To convert all the letters of the English alphabet found in a string to lower case do this at the UNIX command line: % sh (to switch to bou Continue reading...

Configure a backup routine for both your file system and database on a hosted website

Feb 24, 2019
Question: Why set up a custom backup (dump) routine on my website? Answer: Web hosting provider commonly run backups, but they may be infrequent and depending on the age, may be stored offsite.  If you configure your own backups you can probably restore a file s Continue reading...

Shell script to delete multiple MySQL tables matching a pattern

Feb 24, 2019
MySQL doesn't have a core function to delete multiple tables matching a pattern.  This is a simple script that you configure, then run command-line to delete multiple tables matching a pattern.  Be careful to ensure that the pattern will not also match database you do not wish to delete. Continue reading...
close sidebar container