Database Restore Issue on XAMPP localhost

[g2ktcf]

I have a XAMPP localhost set up and was attempting to the database backup created by my site's Database Backup tool. I have never seen this error before. Here is the error I am getting:

MySQL said: Documentation

#1273 - Unknown collation: 'utf8mb4_0900_ai_ci'

????

[g2ktcf]

I did find one reference that recommends opening the file in a text editor and modifying the entries.

https://tecadmin.net/resolved-unknow...b4_0900_ai_ci/

I did open the SQL file in Notepad++ and that collation is used in numerous places throughout the file.

[mc12345678]

May want to provide more information about your XAMP setup, while this site is predominantly for the care of the eCommerce software and database, there may be more assistance available to help.

Right now it looks like either a table or portion of the database has been defined to a collation that just doesn't exist or to one that is not supported by the installed software... in either case it should be resolvable.

[g2ktcf]

May want to provide more information about your XAMP setup, while this site is predominantly for the care of the eCommerce software and database, there may be more assistance available to help.

Right now it looks like either a table or portion of the database has been defined to a collation that just doesn't exist or to one that is not supported by the installed software... in either case it should be resolvable.

phpAdmin 5.1

Server: 127.0.0.1 via TCP/IP
Server type: MariaDB
Server connection: SSL is not being used Documentation
Server version: 10.4.21-MariaDB - mariadb.org binary distribution
Protocol version: 10
User: root@localhost
Server charset: UTF-8 Unicode (utf8mb4)

XAMPP for Windows 7.4.25

Apache/2.4.51 (Win64) OpenSSL/1.1.1l PHP/7.4.25
Database client version: libmysql - mysqlnd 7.4.25
PHP extension: mysqli Documentation curl Documentation mbstring Documentation
PHP version: 7.4.25

[g2ktcf]

Okay, its a new install, so I can always just redo the whole thing. I followed only half the info in the above link replacing all 120 instances of utf8mb4_0900_ai_ci with utf8mb4_general_ci.

The import seem to go without a hitch. The data seems intact. Does anyone know the specifics between the two different collations?

Thanks
Chris

[torvista]

utf8mb4_0900_ai_ci
Never seen that before....probably because no it is not in a Xampp setup at the moment, so yes it probably would complain when trying to import a database that specifies it.

No doubt Xampp will add this in the near future and you wont have a problem.