How To Back Up MySQL Databases With mylvmbackup On Ubuntu 8.10

Dec 26, 2008, 08:03 (0 Talkback[s])
(Other stories by Falko Timme)

[ Thanks to Falko Timme for this link. ]

"I'm assuming that MySQL is already set up and running on your system. The system must use LVM, and the MySQL data directory (/var/lib/mysql) should have an LVM partition of its own (althouth that is optional).

"If you have read Back Up (And Restore) LVM Partitions With LVM Snapshots you know that LVM snapshots require some unused LVM partition for the snapshot. My test system has a second, currently unused hard drive /dev/sdb that will be used by mylvmbackup to create a temporary logical volume for the backup."

Complete Story

Related Stories:

• MySQL, YourSQL, OurSQL(Dec 19, 2008)
• Administering MySQL Databases on the Web Using PHP(Dec 09, 2008)
• MySQL 5.1 Released With Crashing Bugs(Dec 03, 2008)
• Accessing Your MySQL Database from the Web with PHP(Nov 26, 2008)
• Check Your Mysql Server Performance with MySQLTuner(Nov 23, 2008)
• A Graphical Way to MySQL Mastery(Nov 22, 2008)