mahara-contributors team mailing list archive

[Nitin Mishra <2003190@xxxxxxxxxxxxxxxxxx>]

Hello Robert,

I follow the steps as suggested:

1. export the DB without character set details
2. remove character set and collation details from the table and column definitions
3. create a new database with the correct character set and collation
4. import the database specifying the explicit character set.

But again I got the error as shown in the attached screenshot.

The structure & data has successfully imported but the issue with the
indexes.

** Attachment added: "db_error_import.JPG"
   https://bugs.launchpad.net/mahara/+bug/2003190/+attachment/5642455/+files/db_error_import.JPG

-- 
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.
Matching subscriptions: mahara-contributors
https://bugs.launchpad.net/bugs/2003190

Title:
  Not able to change Mahara collation from utf8_bin to
  utf8mb4_unicode_ci

Status in Mahara:
  Incomplete

Bug description:
  I am using Mahara version 22.04, Mahara recommending to change its DB collation.
  Mysql version - 5.7
  PHP version - 7.4

  Using PHPMyAdmin & manually, through the notepad editor(manually
  replacing) both methods are not working.

  Please suggest how can I change it from utf8_bin to
  utf8mb4_unicode_ci.

  - Using PHPMyAdmin
  It is not working to change the collation for MySQL table columns.

  - Using editor
  During DB import it shows multiple errors.
  like - Foreign Key constraint errors and more

  Please suggest

To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/2003190/+subscriptions