Re: [Tikiwiki-users] migrating German content

[Damian P. <da...@da...>]

Marko Riedel wrote:
> Hi folks,
>
> we are trying to migrate our Tikiwiki installation from 1.7.4 to
> 1.9.4. The new installation is on a different machine than the old
> one. So we create a mysql dump of the old wiki with PHPMyAdmin and
> pipe it into MySQL on the new machine, thereby recreating the tables
> from 1.7.4. After that, we run the various migration scripts in the
> TikiWiki 1.9.4 installer, e.g. "1.7 to 1.8" and "1.8 to 1.9" etc.
>   
Dont forget there are two extra upgrade scripts from 1.7 to 1.8 see the 
UpgradeTo18 page on tikiwiki.org

> The data seem to be migrated correctly e.g. all user accounts work.
>
> The problem is that the German Umlauts disappear during the
> process. The new install displays them as stars or as the "unknown
> glyph" in different browsers.
>
> How can I find out what encodings the two version are using? Is there
> a MySQL command that sets the encoding to use for the contents of a
> MySQL dump?
>   
Will need to be set to UTF-8


Damian Parker