Percona innobackupex restoring problem

MySQL & MariaDB Percona XtraBackup
1

Hi All,
I have a problem while restoring my full backup using innobackupex, below are the steps which i am doing.

  1. innobackupex --user=root --password=test123 /data/backup/innobackupex/Full/

  2. innobackupex --apply-log --redo-only /data/backup/innobackupex/Full/2014-07-03_14-39-24/

  3. /etc/init.d/mysql stop

removing files from mysql data dir…

  1. rm -rf /data/mysql/data/*

restoring backup to datadir (/data/mysql/data)

  1. innobackupex --copy-back /data/backup/innobackupex/Full/2014-07-03_14-39-24/

  2. chown -R mysql:mysql /data/mysql/data/

  3. /etc/init.d/mysql start

Upto this everything is perfect. I didn’t get any error. successfully started mysql…

but no data available on my database…The error is below while checking the tables…

mysql> select * from db.User1;
ERROR 1146 (42S02): Table ‘db.User1’ doesn’t exist

Can anyone help me here…?
Thanks in advance…

2

What do “ls -l /data/mysql/data” and “ls -l /data/mysql/data/db” show? Btw, when you prepare a full backup, it is better to leave out --redo-only and allow the prepare step to rollback uncommitted transactions. And so it would save time to start up the server on the prepared data.

3

Hi psong,

It works fine after leaving (–redo-only) while preparing full backup…

Thanks a lot. :slight_smile: