i-MSCP 1.5.2 and MySQL 5.5 (not supported anymore) -- Upgrade path?

    Hallo,


    I see in the Errata-Fille for i-MSCP 1.5.2 that MySQL 5.5 is not supported anymore.


    I have Debian Jessie with MySQL 5.5.


    Must I make the update to MySQL 5.7 before or make it i-MSCP with the auto installer. ?(


    When not must I do the Update from MySQL 5.5 to MySQL 5.6 and then to MySQL 5.7. ?(


    Kind regards
    Viktor


    - Distribution: Debian | Release: 8.9 | Codename: jessie
    - i-MSCP Version: i-MSCP 1.4.5 | Build: 20170613 | Codename: Zimmer
    - Plugins installed: ClamAV (v. 1.3.0), Mailgraph (v 1.1.1), OpenDKIM (v 1.2.0), PanelRedirect (v 1.2.0) & SpamAssassin (v 2.0.1)
    - LetsEncrypt (v 3.3.0), PhpSwitcher (v 3.0.2), RoundcubePlugins (v 2.0.1)

    - Distribution: Debian | Release: 8.10 | Codename: jessie

    - i-MSCP Version: i-MSCP 1.5.3 | Build: 20180516 | Codename: Ennio Morricone

    - Plugins installed: ClamAV (v. 1.3.0), Mailgraph (v 1.1.1), OpenDKIM (v 2.0.0), PanelRedirect (v 1.2.0) & SpamAssassin (v 2.0.1)

    - LetsEncrypt (v 3.6.0), PhpSwitcher (v 5.0.5), RoundcubePlugins (v 2.0.2)

    @Viktor


    Quote from Viktor

    Must I make the update to MySQL 5.7 before

    No ;)


    Quote from Viktor

    When not must I do the Update from MySQL 5.5 to MySQL 5.6 and then to MySQL 5.7.

    Neither. Upgrade from MySQL 5.5 to MySQL 5.7 shouldn't pose any problem.


    You'll have just to execute the i-MSCP installer as usually and you'll be asked again for the SQL server that you want use. And because the installer will detect that your current SQL server vendor is MySQL, you'll have choice between MySQL 5.7 and remote server. So here, you'll have to select MySQL 5.7. That's all what you'll have to do.


    Of course, if you're not comfortable with that automatic upgrade path, you can always make a backup of your current MySQL data prior running the i-MSCP installer (what you should always do anyway)

    Shell-Script
    1. cd /usr/local/src && mkdir backup && cd backup
    2. service mysql stop
    3. cp -rp /etc/mysql etc-mysql
    4. cp -rp /var/lib/mysql var-lib-mysql
    5. service mysql start

    BTW: Glad to learn that some people are taking time to read errata files (even for unreleased versions) ;) At least, I'm happy to see that I'm not losing my time writing them.

    badge.php?id=1239063037&bid=2518&key=1747635596&format=png&z=547451206

    SSH key for online support

    @Nuxwin


    Thanks for the Support.


    I must call "perl imscp-autoinstall -d" and everything is working.


    This is nice and now I can wait for i-MSCP 1.5.2.


    Kind regards
    Viktor

    - Distribution: Debian | Release: 8.10 | Codename: jessie

    - i-MSCP Version: i-MSCP 1.5.3 | Build: 20180516 | Codename: Ennio Morricone

    - Plugins installed: ClamAV (v. 1.3.0), Mailgraph (v 1.1.1), OpenDKIM (v 2.0.0), PanelRedirect (v 1.2.0) & SpamAssassin (v 2.0.1)

    - LetsEncrypt (v 3.6.0), PhpSwitcher (v 5.0.5), RoundcubePlugins (v 2.0.2)