[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[EP-tech] upgrading from MySQL 5.7
CAUTION: This e-mail originated outside the University of Southampton.
Thank you, Yuri, that is useful to know MariaDB 10.3 is working well.
Is anyone running EPrints with MySQL 8?
Tomasz
________________________________
From: eprints-tech-bounces at ecs.soton.ac.uk <eprints-tech-bounces at ecs.soton.ac.uk> on behalf of Yuri via Eprints-tech <eprints-tech at ecs.soton.ac.uk>
Sent: Monday, May 22, 2023 2:56 AM
To: eprints-tech at ecs.soton.ac.uk <eprints-tech at ecs.soton.ac.uk>
Subject: Re: [EP-tech] upgrading from MySQL 5.7
Attention This email originates from outside the concordia.ca domain. // Ce courriel provient de l'ext?rieur du domaine de concordia.ca
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%7Cd1b930c9ace44121f77108db5b93a289%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C638204462017431527%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000%7C%7C%7C&sdata=2IUAaJKjp4TfilrZNd4OovwnZhMVxEJhsUExzIt7FoI%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%7Cd1b930c9ace44121f77108db5b93a289%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C638204462017431527%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000%7C%7C%7C&sdata=%2B4nNucNb8dAvDHam0dHLTeiqto9OY%2BQwwYQ6CyJYnU0%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%7Cd1b930c9ace44121f77108db5b93a289%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C638204462017431527%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000%7C%7C%7C&sdata=oEcgTKqQktKgYm2lpC0ViT6Vpt%2F0eVDQ2Wa%2FU78ZlL0%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%7Cd1b930c9ace44121f77108db5b93a289%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C638204462017431527%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000%7C%7C%7C&sdata=y%2F5eNz6tdlHgl7f%2B3Z4ntEp7%2BHcuaChAaTk14%2BYseHc%3D&reserved=0
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.ecs.soton.ac.uk/pipermail/eprints-tech/attachments/20230523/c5b36a0f/attachment-0001.html