Articles with tag «mysql»

Worthless Backups

How good are your backups?

I thought mine were pretty dang good. I found out otherwise. I had the following two lines running nightly for my backups.

# Make MySQL backup

mysqldump -u root -p "$(/.sql.pwd)" --all-databases | gzip > /var/mysqldump/mysql-$(date +%F).gz

# Delete old copies

find /var/mysqldump …