Forum

utf8_general_ci err...
 
Notifications
Retirer tout

utf8_general_ci error when copy database to new server

3 Posts
3 Utilisateurs
0 Reactions
4,831 Vu
(@vanlele)
Posts: 10
Eminent Member
Début du sujet
 
[#4653]

Dear,

I move my projeqtor to another database by opration/copy database in myphpadmin but after copying it get error in font.

Can you help me please?


 
Posté : 21/09/2017 10:03 am
(@babynus)
Posts: 14952
Membre Admin
 

The encoding in the servers is different.
The MySql database must be full UTF-8.
See MySql docs (and in this forum) to correctly configure target server.
If it is correct, mayby origin was not, so you'll have to convert to UTF-8 the dump file (using Notepad++ for instance)


 
Posté : 21/09/2017 10:14 am
(@richard-pare)
Posts: 165
Estimable Member
 

Probably the dump is the problem.

Look this blog which proposes a better way to dumping and importing.

https://makandracards.com/makandra/595-dumping-and-importing-from-to-mysql-in-an-utf-8-safe-way


 
Posté : 21/09/2017 7:09 pm
Share:
Retour en haut