Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.5.11
-
None
-
None
-
Linux
Description
Do as following steps:
1. mariabackup --backup --user=root --password='1234' --target_dir=/home/test/backup1 --parallel=4 --rsync
2. mariabackup --prepare --export --target-dir /home/test/backup1 --user root --password '1234'
3. alter table test.users DISCARD TABLESPACE;
4. cp /home/test/backup1/test/users.cfg /var/lib/mysql/test/
cp /home/test/backup1/test/users.ibd /var/lib/mysql/test/
chown -R mysql:mysql /var/lib/mysql/test/
5. alter table test.users IMPORT TABLESPACE;
6. ERROR 1808 (HY000): Schema mismatch (Index field name logintype doesn't match tablespace metadata field name password for field position 5)
CREATE TABLE `users` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`username` varchar(64) NOT NULL,
`name` varchar(64) NOT NULL,
`logintype` smallint(1) NOT NULL DEFAULT 0 COMMENT '',
`password` varchar(64) NOT NULL,
`enabled` smallint(6) NOT NULL,
`email` varchar(64) NOT NULL,
`create_ts` timestamp NOT NULL DEFAULT current_timestamp(),
`lastupdate_ts` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;