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...