3

News: How To Back Up MySQL Databases With mylvmbackup On Debian Lenny

view full story
linux-howto

http://www.raiden.net – mylvmbackup is a Perl script for quickly creating MySQL backups. It uses LVM's snapshot feature to do so. To perform a backup, mylvmbackup obtains a read lock on all tables and flushes all server caches to disk, creates a snapshot of the volume containing the MySQL data directory, and unlocks the t ... (Distributions)

ziyi's picture
Submitted by ziyi on 02/05/2010 – Made popular on 02/05/2010

Stories similar to News: How To Back Up MySQL Databases With mylvmbackup On Debian Lenny

How To Back Up MySQL Databases With mylvmbackup On Debian Lenny

How To Back Up MySQL Databases With mylvmbackup On Ubuntu 12.10 mylvmbackup is a Perl script for quickly creating MySQL backups. It uses LVM's snapshot feature to do so. To perform a backup, mylvmbackup obtains a read lock on all tables and flushes all server caches to disk, creates a...

mylvmbackup is a Perl script for quickly creating MySQL backups. It uses LVM's snapshot feature to do so.

Our mysql ibdata1 file was deleted earlier today. This wasn't noticed until mysqld was restarted and there was no data in the tables. The machine is a CentOs VM in Xenserver. At this point a snapshot was taken. Then the mysql database was dropped and restored from a backup.

Creating MySQL Backups With AutoMySQLBackup On Ubuntu 9.10

AutoMySQLBackup is a shell script that lets you take daily, weekly and monthly backups of your MySQL databases using mysqldump. It can back up multiple databases, compress the backups, back up remote databases, and email the logs. This tutorial explains how to install and use it on an Ubuntu 9.10 server.

Normally when we create a backup of our MySQL using Mysqldump it creates a Read Lock on the database, so no changes can be made to the database at that time. It may take from a second to few minutes to take up backup of your database. So, sysadmin either prefer to stop MySQL or issue a READ lock on the MySQL table, so that database remains consistent.

I've got a Windows Server and I get Windows Server Backup to backup all the files every day. I don't however have a system image so I cannot use that.

I've tried just copying the database files into the MySQL Data folder, but most/all of the tables are missing (wordpress). Is there any other way I could recover this data?

I believe it was using InnoDB.

We've got a Virtual Server with full ssh and root access running LAMP on Ubuntu Server.

I've got a small computer in the office running ubuntu that isn't being used for anything. I thought I should use it to make and store (a copy of) our MySQL database backups.

cpanel: mysql database size 0MB 2 years 47 weeks ago

You may see the mysql database size as zero in cPanel >> ‘Mysql Databases’ option, though the databases contains tables and data. In order to include the size of the databases while displaying disk usage in cPanel/WHM, perform either of the following steps: 1) SSH to your server as root and edit the cpanel.config file # pico [...]

After a recent 'emergency migration' of a RS cloud server, the mysql databases on our server snapshot image proved to be days out of date from the backup date. And yet files that were uploaded through the impacted webapp had been written to the file system.