Doing database backups for MySQL can be as simple as commandline dumps, but complex deployments can make things well, very complicated. This guide on bulletproof MySQL backups can be very helpful if you think you’ll be going into the complex type of deployments.