# xtrabackup single database backup

**URL:** https://forums.percona.com/t/xtrabackup-single-database-backup/5943
**Category:** Percona XtraBackup
**Created:** [October 17, 2017, 1:58pm UTC](https://forums.percona.com/t/xtrabackup-single-database-backup/5943 "2017-10-17T13:58:26Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![maziar](https://avatars.discourse-cdn.com/v4/letter/m/ac8455/32.png) [@maziar](https://forums.percona.com/u/maziar)
#### Post date: [October 17, 2017, 1:58pm UTC](https://forums.percona.com/t/xtrabackup-single-database-backup/5943/1 "2017-10-17T13:58:26Z")

</div>

I have many databases on my mariadb, and I’m using these commands :

first step creating backup from specific database:  
`innobackupex --user=debian-sys-maint --databases='db1' --tables=db1.* --password=pass --no-lock --use-memory=4G --parallel=1 backupdir/`  
and its fine and ok

second step applying log on this backup  
`innobackupex --apply-log --user=debian-sys-maint --password=pass --databases='db1' --tables=db1.* --no-lock --use-memory=4G --parallel=1 backupdir/`  
this is not ok and I get error about other databases on log like :

InnoDB: Failed to find tablespace for table `table1`.`FTS_0000000000000318_CONFIG` in the cache. Attempting to load the tablespace with space id 783  
InnoDB: Operating system error number 2 in a file operation.  
InnoDB: The error means the system cannot find the path specified.  
InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them.  
InnoDB: Cannot open datafile for read-only: ‘./table@00xxx/FTS\_0000000000000318\_CONFIG.ibd’ OS error: 71  
InnoDB: Operating system error number 2 in a file operation.  
InnoDB: The error means the system cannot find the path specified.  
InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them.  
InnoDB: Could not find a valid tablespace file for `table&#64;002xxx/FTS_0000000000000318_CONFIG`. Please refer to [url][http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html[/url]](http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html%5B/url%5D) for how to resolve the issue.

InnoDB: Failed to find tablespace for table `table1`.`FTS_0000000000000318_DELETED` in the cache. Attempting to load the tablespace with space id 779  
InnoDB: Operating system error number 2 in a file operation.  
InnoDB: The error means the system cannot find the path specified.  
InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them.  
InnoDB: Cannot open datafile for read-only: ‘./table1@xxx/FTS\_0000000000000318\_DELETED.ibd’ OS error: 71  
InnoDB: Operating system error number 2 in a file operation.  
InnoDB: The error means the system cannot find the path specified.  
InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them.  
InnoDB: Could not find a valid tablespace file for `table&#64;xxx/FTS_0000000000000318_DELETED`. Please refer to [url][http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html[/url]](http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html%5B/url%5D) for how to resolve the issue.

---

<div class="post-metadata">

### Author: ![CESAR\_MURILO\_DA\_SILV](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/cesar_murilo_da_silv/32/1248_2.png) [@CESAR\_MURILO\_DA\_SILV](https://forums.percona.com/u/CESAR_MURILO_DA_SILV)
#### Post date: [December 25, 2018, 5:44pm UTC](https://forums.percona.com/t/xtrabackup-single-database-backup/5943/2 "2018-12-25T17:44:23Z")

</div>

I’m having a Slackware 14.2, and MariaDB 10.0.37, when I return this command, it returns me a message: readline() on closed filehandle $fh at /usr/bin/innobackupex line 4419
