Fix: Akeeba Database Restoration Error: COLLATE=utf8mb4_unicode_ci
Using the latest version of Akeeba Backup, you may receive the following error while trying to restore your database:
Database restorationAn error occurred while restoring the database. The error message can be found below. Click on the × button at the top right of this dialog message to close it and return to the database restoration page.
Database error processing line 5
Database server error reply:
ErrNo #0
SQL=CREATE TABLE `ttcmy_akeeba_common` ( `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `value` longtext COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`key`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
Raw query text:
CREATE TABLE `#__akeeba_common` ( `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `value` longtext COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`key`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
This is caused by an incompatibility between the old and new database servers. To get around, click the advanced options and select Force UTF-8 collation on tables. The restore will complete successfully.
* Please use the comment form below. Comments are moderated.*
Comments 2
Database restorationAn error occurred while restoring the database. The error message can be found below. Click on the × button at the top right of this dialog message to close it and return to the database restoration page.
Unable to connect to the Database: Could not connect to MySQL.
Il primo import è andato bene. Ho cambiato solo il nome del DB
Chi può aiutarmi?
Thank U very much