Upgrading a MySQL server

  • Don

    (@55don)


    1 year, 2 months ago

    Hello and thank you in advance…

    I need to upgrade the mysql server on my leased device running cPanel/WHM from version 5.7 to 8.0 and have questions regarding the current data collation situation of my WordPress database columns.

    For example, with respect to the table named wp_cerber_sets, when I manually convert from utf8_general_ci to utf8mb4_unicode_ci (using phpMyAdmin), I receive the following error:

    MySQL said: Data too long for column ‘the_value’ at row [integer]

    The data type for the_value is LONGTEXT. Are my LONGTEXT data types going to prevent an upgrade from MySQL 5.7 to 8.0 and if the the upgrade (using WHM… MySQL/MariaDB Upgrade) completes, what kind of problems can I expect after the upgrade?

    Thank you,

    Don

Viewing 2 replies - 1 through 2 (of 2 total)
  • Shipon Karmakar

    (@shiponkarmakar)

    1 year, 2 months ago

    Try to Upgrade with Maria DB 10.3 Above Then try to convert your utf8_general_ci to utf8mb4_unicode_ci (using phpMyAdmin). But Must be Backup your files also try to discuss about it with cPanel Support.

    Thanks

    Thread Starter Don

    (@55don)

    1 year, 2 months ago

    Upgrading from MySQL 5.7 to MariaDB 10.3 appears more complicated (more warnings) and MariaDB 10.3 has a end of life data of May ’23.

    How about this question…

    The MySQL/MariaDB Upgrade checker is also saying, It is strongly advised to replace zero values (dates and timestamps) with valid ones, as they may not work correctly in the future.

    Does this mean replace the zeros with, NULL? I don’t know what the warning means by “valid ones”.

    Thanks,

    Don

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Upgrading a MySQL server’ is closed to new replies.