Writes a raw, non gzipped .sql file with the date and time - it's a good idea to have this on a cron. I use this even though I use AWS RDS snapshots. Assumes it is installed in /usr/bin. Do a WHEREIS if you don't know where it is. Do a yum install mysql if you don't have mysql installed.
/usr/bin/mysqldump -h DBHOST -uUSERNAME -pPASSWORD --opt DBNAME > /var/app/current/_backup/`date +%d_%m_%y`_DBDUMP.sql # note - no space between -u and -p
My personal list of links which I keep here publicly incase they help someone else one day.
Snippets of PHP code I have gathered over the years. I keep them here for my own repository but also to share with others. I always link back when I remember the source.
This site was originally intended as a test bed for code. It now includes my blog about business and powerlifting, as well as games for Spanish language learning