Jump to content

Archived

This topic is now archived and is closed to further replies.

Mouse

automatically back up my database

Recommended Posts

Dear all…

Ok so I’ve just about got the PHP thing under control and the JavaScript (so I can learn Ajax next) is coming along… so the next thing I need to sort out is a bit of backing up of MySQL.

Short of manually backing up my database each evening (hard to do as I am away a lot and the wife does like to see me occasionally) with a dump file via my host’s poor PHPMyAdmin, - or trusting them to do it correctly…

Question:
Is there a script / program / magic bit of hocus-pocus that will automatically back up my database and perhaps mail it to me every 24 hours or so?

Answer: … over to you!

Many thanks

Mouse

Share this post


Link to post
Share on other sites
Well, mysqldump will export your DB, but you have to write a script that will execute it... MySQL 5.1 has an event scheduler, though I've never used it.  CRON is the way to go, for now.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.