[debian-mysql] Bug#929707: Bug#929707: mariadb-client-10.1: import of "mysqldump --all-databases" fails with "ERROR 1062 (23000): Duplicate entry"

Matija Nalis mnalis-debianbug at voyager.hr
Tue Sep 29 20:43:01 BST 2020


I've retested now quickly on different machine, and it *seems* to be working OK in Buster.

# mysqldump -uroot --max_allowed_packet=2147483648 --hex-blob --lock-all-tables --master-data --flush-privileges --databases video1 mysql > backup.sql
# mysql < backup.sql
# lsb_release -a
No LSB modules are available.
Distributor ID: Debian
Description:    Debian GNU/Linux 10 (buster)
Release:        10
Codename:       buster
# dpkg -l | grep mariadb
ii  libmariadb3:amd64                    1:10.3.23-0+deb10u1                   amd64        MariaDB database client library
ii  mariadb-client                       1:10.3.23-0+deb10u1                   all          MariaDB database client (metapackage depending on the latest version)
ii  mariadb-client-10.3                  1:10.3.23-0+deb10u1                   amd64        MariaDB database client binaries
ii  mariadb-client-core-10.3             1:10.3.23-0+deb10u1                   amd64        MariaDB database core client binaries
ii  mariadb-common                       1:10.3.23-0+deb10u1                   all          MariaDB common metapackage
ii  mariadb-server                       1:10.3.23-0+deb10u1                   all          MariaDB database server (metapackage depending on the latest version)
ii  mariadb-server-10.3                  1:10.3.23-0+deb10u1                   amd64        MariaDB database server binaries
ii  mariadb-server-core-10.3             1:10.3.23-0+deb10u1                   amd64        MariaDB database core server files



More information about the pkg-mysql-maint mailing list