Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Minor
-
Resolution: Unresolved
-
5.5, 10.1, 10.2, 10.3, 10.4
Description
When creating backup from ARCHIVE table with mysqldump, it is not possible to restore this dump file, because error: Can't write; duplicate key in table 't1'
Mysqldump creates dump with CREATE TABLE ... AUTO_INCREMENT=next_id value and after CREATE TABLE it is not possible to insert data with lower id-s.
MariaDB [test]> CREATE TABLE t1(id INT AUTO_INCREMENT, PRIMARY KEY (`id`)) ENGINE=ARCHIVE;
|
Query OK, 0 rows affected (0.001 sec)
|
|
|
MariaDB [test]> INSERT INTO t1 VALUES (1);
|
Query OK, 1 row affected (0.003 sec)
|
|
|
MariaDB [test]> Bye
|
[root@uvn-234-24 ~]# mysqldump test t1|mysql test
|
ERROR 1022 (23000) at line 37: Can't write; duplicate key in table 't1'
|