mds1256 Posted January 29, 2012 Share Posted January 29, 2012 What is the best way to backup a MySQL database which has 24 hours access to clients. With ms SQL I have setup maintenance plans that do a full backup every night and creates logs every hour. This would allow me to restore database Up to a certain point and could even look at the logs and use them to rebuilt to that point in time if I needed to. I need to do this on a MySQL server and I know you can use mysqldump but how can I get it to backup nightly and create logs ever hour? Any good software for setting these up, on a windows environment. Link to comment https://forums.phpfreaks.com/topic/255987-mysql-backup-cron-job-but-also-logs/ Share on other sites More sharing options...
fenway Posted January 30, 2012 Share Posted January 30, 2012 Replication. Link to comment https://forums.phpfreaks.com/topic/255987-mysql-backup-cron-job-but-also-logs/#findComment-1312619 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.