MySQL: Special chars and umlauts broken after exporting/importing dump?

Question

I built a website locally using xampp. Now I want to put it on my server. I uploaded the code and now its time to import the database. So I exported it locally on the command line using:

mysqldump -hlocalhost -udb123456  -p123456 db123456 -e --default-character-set=utf8 > backup.sql

Now I created a new database on the server and imported this file using phpmyadmin on the server. The char set was set to utf-8 in phpmyadmin. When I open my site now, special chars like ü or € are shown as Ã¼ for example.

I can not import the dump using a console on the server, I may only use phpmyadmin.

What did I do wrong?

Thanks!

what about the meta tag of your site? maybe you have a different charset there? — nowhere, Oct 13 '15 at 09:54
@nowhere - I have the same problem. I added to the page, but nothing changed. — Valter Ekholm, Aug 18 '21 at 18:02

score 0 · Answer 1 · answered Aug 18 '21 at 18:14

0

I had a similar problem. I solved it in the PHP code, as described here

PHP PDO: charset, set names?

(assuming you use PDO)

answered Aug 18 '21 at 18:14

Valter Ekholm

173
2
17

MySQL: Special chars and umlauts broken after exporting/importing dump?

1 Answers1