What's the best way to back up a MySQL server? I would like a method that doesn't require bringing down the server. Is something like InnoDB hot backup necessary, or can I just use the backup tools provided in the MySQL Administrator tools. What advantages does one offer over the other?
MySQL – How to Backup MySQL Server
backupMySQL
Related Topic
- Mysql – Recovering a MySQL database when the thesql server will not start
- Mysql – Looking for the best way to backup Mysql
- Mysql – Whats the best practice for defragmenting a MySQL InnoDB table in production
- Linux – Dedicated server automatic backup solution
- MySQL – Backing Up MySQL Database via ZFS Snapshots
Best Answer
We use mysqldump, which works while MySQL is running. We started using mysqldump because it was the easiest to set up when our needs were small, and it seemed to meet those needs. Our databases have grown since then, but we haven't yet outgrown mysqldump. Whether it suits you will depend on the size of your databases, their usual operating load, and probably a bunch of other things.