XtraBackup question regarding usage

  • Filter
  • Time
  • Show
Clear All
new posts

  • XtraBackup question regarding usage

    Hi There,

    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:

    1) 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"

    2) 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.