0

I am using Percona-Server 8.0.x and I am following percona xtraback documentation.

https://www.percona.com/doc/percona-xtrabackup/8.0/xtrabackup_bin/restoring_individual_tables.html

I am exporting all tables in one or more databases from a single server. I am trying to restore them on a different server by using discard and import tablespace query. However the import works for some tables but not for many others. It fails exactly on particular type of data column type.

Steps.

  1. Use xtraback to export the selected databases.
  2. Prepare the backup
  3. On the destination server, discard tablespace ALTER TABLE db.table_name DISCARD TABLESPACE
  4. Move .ibd and .cfg file to @@datadir/database/ with proper permission
  5. Import the table space. ALTER TABLE db.table_name IMPORT TABLESPACE

Error I am getting is following.

Schema mismatch (Column <colname> precise type mismatch.)

Here in all the failures I am facing are related to TEXT or LONGTEXT datatype. The original schema were created in MySQL 5.5. era. Also I am running percona-server with non strict SQL mode sql_mode=''

Upon further investigation, The tablespace export and import works if it is performed using MySQL commands. However it gives problem when use the .cfg generated via percona xtraback tool. I will post if I get it to work.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.