Not the answer you need?
Register and ask your own question!

XtraBackup Error : Got -1 from storage engine

viswajviswaj EntrantCurrent User Role Beginner
We are trying to implement Copying InnoDB table between servers using Xtrabackup, but we are unable to take the backup and run in another server.

We are getting the following error, Got -1 from storage engine.

But for the above error, while exporting we have enabled the following options innodb-expand-import and innodb-file-per-table.

After doing the above, still we are unable to load the .ibd files and getting the same error.

We have followed the steps from this url,

http://www.mysqlperformanceblog.com/2009/07/31/copying-innod b-tables-between-servers/

Also, we have discard and try to import the tablespace, but it also fails.

Past one week we tried to solve this, but we are unable to sort this.

Please help out on this.


Regards,

Viswa.J

Comments

  • miguelangelnietomiguelangelnieto Member Inactive User Role Beginner
    Hi,

    In order to move InnoDB table from one server to another using XtraBackup you need to have Percona Server as the destination server, it doesn't work with Oracle's MySQL. I recommend you to check the following link, it has more updated information than the linked blog post.

    http://www.percona.com/doc/percona-xtrabackup/innobackupex/i mporting_exporting_tables_ibk.html

    Please, follow those steps and tell us in which step are you having problems. A full log output would also be helpful.

    We also need to know:

    - MySQL version of the origin server (is it Percona Server?)
    - MySQL version of the destination server (is it Percona Server?)
    - XtraBackup version
    - Output of the error log regarding the restore process

    If you are trying to restore a single InnoDB table on a Oracle's MySQL server you should follow this steps:

    http://www.mysqlperformanceblog.com/2012/01/25/how-to-recove r-a-single-innodb-table-from-a-full-backup/

    Regards.
  • viswajviswaj Entrant Current User Role Beginner
    Miguelangelnieto,

    Thanks for the help,

    Getting the following error, while importing the innodb table data

    InnoDB: of table `test`.`test_table`.
    120313 7:59:04 InnoDB: Error: you are trying to IMPORT a tablespace
    InnoDB: `test`.`test_table`, though you have not called DISCARD on it yet
    InnoDB: during the lifetime of the mysqld process!
    120313 7:59:50 InnoDB: Operating system error number 2 in a file operation.
    InnoDB: The error means the system cannot find the path specified.
    120313 7:59:50 InnoDB: Error: trying to open a table, but could not
    InnoDB: open the tablespace file './test/test_table.ibd'!
    120313 7:59:50 InnoDB: Error: cannot reset lsn's in table `test`.`test_table`
    InnoDB: in ALTER TABLE ... IMPORT TABLESPACE

    Regards,
    Viswa.J
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.