phpmyadmin - transfer data?

Hello,

I’m trying to transfer some local modx data to the server after more or less finishing a website - however, I’m having difficulties especially with German umlauts (special characters). Is there anybody who could give me some detailled instructions on how to properly transfer the database data incl. those special characters.

Thank you in advance for your input.

It may have something to do with the "collation" of the tables; make sure they’re the same on the source and destination tables. You might double-check on that by searching at MySQL.com... I’m not totally certain though, and I’m sure someone will have better insight.

it seems that the local database is utf8 and remote it seems to be latin1 - couldn’t figure out yet how to transfer my database.

These two pages might be helpful for you. Hopefully you’re moving between the same database version:

http://forums.mysql.com/read.php?103,25921,25921

and

http://dev.mysql.com/doc/mysql/en/charset-conversion.html

Looks like it’s not exactly a simple process!