This is the script to automatically backup MySQL database using hosting cron feature and PHP.
For details and tutorials regarding the implementation,please refer to Developer Shed/Codewalkers/Web hosting tutorial. Link here:
DevShed tutorials
Codewalkers tutorials
Web hosting tutorials
And look for the related article (e.g. Backup and Restoring MySQL Database) on this topic that I wrote (author:Codex-m).
Summarized steps:
1.) Download script and configure connection parameters.
2.) Upload folder to server. It is recommended it should be above public_html folder (also known as “www” folder or “html” folder). The primary reason is to deny public access to the folder.
3.) Configure cron.
4.) Troubleshoot if necessary and download the MySQL database file.
Important: Use the following file permissions in your Linux server
1.) .htaccess – 644
2.) cronmysqlbackup folder – 755
3.) cronmysqlbackup.php -755
Requirement:
1.) Linux
2.) PHP 5
3.) MySQL database 5.0
4.) Apache web server
5.) Paid hosting account (php function such as system are enabled).
Note: You cannot use this script under free hosting accounts. Also refer to the cronmysqlbackup.php script for detailed procedure (commented on the script).
I found this site looking for backup tools. I use the phpMyAdmin interface all the time and I wanted to automate this. Unfortunately I don’t have the right permissions to run this script on the server but I found this tool MySQLBackupFTP (http://mysqlbackupftp.com) that can connect to MySQL through phpMyAdmin and backup the database.
It has a free version that compress your backup and allows you to send it to a remote FTP server.
If you have permission problems like I did, you may want to give this tool a try.
thanks a bunch for the script. Now I do not have to backup things my self every night
_
That’s great, me too before I always do backup using the control panel or PHPmyAdmin interface. Now I simply go to the backup folder in the SSH server and directly download the MySQL database backup. Very simple!
Very good, this has helped a lot.
Great website by the way.
Youri