Thanks for your answer, I understand perfectly, but this is an old system, I understand the procedure of the update, but I thought there was some old_mode configuration only to run that database with the options of mariadb 5.5.52 in mariadb 10.1.22. Thks, Wilmer. 2017-03-21 16:19 GMT-04:00 Reindl Harald <h.reindl@thelounge.net>:

...

Am 21.03.2017 um 21:08 schrieb Wilmer Arambula:

...

Hi, ihave a system running perfectly on mariadb 5.5.52, i will change everything to a new server with mariadb 10.1.22, but running the installation script gives me problems, this is the error, is there any way to configure mariadb 10.1.22 To omit this error, since mariadb 10.1.22 works with strict-trans-table, there is some old_mode feature that allows this.

Query : ALTER TABLE `media_gallery_music_elements` ADD FOREIGN KEY `FK_GALLERY_ID` (`gallery_id`) REFERENCES `media_gallery_musi...

Error Code : 1005 Can't create table `test`.`#sql-c82_1086` (errno: 121 "Duplicate key on write or update")

Execution Time : 00:00:00:000 Transfer Time : 00:00:00:000 Total Time : 00:00:00:000

I can manually modify and fix the error, but it is a system with many scripts and updates, is there any way to omit this error in Mariadb 10.1.22

either you have unique keys or not

however why not first upgrade to 10.0.x and why working with dumps instead just as others do for many many years an dbrought their server from mysql3 to mariadb 10.1 - this is not postgresql

* upgrade 10.x * mysql_upgrade -u root -p * upgrade 10.1.x * mysql_upgrade -u root -p

no, not on the live-server, on a virtual machine where you first rsync your datadir, play the upgrades and finally when you have a working plan after the last retry rsync the datadir to the new liveserver

_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp