A Byte Of Excellence
There are many occasions where we want to schedule a .sh script to run at set intervals. I use this primarily for running backups every day of various amazon EC2 servers so that they are backed up to S3 on a nightly basis.
crontab -e
(if it is the first time running this, press 1 to use nano)
0 0 * * * bash /home/ubuntu/scripts/myscriptfile.sh to >/dev/null 2>&1
This means that the script file will run at midnight every night.
Need a quick .sql file to create a list of all languages of the world, but don’t want to type them all in from Wikipedia? Here is the solution!
MySQL Version:
settingsLanguages.sql (this is in a .zip file to ensure that it can be downloaded through browser security settings)
How to select rows from a table where a field contents are all in UPPERCASE
SELECTfieldNameFROMtableNameWHEREfieldName REGEXP BINARY ‘^[A-Z]+$’