Is upgrading MySQL risky?

Question

linux

There is debian 6.0.10, with MySQL 5.1.73 installed, which uses the postfix 2.7.1 database. and roundcube
I need to add a database to SQL that will work with an application that requires SQL at least 5.5.
If I update SQL, won't postfix break?

Answer 1

If it's really scary, you can collect from sorts to the right folder and change the port in the config.
In general, you can just read the changelog on the offsite, or here:
https://dev.mysql.com/doc/refman/5.5/en/upgrading-...
There are no critical changes that break backward compatibility. Mostly bug fixes.

Answer 2

only through 4 versions - more carefully. It can be difficult there. For example, my user table "broke" like this. the number of fields in it has changed. Read the upgrade guide first.

Answer 3

I would install the second mysql instance version 5.5

Answer 4

It won't break, because Postfix calls SQL for users.

Answer 5

If there are not many databases, you can make backups and only after that update or completely demolish the MySQL of the old version (do not forget that in addition to the databases there are also users and their privileges) and all the settings and install the new version, then re-create the databases and users, set the required privileges.
But in principle, the upgrade from 5.1 to 5.5 should go very smoothly.

Answer 6

debian 6 itself is already obsolete software, all in a crowd.
carefully migrate with backups to 7, then to 8.
carefully drag the configs, with a 90% probability they will start without problems, but the postfix admin schemes can change there, yes.
but you have to leave in the complex with 6ki