# Backup and Restore

**URL:** <https://forums.percona.com/t/backup-and-restore/3089>\
**Category:** Percona XtraBackup\
**Created:** [November 15, 2013, 6:52am UTC](https://forums.percona.com/t/backup-and-restore/3089 "2013-11-15T06:52:05Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![CodingBunny](https://avatars.discourse-cdn.com/v4/letter/c/87869e/32.png) [@CodingBunny](https://forums.percona.com/u/CodingBunny)\
**Post date:** [November 15, 2013, 6:52am UTC](https://forums.percona.com/t/backup-and-restore/3089/1 "2013-11-15T06:52:05Z")

</div>

Hi Guys,

From what I can see this hasn’t been posted yet.

The problem I am having at the moment is that I did a backup using the following command “xtrabackup --backup --target-dir=/backup/mysql/full2013-10-26/”.

From what I understand is that xtrabackup does not save the frm files, and this is where my problems seem to come in.

I re-created the re-created the structure in a completely blank DB, the structure I used was from the latest structure of the table, but I am starting to think either this is not the correct way or something within the original table structure has changed from the current .ibd structure.

I followed the following steps.

1. Create DB (On different server)
2. Create Table (from closest structure available.)
3. Drop tablespace of the table
4. Copied .ext, .ibd, .cfg files to the DB directory (/var/lib/mysql/testdb)
5. Import tablespace

- this is the step that is currently failing with the following error (“[Err] 1808 - Schema mismatch (Column calldate precise type mismatch.)”)
- the mentioned ‘calldate’ field is a timedate field. this has not changed in either of the tables as for a I know.

Does anyone know what this is or at least point me in the right direction, not finding anything conclusive on the net ☹

Regards and thanks in advance 🙂

---

<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:** [November 19, 2013, 12:55am UTC](https://forums.percona.com/t/backup-and-restore/3089/2 "2013-11-19T00:55:31Z")

</div>

Hi,

I would suggest you should try with innobackupex utility because  
“innobackupex called xtrabackup binary to backup all the data of [InnoDB](http://www.percona.com/doc/percona-xtrabackup/2.1/glossary.html#term-innodb) tables (see [Creating a Backup](http://www.percona.com/doc/percona-xtrabackup/2.1/xtrabackup_bin/creating_a_backup.html) for details on this process) and copied all the table definitions in the database ([.frm](http://www.percona.com/doc/percona-xtrabackup/2.1/glossary.html#term-frm) files), data and files related to [MyISAM](http://www.percona.com/doc/percona-xtrabackup/2.1/glossary.html#term-myisam), [MERGE](http://www.percona.com/doc/percona-xtrabackup/2.1/glossary.html#term-mrg)(reference to other tables), [CSV](http://www.percona.com/doc/percona-xtrabackup/2.1/glossary.html#term-csv) and [ARCHIVE](http://www.percona.com/doc/percona-xtrabackup/2.1/glossary.html#term-arm) tables, along with [triggers](http://www.percona.com/doc/percona-xtrabackup/2.1/glossary.html#term-trg) and [database configuration information](http://www.percona.com/doc/percona-xtrabackup/2.1/glossary.html#term-opt) to a time stamped directory created in the provided path.”  
[URL][Percona XtraBackup](http://www.percona.com/doc/percona-xtrabackup/2.1/innobackupex/creating_a_backup_ibk.html%5B/URL%5D)