Then konvert the UTF-8 Strings:
utf8-fix.pl dump.sql
And then instert the new data to the Database (or better into a new Database)
mysql --host=<DB-Host> --user=<DB-User> --password=<DB-Passwd> --database=<DB-Name> < dump.sql.converted
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
If You should see "Schüler können mähen"
but You see something like "Schüler können mähen" You should fix your Database.
First make a latin1 mysqldump:
mysqldump --host=<DB-Host> --user=<DB-User> --password=<DB-Passwd> --quick --no-create-db --add-drop-table -c -l -C --default-character-set=latin1 --default-character-set=latin1 <DB-Name> > dump.sql
Then konvert the UTF-8 Strings:
utf8-fix.pl dump.sql
And then instert the new data to the Database (or better into a new Database)
mysql --host=<DB-Host> --user=<DB-User> --password=<DB-Passwd> --database=<DB-Name> < dump.sql.converted