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

innobackup --database restore Mariadb 10.1.16 not support Drop tablespace

ritchieliu029ritchieliu029 EntrantInactive User Role Beginner
Hi all,

I try to backup --database only on 150GB data for master (single mariadb 10.1.16) and slave replication (one node of the galara cluster). sqldump is not a option which takes too long. I successfull did the backup with following:
innobackupex --user=root --password=password --databases="XXX" /opt/mysql/innobackupbackup/xxxbackup --slave-info --no-timestamp --parallel=4
innobackupex --apply-log --export /opt/mysql/innobackupbackup/xxxbackup

But when i restore it. Mariadb 10.1.16 not support the below:
ALTER TABLE mydatabase.mytable DISCARD TABLESPACE;
ALTER TABLE mydatabase.mytable IMPORT TABLESPACE;

How can we restore it with knowing the binlog position of master to be able to startup slave?
innodb_file_per_table option is enabled in both servers.
Thanks.
Ritchie
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.