innobackupex: Creating directory '/var/lib/mysql/fred'
innobackupex: Copying '/tmp/2014-05-23_22-27-10/fred/sales_figures.isl' to '/var/lib/mysql/fred/sales_figures.isl'
innobackupex: Copying '/tmp/2014-05-23_22-27-10/fred/db.opt' to '/var/lib/mysql/fred/db.opt'
Found an .isl file for /tmp/2014-05-23_22-27-10/fred/sales_figures.ibd
Using /tmp/tb1/fred/sales_figures.ibd as the destination path
innobackupex: Copying '/tmp/2014-05-23_22-27-10/fred/sales_figures.ibd' to '/tmp/tb1/fred/sales_figures.ibd'
innobackupex: Error: copy failed: No such file or directory at /bin/innobackupex line 2141.
innobackupex: Creating directory '/var/lib/mysql/fred'
innobackupex: Copying '/tmp/2014-05-23_22-27-10/fred/sales_figures.isl' to '/var/lib/mysql/fred/sales_figures.isl'
innobackupex: Copying '/tmp/2014-05-23_22-27-10/fred/db.opt' to '/var/lib/mysql/fred/db.opt'
Found an .isl file for /tmp/2014-05-23_22-27-10/fred/sales_figures.ibd
Using /tmp/tb1/fred/sales_figures.ibd as the destination path
innobackupex: Copying '/tmp/2014-05-23_22-27-10/fred/sales_figures.ibd' to '/tmp/tb1/fred/sales_figures.ibd'
innobackupex: Copying '/tmp/2014-05-23_22-27-10/fred/sales_figures.frm' to '/var/lib/mysql/fred/sales_figures.frm'
innobackupex: Creating directory '/var/lib/mysql/sys'
...
innobackupex: Finished copying back files.
It's the same for a table not being partitioned:
innobackupex: Creating directory '/var/lib/ mysql/fred' 05-23_22- 27-10/fred/ sales_figures. isl' to '/var/lib/ mysql/fred/ sales_figures. isl' 05-23_22- 27-10/fred/ db.opt' to '/var/lib/ mysql/fred/ db.opt' 05-23_22- 27-10/fred/ sales_figures. ibd fred/sales_ figures. ibd as the destination path 05-23_22- 27-10/fred/ sales_figures. ibd' to '/tmp/tb1/ fred/sales_ figures. ibd'
innobackupex: Copying '/tmp/2014-
innobackupex: Copying '/tmp/2014-
Found an .isl file for /tmp/2014-
Using /tmp/tb1/
innobackupex: Copying '/tmp/2014-
innobackupex: Error: copy failed: No such file or directory at /bin/innobackupex line 2141.
[root@imac2 tmp]# rm -rf /var/lib/mysql/* 23_22-27- 10/
[root@imac2 tmp]# mkdir /tmp/tb1/fred
[root@imac2 tmp]# innobackupex --copy-back 2014-05-
innobackupex: Creating directory '/var/lib/ mysql/fred' 05-23_22- 27-10/fred/ sales_figures. isl' to '/var/lib/ mysql/fred/ sales_figures. isl' 05-23_22- 27-10/fred/ db.opt' to '/var/lib/ mysql/fred/ db.opt' 05-23_22- 27-10/fred/ sales_figures. ibd fred/sales_ figures. ibd as the destination path 05-23_22- 27-10/fred/ sales_figures. ibd' to '/tmp/tb1/ fred/sales_ figures. ibd' 05-23_22- 27-10/fred/ sales_figures. frm' to '/var/lib/ mysql/fred/ sales_figures. frm' mysql/sys'
innobackupex: Copying '/tmp/2014-
innobackupex: Copying '/tmp/2014-
Found an .isl file for /tmp/2014-
Using /tmp/tb1/
innobackupex: Copying '/tmp/2014-
innobackupex: Copying '/tmp/2014-
innobackupex: Creating directory '/var/lib/
...
innobackupex: Finished copying back files.
140523 22:30:14 innobackupex: completed OK!