# ERROR 1146 (42S02): Tablespace doesn't exist after Xtrabackup Restore

**URL:** <https://forums.percona.com/t/error-1146-42s02-tablespace-doesnt-exist-after-xtrabackup-restore/8212>\
**Category:** Percona XtraBackup\
**Created:** [October 29, 2020, 5:20pm UTC](https://forums.percona.com/t/error-1146-42s02-tablespace-doesnt-exist-after-xtrabackup-restore/8212 "2020-10-29T17:20:29Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Supriya](https://avatars.discourse-cdn.com/v4/letter/s/5f8ce5/32.png) [@Supriya](https://forums.percona.com/u/Supriya)\
**Post date:** [October 29, 2020, 5:20pm UTC](https://forums.percona.com/t/error-1146-42s02-tablespace-doesnt-exist-after-xtrabackup-restore/8212/1 "2020-10-29T17:20:29Z")

</div>

I had 1.4 Tb of mysql database which I migrated over network using streaming and compression.

On Source-- Mysql 5.6

On Destination – MySQL 5.7

I followed below steps.

On Old Server

==============

sudo innobackupex --user=MYSQL-USER --password=MYSQL-PASSOWORD --stream=xbstream --compress --compress-threads=3 --parallel=4 . | ssh -T -o Compression=no testus@DEST-HOST ‘cat - \> /data/full/backup.xbstream’

On New Server

==============

xbstream -x \< backup.xbstream -C /data/backup/

cd /data

mkdir mysql

sudo chown mysql.mysql mysql -R

sudo chmod 775 mysql -R

mv backup/\* mysql/.

xtrabackup --decompress --parallel=12 --remove-original --target-dir=/data/mysql

xtrabackup --prepare --apply-log --use-memory=100G --target-dir=/data/mysql

sudo chown mysql.mysql /data/mysql -R

Started Mysql 5.7 and did mysql.upgrade

I got error for my partitioned table as follows.

mysql\> show create table table1;

ERROR 1812 (HY000): Tablespace is missing for table `new`.`table1`.

---

<div class="post-metadata">

**Author:** ![Marcelo\_Altmann](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/marcelo_altmann/32/11299_2.png) [@Marcelo\_Altmann](https://forums.percona.com/u/Marcelo_Altmann)\
**Post date:** [October 30, 2020, 5:15am UTC](https://forums.percona.com/t/error-1146-42s02-tablespace-doesnt-exist-after-xtrabackup-restore/8212/2 "2020-10-30T05:15:28Z")

</div>

Hi Supriya,

Please share the logs of backup/decompres/prepare and mysql so we can check what went wrong.

---

<div class="post-metadata">

**Author:** ![Supriya](https://avatars.discourse-cdn.com/v4/letter/s/5f8ce5/32.png) [@Supriya](https://forums.percona.com/u/Supriya)\
**Post date:** [November 6, 2020, 12:39am UTC](https://forums.percona.com/t/error-1146-42s02-tablespace-doesnt-exist-after-xtrabackup-restore/8212/3 "2020-11-06T00:39:48Z")

</div>

Hello Marcelo,

Sorry, I had skipped --prepare step which resulted into DB crash.

Anyways, thank you for your reply.