Unable to make database dump in Plesk: Unknown column 'generation_expression' in 'field list' (1054)

Follow

Comments

5 comments

  • Avatar
    Nick Hoang

    Hi Anton Kuznetsov could we upgrade MySQL of the existing server from 5.6 to 5.7

    0
    Comment actions Permalink
  • Avatar
    Anton Kuznetsov

    Hello Nick Hoang,

    It is not possible to install MySQL 5.7 anymore due to some legal aspects and it is recommended to install MariaDB instead:

    https://support.plesk.com/hc/en-us/articles/12388974493975

    1
    Comment actions Permalink
  • Avatar
    Nick Hoang (Edited )

    Thanks for your answer Anton Kuznetsov

    I've installed the MariaDB and migrated all the existing mySql DBs into it but I still receiving the warning about the mySql database as before. Is it possible to stop the mySQLdatabase service to get risk of these warnings?

    1
    Comment actions Permalink
  • Avatar
    Ashish Sharma

    I want to understand how can we resolve this issue without migrating. Has anyone yet found any solution? Please help.

    0
    Comment actions Permalink
  • Avatar
    Paul Johnstone

    It looks like that this error is affecting Backup & Restore Manager, Database Export and WordPress upgrades.
    Is there any workaround to this problem besides migrating to MariaDB? Note that this is for Windows-based clients running Plesk Windows, WP & MySQL.
    I’m finding several hosting providers are not providing a solution & are still running 5.5.43 of MySQL, this could be due to your comment above Anton.

    0
    Comment actions Permalink

Please sign in to leave a comment.

Have more questions? Submit a request