Using a cron job to backup your MySQL Database

Abdussamad.com

Using a cron job to backup your MySQL Database

Comments

Jackie
1
*Thank you! This is the first time I have found how to do a cron job which will email me the results. Always seemed really silly to have it back-up on the same server. If that crashes you loose your back-up too! Now it emails me. Thanks again.
*Your explanation is clear and works well, thank you for your script and I wait continue forward with your blog.

Thank you again.
Rupak
3
*Does it holds good with large size database.
Abdussamad Abdurrazzaq
3.1
*Yes it will work with any size database
Kenny
4
*Hey, this is the first set of info that has gotten me even remotley close to my target of backing up the database and emailing it to myself, the only problem is, it sends a file that is only 25KB, and has no data inside the GZip file

my Cron Deamon says
mysqldump : not found

when i export the same database through phpMyAdmin the file is close to 13 megs. Am i doing something incorrect? for the user do i use the MySql Database user? or my Cpanel login user? i;ve tried both, but somehting just oesnt seem to work.

thank you
please feel free to Email me if you can help me at at
slayer at idolcreations dot com
Abdussamad Abdurrazzaq
4.1
*Try using /usr/bin/mysqldump instead of just mysqldump. Very strange that mysqldump is reported to not exist. You could also ask your webhost for assistance with this.

Add Comment


Standard emoticons like :-) and ;-) are converted to images.
E-Mail addresses will not be displayed and will only be used for E-Mail notifications

To prevent automated bots from comment spamming, please enter the letters or numbers you see in the image below in the appropriate input box.
CAPTCHA




RSS feed
animated rss feed icon
Quicksearch
Links
My other blogs

Website Themes