Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.6.9
-
None
Description
Create tables e.g. table1, table2, table10, make partial backup:
sudo mariadb-backup --backup -utest_user -p**** --target-dir=backup --tables=table1
|
|
stop server, cleanup /var/lib/mysql, run mariadb-install-db, restart server, re-create users
Create empty table, discard its tables space: `alter table table1 discard tablespace;`
Try to restore `table1`:
sudo mariadb-backup --prepare --target-dir=backup --export
|
sudo cp backup/test/table1.ibd /var/lib/mysql/test/
|
sudo cp backup/test/table1.cfg /var/lib/mysql/test/
|
sudo chown mysql:mysql /var/lib/mysql -R
|
|
Try to import tablespace:
MariaDB [test]> alter table table1 import tablespace;
|
ERROR 1808 (HY000): Schema mismatch (Column s precise type mismatch, it's 0X8100F in the table and 0X2D100F in the tablespace meta file)
|
|
what do `0X8100F` and `0X2D100F` ?
Documentation:
- partial backup doc https://mariadb.com/kb/en/partial-backup-and-restore-with-mariabackup/
- tablespace import doc https://mariadb.com/kb/en/innodb-file-per-table-tablespaces/#importing-transportable-tablespaces-for-non-partitioned-tables
Should mariadb-backup tool do partial backup restore automatically?