Automatic MySQL Backup

[stpvoice]

Hello,

I'm wondering if there's any way I can set up an automatic mysql backup for one of my databases to run once a day, probably in the night/early morning.

What do you guys use to do this?

Any ideas would be appreaciated-please be detailed, as I have no idea where to start.

 

[Zubair]

I used to done my backup with this Script Check it out. http://www.phpmybackuppro.net This may help you.

Currently I am using this http://www.debianhelp.co.uk/mysqlscript.htm

If you are using wordpress also try this http://www.tamba2.org.uk/wordpress/cron/

The details are written in length.

 

[stpvoice]

I looked at that, but am not completely sure how to set it up. Are you using a free account, as I know there are CPU restrictions that I'd rather not meddle with.

 

[Zubair]

Yes I am using free account and using this http://www.debianhelp.co.uk/mysqlscript.htm cron job.

It automatically take backup on mid-night every night. and email me my backups.