Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

someone Know and can recommend me an open source program or freeware software to realize automatics backups in mysql under windows server 2003.

I need automatize a task every day.

A shareware program for that is http://www.freedownloadscenter.com/Utilities/Backup_and_Copy_Utilities/MySQL_Auto_Backup.html, but I need a freeware version.

thare are any option?? thanks a lot.

share|improve this question

closed as off topic by sysadmin1138 Aug 9 '12 at 17:04

Questions on Server Fault are expected to relate to professional server, networking, or related infrastructure administration within the scope defined by the community. Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope. Read more about reopening questions here.If this question can be reworded to fit the rules in the help center, please edit the question.

    
Product and service recommendations are off topic per the updated FAQ. –  sysadmin1138 Aug 9 '12 at 17:04
add comment

2 Answers

up vote 1 down vote accepted

Yes, there's lots of options. But you've not really provided a lot of information about what you are trying to achieve, e.g. do you have a requirement to write the backup to something other than a conventional filesystem?

To minimise downtime (if that's important) you might consider running master-slave replication, and running the backup from the slave (which could reside on the same physical server) or keeping the data on a mirrored disk set, breaking the mirror and starting a secon instance of mysql to run the backup from (although this will break the files if you don't stop the database before breaking the mirror). But that doesn't really address of how you get the data out of the DBMS.

What are your objectives here? What sort of backup do you want? The quickest solution would be to grab images of the datafile - which only requires that the DBMS is shutdown to get a consistent image - then any file copying tool will work. If you have a huge amount of data then you might want to do incremental backups - in which case you might just configure a replication log and back up the replication logs relative to some datum.

OTOH if you want to extract the data and schema, then mysqldump comes as standard with mysqld. There's details of how to run it within a MSWindows batch file in the comments in the manual

Remember that backups are useless unless you regularly test that you can restore the data.

share|improve this answer
    
thanks, is a backup of small, but important mysql database, the solution i guess is to use mysqldump with task scheduler and the with DATAPROTECTOR up the information to tape. –  Mak Oct 22 '10 at 16:41
    
about this : "To minimise downtime (if that's important) you might consider running master-slave replication, and running the backup from the slave (which could reside on the same physical server)" where can i find more information" –  Mak Oct 22 '10 at 16:42
1  
The manual ? dev.mysql.com/doc/refman/5.0/en/replication.html –  symcbean Oct 25 '10 at 8:04
1  
Google? forge.mysql.com/wiki/Replication/Tutorial –  symcbean Oct 25 '10 at 8:04
add comment

MySQL Administrator, part of the ole MySQL GUI Tools Bundle, will let you do this.

Alternatively, you could write a simple batch file that uses mysqldump, and use the Windows Task Scheduler to automate it. An example batch file can be found here.

share|improve this answer
    
thanks for your information, I read more about that tool. –  Mak Oct 22 '10 at 16:43
add comment

Not the answer you're looking for? Browse other questions tagged or ask your own question.