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