By vedix on

Hello drupal users,

i solved my problem with moving Drupal, but i got a new one. I use czech language on my page and all is ok, but after moving, some czech characters are broken. I mean, i get some pictures instead.

Please, can you tell me how to corectly export whole Drupal database and how to import? Are some special flags needed? For moving i used PhpMyAdmin and never changed code page, so i thing all must be UTF-8, asi it's in Drupal.

If you have some hints, please shoot, i'll try, i hope this is my last problem with drupal, because i love it and when i'll be able to move it (to save it and restore) i have all i need (i hope :) ). Stanley

Comments

gerd riesselmann’s picture

gerd riesselmann commented

If you are using MySQL Administrator to dump you local database, remove the code at the beginning and end of the file (which starts with "@" and sets encoding) so only the table creates and inserts remain. That's how I did it yesterday and it worked.

If there are still problems, try saving the dump file in another encoding (if it is UTF save as "Chech ASCII", if it is ASCII save as UTF8). I had to do this a year ago with a database containing German special chars , but don't remember the details :-(

------------------
Gerd Riesselmann
www.gerd-riesselmann.net

vedix’s picture

vedix commented

I'm using MySQL and i'll try, thanks for advice, Stanley