LAMP is a stack of software that forms the basis of most websites on the Internet. It consists of a Linux distribution, Apache web server, MySQL database management system, and PHP server side scripting language.
mysql
MySQL backups with mysqlhotcopy
Previously I have written about MySQL backups using mysqldump. But there is another way to backup MySQL databases and that is by using a perl script included with MySQL called mysqlhotcopy. Things to note about mysqlhotcopy are:
Backup and restore MySQL databases
MySQL comes with a utility called mysqldump that allows you to take a backup of your MySQL database. It generates a text file containing SQL statements that you can use to recreate your database on any MySQL server.
Using a cron job to backup your MySQL Database
A cron job is a command that will run at a scheduled time. My website host allows me to set up cron jobs through the CPanel interface. Using a cron job I can automate MySQL database backups. Now a backup should always be placed on a different system to the one being backed up. I think a simple approach is to email myself the backup. So I use a cron job to backup my database. Its a series of piped commands. Continue reading