MySQL: Temporary failure in name resolution

September 8, 2015
MySQL

If your MySQL server is not responding, and you’re seeing a lot of these in your mysql logs: XXXXX XX:XX:XX [Warning] IP address ‘XXX.XXX.XXX.XXX’ could not be resolved: Temporary failure in name resolution Try adding the following: skip-host-cache skip-name-resolve to your my.cnf under [mysqld] then restart mysqld. That should address the issue!

Simple MySQL backup script

August 23, 2015
MySQL

Here’s a simple MySQL backup script to backup all of your databases at once (and then compress the backup with bzip2) to be used in a crontab: /usr/bin/mysqldump –all-databases | /usr/bin/bzip2 > /backup/mysql-`date +%Y-%m-%d`.bz2 Be sure to change the application paths as needed (you can use the application whereis for this purpose) and change the backup location to wherever you like.