[all variants] Backup and restore MySQL innoDB databases

view story

http://ubuntuforums.org – Hi everyone. I recently setup a Ubuntu 12.04 LAMP Server at home that I use to develop websites in corporation with clients. I've been using Ubuntu and other Linux distros for a few years, but I am new to servers and have been learning a lot. Especially about MySQL as I know nothing about it. I am currently in the process of refining/rethinking my backup procedure, and I am having a problem figuring out how to backup the MySQL database, and I hope you can help me. Both the MySQL data directory (/var/lib/mysql) and Apache root directory (/var/apache2) reside on /var, which is a LVM Log (Hardware)