# Error " ERROR 1146 (42S02): Table 'database.tablename' doesn't exist" after restoration

**URL:** <https://forums.percona.com/t/error-error-1146-42s02-table-database-tablename-doesnt-exist-after-restoration/2304>\
**Category:** Percona XtraBackup\
**Created:** [October 17, 2012, 5:01am UTC](https://forums.percona.com/t/error-error-1146-42s02-table-database-tablename-doesnt-exist-after-restoration/2304 "2012-10-17T05:01:55Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![karpagaraj](https://avatars.discourse-cdn.com/v4/letter/k/e19adc/32.png) [@karpagaraj](https://forums.percona.com/u/karpagaraj)\
**Post date:** [October 17, 2012, 5:01am UTC](https://forums.percona.com/t/error-error-1146-42s02-table-database-tablename-doesnt-exist-after-restoration/2304/1 "2012-10-17T05:01:55Z")

</div>

Hi ,

My problem is I restored successfully the full and incremental backup.Afer restoration, i checked the data consistency. This shows shows “ERROR 1146 (42S02): Table ‘databasename.tablename’ doesn’t exist” even the table is available.This error comes for only few databases.some database restoration and data consistency is good.(I found that I facing the table not exist error for the innodb tables.In myisam tables not have this issue)

kindly help me to get the solution.

Thanks  
raj

---

<div class="post-metadata">

**Author:** ![niljoshi](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/niljoshi/32/16889_2.png) [@niljoshi](https://forums.percona.com/u/niljoshi)\
**Post date:** [October 23, 2012, 4:56am UTC](https://forums.percona.com/t/error-error-1146-42s02-table-database-tablename-doesnt-exist-after-restoration/2304/2 "2012-10-23T04:56:36Z")

</div>

Hi Raj,

Looks like its data dictionary issue. Can you check again that ibdata and .frm files are restored properly? AFAIK, xtrabackup by itself didn’t copy the .frm files but innobackupex do it. Can you provide command line how you are restoring backup? If innodb\_file\_per\_table is enable then, are you getting .frm files in individual table dir?

---

<div class="post-metadata">

**Author:** ![karpagaraj](https://avatars.discourse-cdn.com/v4/letter/k/e19adc/32.png) [@karpagaraj](https://forums.percona.com/u/karpagaraj)\
**Post date:** [November 6, 2012, 9:13pm UTC](https://forums.percona.com/t/error-error-1146-42s02-table-database-tablename-doesnt-exist-after-restoration/2304/3 "2012-11-06T21:13:37Z")

</div>

Hi Niljoshi,

Thanks for your valuable reply.Yes I got solution for this.The mistake i was made that i have separate datadir for innodb files so i was mistakenly restored the ibdata file in wrong path.Now,its working fine.Thanks a lot niljoshi.

Thanks  
raj