Is it possible to use a macro to create a database backup onto a harddrive with a program such as MySql-Front?
My host performs daily backups which overwrite the previous day's backup which is great as peace of mind. The only problem is if the database becomes corrupt damaged or messed up just prior to the back up being performed, the previous 'good one' will be overwritten by the damaged one.
What I would like to do is to use a program to perform a weekly backup to my harddrive in the early hours when the forum is quieter just to be extra safe. Unless there's another way round it..?
Do you have access to the server itself or are you on a shared hosting package?
If you're using Access you could download the database or if you're using SQL server you may be able to back it up by copying it to MSDE locally. You could possibly do the same using MySql-Front to backup a MySql database to a local one running on your own machine. You could also use it to dump an sql file.
I currently use MySql-Front but have to dump the database manually, I would like to be able to set a program to run the dump at a predetermined time on a weekly basis automatically
I'd suggest taking a look at using SQLYog instead of MySQL-Front, it's a better all around package imo and it has a job scheduler that you may be able to use to do what you want
Topic Locked
Posted - 14 September 2004 : 17:06:49
