This is testing on Debian Lenny with MySQL 5.0 installed. Configured with innodb_file_per_table. OK… we have a test dbmail database that contains all InnoDB tables and some data.
A couple of questions:
- Did i get this correct? Performing this as root:
innobackupex-1.5.1 --user=root --password=‘password’ --databases=“dbmail” /mnt/backup/
innobackupex-1.5.1 --apply-log /mnt/backup/2010-09-21_12-58-16/
(deleted the /var/lib/mysql/dbmail directory)
innobackupex-1.5.1 --copy-back /mnt/backup/2010-09-21_12-58-16/
I then had to manually set the user permissions on the /var/lib/mysql/dbmail and ibdata1, ib_logfile0, ib_logfile1 files before starting mysql again. Should i be running this as “mysql”
- Our live dbmail database is approx 40GB. If i run innobackupex-1.5.1 on this, it will NOT be locked thruout the course of the backup right? e.g. users (dbmail) will still have full access to the tables? (i would like to perform this so i cal restore onto a new server for testing first.