MySQL Unknown Collation

[V4mpireuk]

Hi,

I have just reinstalled my server and restoring backups, however i have encountered the following issues:

Unknown collation: 'utf8mb4_unicode_520_ci'

and

The used table type doesn't support FULLTEXT indexes

I have previously been using mysql 5.6, when I ran the directadmin install, it had installed MariaDB, I changed this out to go back to mysql 5.6 like the sql exports had come from, so I am at a loss as to what the issue is.

mysql --version
mysql Ver 14.14 Distrib 5.6.33, for Linux (x86_64) using EditLine wrapper


Any help would be great.

Regards,

V4mpire

 

[V4mpireuk]

Just as n update in case anyone else encounters the issue, I had issues trying to remove MariaDB completely and this was causing conflict to MySQL wasn't actually properly installed, though on first attempt I was shown no errors so I was unaware but tried again being more awake.

I managed to resolve it with the following:

rpm -e --noscripts MariaDB-server

then I just ran the ./build mysql command as normal and it went without a hitch and was able to restore the backups giving these errors.

Hope this helps for anyone having the same issue.