Hello, I'm trying to restore a database from one server to another. I have done the following thus far.
The question is what am I missing? I've never used this tool before and read through the backup/restore procedures in the documentation, but it doesn't seem to give me any clue as to what I'm doing wrong. I would appreciate any help/direction you can give me. Thanks!
innobackupex --user=DBUSER --password=DBUSERPASS /path/to/BACKUP-DIR/ I move the backup file to the new server. I then try to prepare the backup with the data directory empty and I get this error:
[mysql@db1 2013-11-17_22-30-02]$ innobackupex --apply-log /home/mysql/backups/full_backup InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy and Percona Ireland Ltd 2009-2012. All Rights Reserved. This software is published under the GNU GENERAL PUBLIC LICENSE Version 2, June 1991. IMPORTANT: Please check that the apply-log run completes successfully. At the end of a successful apply-log run innobackupex prints "completed OK!". 131122 13:53:57 innobackupex: Starting ibbackup with command: xtrabackup_55 --defaults-file="/home/mysql/backups/full_backup/backup-my.cnf" --defaults-group="mysqld" --prepare --target-dir=/home/mysql/backups/full_backup --tmpdir=/tmp xtrabackup_55 version 2.1.4 for Percona Server 5.5.31 Linux (x86_64) (revision id: 656) xtrabackup: cd to /home/mysql/backups/full_backup xtrabackup: This target seems to be not prepared yet. xtrabackup: xtrabackup_logfile detected: size=2572288, start_lsn=(1280062692691) xtrabackup: using the following InnoDB configuration for recovery: xtrabackup: innodb_data_home_dir = ./ xtrabackup: innodb_data_file_path = ibdata1:10M:autoextend xtrabackup: innodb_log_group_home_dir = ./ xtrabackup: innodb_log_files_in_group = 1 xtrabackup: innodb_log_file_size = 2572288 xtrabackup: using the following InnoDB configuration for recovery: xtrabackup: innodb_data_home_dir = ./ xtrabackup: innodb_data_file_path = ibdata1:10M:autoextend xtrabackup: innodb_log_group_home_dir = ./ xtrabackup: innodb_log_files_in_group = 1 xtrabackup: innodb_log_file_size = 2572288 xtrabackup: Starting InnoDB instance for recovery. xtrabackup: Using 104857600 bytes for buffer pool (set by --use-memory parameter) 131122 15:18:55 InnoDB: The InnoDB memory heap is disabled 131122 15:18:55 InnoDB: Mutexes and rw_locks use GCC atomic builtins 131122 15:18:55 InnoDB: Compressed tables use zlib 1.2.3 131122 15:18:55 InnoDB: Initializing buffer pool, size = 100.0M 131122 15:18:55 InnoDB: Completed initialization of buffer pool InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 131122 15:18:55 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 131122 15:18:55 InnoDB: Error: all log files must be created at the same time. 131122 15:18:55 InnoDB: All log files must be created also in database creation. 131122 15:18:55 InnoDB: If you want bigger or smaller log files, shut down the 131122 15:18:55 InnoDB: database and make sure there were no errors in shutdown. 131122 15:18:55 InnoDB: Then delete the existing log files. Edit the .cnf file 131122 15:18:55 InnoDB: and start the database again. xtrabackup: innodb_init(): Error occured. innobackupex: Error: innobackupex: ibbackup failed at /home/mysql/percona-xtrabackup-2.1.4/bin/innobackupex line 416.