Sandeep Ghael

In the previous post, I provide a backup script for PostgreSQL. As promised, here is the same script written for MySQL. Below are the setup instructions. Copy the contents below into a file named mysql-backup.sh placed in the root account home (on Ubuntu it’s ‘/root’). For simplicity, I’m using the root account, but on your [...]

Somethings never change. Needing to backup data is one of those things. Since webapps are constantly in development, and new features often means changes to the database schema, I find it super useful (and comforting) to do hourly backups of my applications database. If I make some boneheaed mistake, at most I’ll only lose 1 [...]