Backup MySQL Database Daily and Keep for 7 days

Here is a script I quickly wrote to mysqldump a single database and keep 7 days worth of backups. #!/bin/bash # Script – mysqlbackup.sh # Created by Jordansphere – 20/Jun/13 DATADIR=”/home/mysqlbackups” USERNAME=username PASSWORD=password NOW=$(date +”%d-%m-%Y”) #BACKUP DATABASE in date format (eg “MyDatabase-20-6-2013.sql”) /usr/bin/mysqldump -u $USERNAME -p$PASSWORD –databases MyDatabase > /home/mysqlbackups/MyDatabase.$NOW.sql # REMOVE BACKUPS MORE THAN Read More…

Flash LEDs on Equallogic via CLI

If you want to flash the LEDs on an Equallogic array whilst plugged into the Serial port (or via SSH/Telnet) then run these commands   When on the CLI: # member show This will output the member(s) information Name                 Status Version Disks Capacity FreeSpace Connections ——————– ——- Read More…