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. Quote Link to comment Share on other sites More sharing options...
fenway Posted January 30, 2012 Share Posted January 30, 2012 Replication. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.