Code Snippets

Bash / Linux script to backup database to an SQL file with date | mysql

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

Published: Sun 24th December 2017
||COMMENTS|| This site proudly uses PrismJS to display code snippets

If you like this page, please share it.

Code Links - PHP, JS, CSS, Bootstrap, Bash, Emmet, IntelliJ, Sublime etc.

My personal list of links which I keep here publicly incase they help someone else one day.

Code Snippets

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.

My Github Repos

A work in progress. I am going to make as many modules that I write in my devbox public as possible.

Kit's Homepage

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

© 2018