# Export/Import Table

**URL:** <https://forums.percona.com/t/export-import-table/2187>\
**Category:** Percona XtraBackup\
**Created:** [December 2, 2011, 10:48am UTC](https://forums.percona.com/t/export-import-table/2187 "2011-12-02T10:48:45Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![prisoner](https://avatars.discourse-cdn.com/v4/letter/p/c2a13f/32.png) [@prisoner](https://forums.percona.com/u/prisoner)\
**Post date:** [December 2, 2011, 10:48am UTC](https://forums.percona.com/t/export-import-table/2187/1 "2011-12-02T10:48:45Z")

</div>

I’ve been carefully following all the directions here for exporting and importing a table

[http://www.percona.com/doc/percona-xtrabackup/xtrabackup\_bin](http://www.percona.com/doc/percona-xtrabackup/xtrabackup_bin) /exporting\_importing\_tables.html

And I’ve been running into a problem. I’m getting Error 1030, not during the “alter table discard tablespace” but during the “alter table import tablespace” step. I also have INNODB\_FILE\_PER\_TABLE enabled on both servers before I start and the table I’m exporting was create with FILE\_PER\_TABLE on. Mysql owns all the files in the datadir.

I’m using Percona-Server v5.5.13 on both the server I’m exporting the table from and the server I’m trying to import the table on. Also I’m using Xtrabackup v1.6.3.

the create statement for the table I’m trying to export looks like this:  
CREATE TABLE `testtable` ( `a` int(10) NOT NULL AUTO\_INCREMENT, `b` varchar(100) DEFAULT NULL, `c` varchar(100) DEFAULT NULL, PRIMARY KEY (`a`) ) ENGINE=InnoDB AUTO\_INCREMENT=372 DEFAULT CHARSET=utf8;

If anyone has any ideas about what I’m doing wrong, I’d be greatful to hear them.

---

<div class="post-metadata">

**Author:** ![prisoner](https://avatars.discourse-cdn.com/v4/letter/p/c2a13f/32.png) [@prisoner](https://forums.percona.com/u/prisoner)\
**Post date:** [December 2, 2011, 12:38pm UTC](https://forums.percona.com/t/export-import-table/2187/2 "2011-12-02T12:38:23Z")

</div>

Solved own problem, needed innodb\_import\_table\_from\_xtrabackup set to 1.