Hi People, I have a dump from my original DB (SELECT VERSION(); 10.1.38-MariaDB-1~jessie) which holds the data for the v3.2.1:
mysqldump -h myProdMariaDb --user=openxpki --password \ --lock-tables \ --databases openxpki > *openxpki-bkp.sql* And now I was trying to put it on a local DB (SELECT VERSION(); 10.5.7-MariaDB-1:10.5.7+maria~buster), in order to upgrade this installation to version 3.8. In local MariaDB I already created an empty database and assign a database user: CREATE DATABASE openxpki CHARSET utf8;CREATE USER 'openxpki'@'localhost' IDENTIFIED BY 'openxpki';GRANT ALL ON openxpki.* TO 'openxpki'@'localhost';flush privileges; mysql -u openxpki -popenxpki openxpki < *openxpki-bkp.sql* This worked as expected. Then I tried to: git clone https://github.com/openxpki/openxpki-config.git --branch=community /etc/openxpki-3.8 mysql -u openxpki -popenxpki openxpki < /etc/openxpki-3.8/contrib/sql/schema-mariadb.sql ERROR 1068 (42000) at line 199: Multiple primary key defined The line 199 is like: ALTER TABLE `aliases` ADD PRIMARY KEY (`pki_realm`,`alias`), ADD KEY `realm_group` (`pki_realm`,`group_id`); I am a little lost on how to proceed the upgrade to v3.8 keeping the old database. Regards, Jeff
_______________________________________________ OpenXPKI-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/openxpki-users
