Percona innobackupex restoring problem

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…

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.

Hi psong,

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

Thanks a lot. :slight_smile: