How to Automate your MySQL database backups
/* Posted May 5th, 2008 at 11:00am [Comments: none] *//* Filed under PHP, Programming */

for automating backups, you can use this: http://www.mysqldumper.de/en/
\or you can run this automatic script
Here’s an essential automatic script and a cron job you will need in order to keep your backup automatic.
Yes, if you get a dedicated server, don’t get their stupid extra $15/month for backing up your database. (All they do is make scripts like this one and charge you for it)
You can follow this example and go spend that money on junk food.
So all you have to do is FTP your backup files.
This is way better than going into your phpMyAdmin and downloading from the web interface since the file is already ready for you to download.
Here’s how you do it:
1) Make a new file called backup.sh in your home directory. 2) Use the following syntax:












