MYSQL-complications

[jestem pro]

Hello. Since I have created my website I cannot log in my database... because of this error:

#1273 - Unknown collation: 'utf8mb4_unicode_ci'

Website: acc maker Gesior2012
Application: Xampp
TFS: 0.3.6(8.6)

I found many solutions, but the half not related to TFS. The one is to change this:

utf8mb4_unicode_ci

for this:

utf8mb4_unicode_520_ci

in mysql.sql file that part :

ENGINE = utf8mb4_unicode_ci;

for this:

ENGINE = utf8mb4_unicode_520_ci

but I have only this:

ENGINE = innoDB;

and what, when I won't be able to import that again to my database coz I cannot even log in.

Had someone have that error in yourself life?

 

[slaw]

If your mysql server doesn't support utf8mb4_unicode_ci, then I suggest using utf8_general_ci

It's not engine, but collocation what you should change.

So, like this:

ENGINE=InnoDB COLLATE utf8_general_ci;

About login issue - Maybe you can login with command line interface with mysql command and then execute this on your database: https://stackoverflow.com/a/9531221/1055314

 

[Webtimize]

This error is due to a wrong exported collation format. You're probably trying to import a scheme that has been exported with an older MySQL version.
Replacing the collation with a correct one for your setup can be done via find and replace in any texteditor. A general fix can be done with replacing the collation with 'utf8_general_ci'.

 

[jestem pro]

It worked until I didn't create the website so this caused that error.
I've read that maybe I have an old version of Xampp.

But what will it get when I will make changes in mysql file when I'm not able to import that?

And I have never used the command line, so it would be nice and thankful if you could tell me something more about this.