How do I upgrade to Mysql 5.7 on Debian 10.1?
I am on a Nanode and currently run a small WordPress blog. I wish to upgrade to MySQL 5.7 or 8 if possible. From what I know, it is not officially supported by Debian. I tried finding community articles, but was not able to find any.
This is my info:
mysql -V
mysql Ver 15.1 Distrib 10.3.17-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2
3 Replies
I took a look into this, and it does appear that according to MySQL Debian 10 is supported for version 5.7.
With that being said, what I would recommend, rather than upgrading the application (which would entail upgrading first to 5.4, then 5.5 and then 5.6 before reaching 5.7) is performing a dump of your databases and then restoring ito a fresh installation of MySQL 5.7.
Depending on your preference, we do have guides for both MySQL and MariaDB. The process for both is approximately the same. If you run into any issues this article might give some insight into the specifics of Debian 10.
And of course, feel free to let us know about any problems. In such a case it's always helpful to provide specific error messages and information such as exact commands performed.
Thanks for your response! Can't I simply upgrade? I do not want to uninstall and re-install my MySQL server.
You certainly can just upgrade. We generally recommend performing a fresh installation as inline upgrades have been known to cause system instability, and a fresh installation can be a bit more straightforward. Regardless of your method I would strongly advise backing up your database before attempting an upgrade.
There are some more detailed instructions for how to perform an inline upgrade here.