How do you backup your mysql database so you can be sure that you are 100% protected of data loss whatever problems that may happen? I am thinking to rent one or two servers that i will use only for backup. Then i will setup rsync cron jobs that will do incremental backups daily to these two servers. Will this be enough? Do you use other methods than rsync to backup you database?


In my biased opinion (I'm author of TwinDB) the best way to take backups from MySQL is to use TwinDB. Not only it will save from blunders like rsyncing database files (which with 100% guarantee leads to corrupted tablespace) but also lets you take incremental copies correctly.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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