Jump to content
  • Trouble with db update 21_04_001 on MySQL 8


    Daniil
    • Main Category: Database
      Sub-Category: Minor
      Version: 22.x (Current Master Branch)
      Related to:
     Share

    On updating character2 table to version 22.1.1, faced a trouble with adding Rel21_04_001_update_deprecated_ROW_FORMAT.sql into db.

    It reports that MySQL can't complete a request "ALTER TABLE groups ROW_FORMAT=DYNAMIC ENGINE=INNODB;"

    After a search in a Google, I found that there is a kind of troubles with dynamic row format in InnoDB in MySQL 8 (v 8.0.22), and solved a problem by simple removing this string from update file (i.e., row format for this table leaved unchanged, i.e., MyISAM). All other fields changed correctly. Now all works fine, but just reporting to you about this trouble.

     Share


    User Feedback

    Recommended Comments



    Create an account or sign in to comment

    You need to be a member in order to leave a comment

    Create an account

    Sign up for a new account in our community. It's easy!

    Register a new account

    Sign in

    Already have an account? Sign in here.

    Sign In Now

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy Terms of Use