[EP-tech] upgrading from MySQL 5.7

[yurj at alfa.it (Yuri)]

CAUTION: This e-mail originated outside the University of Southampton.

Hi!

 we are using MariaDB 10.3 from the beginning (Debian default to MariaDB instead of MySQL) and we had no issues.

 The simpler method is to sql dump the database and reload it in the new installation.

Il 19/05/23 22:38, Tomasz Neugebauer via Eprints-tech ha scritto:
CAUTION: This e-mail originated outside the University of Southampton.
Hi everyone!

I will need to upgrade our database sometime soon, as we are currently running on MySQL5.7
We are on EPrints 3.4.3.

Has anyone been through the process of upgrading the DB recently?
Do you have any comments/recommendations based on how it went?
What would be the optimal upgrade path for the DB, should we upgrade with MySQL 8 or perhaps switch over to MariaDB (10.11 LTS)?

David kindly shared with me the following two issues
https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Feprints%2Feprints3.4%2Fissues%2F196&data=05%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C2513a21295b844e2e21108db5a91ac76%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C638203354039638665%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000%7C%7C%7C&sdata=6UD4pmEDPmjGzRE4yFkJ89m39CAOBJfty9AQmc5Gng4%3D&reserved=0
https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Feprints%2Feprints3.4%2Fissues%2F247&data=05%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C2513a21295b844e2e21108db5a91ac76%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C638203354039638665%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000%7C%7C%7C&sdata=9li3SpVGoqr3aYyv69vG4rGAePox%2Fzzr9j7g1%2FrXMuo%3D&reserved=0

(thank you!)

Tomasz







*** Options: http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
*** Archive: https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.eprints.org%2Ftech.php%2F&data=05%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C2513a21295b844e2e21108db5a91ac76%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C638203354039638665%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000%7C%7C%7C&sdata=3d2DR7dR5HK0Djo86%2Ff2HUF%2Fnapnc31u5J83fwwDNh4%3D&reserved=0
*** EPrints community wiki: https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwiki.eprints.org%2F&data=05%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C2513a21295b844e2e21108db5a91ac76%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C638203354039638665%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000%7C%7C%7C&sdata=OC%2FeR%2FgdtUVG1HXBf8VUdRgKr56XI4zeezUI1P2DCtE%3D&reserved=0
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.ecs.soton.ac.uk/pipermail/eprints-tech/attachments/20230522/8844e88c/attachment.html