Title: WordPress export
Last modified: August 19, 2016

---

# WordPress export

 *  [wifi_jirka](https://wordpress.org/support/users/wifi_jirka/)
 * (@wifi_jirka)
 * [17 years, 7 months ago](https://wordpress.org/support/topic/wordpress-export/)
 * Hallo,
    I would like to upgrade my WordPress to newer version. From some reasons
   I decided to do it via export.
 * In my old WP instance, I noticed that there is this collation : cp1250_general_ci
 * So I exported my czech-language blog using function “export” which is accessible
   directly in WordPress. XML file was created. I found that there is this definition
   <?xml version=”1.0″ encoding=”UTF-8″?>
 * I installed new instance of WordPress (2.6.2) on different hosting. There is 
   some self-instalation package (from fantastico). After this installation i noticed,
   that new database has collation : latin1_swedish_ci
 * So i used command :
    ALTER TABLE wp_posts CHARACTER SET utf8 COLLATE utf8_unicode_ci
   and collation in database was changed …
 * Then I imported XML file from old blog. It shows all post_titles with right czech
   characters (č,ř,ž,..) during importing.
 * But when I look at blog, all this character was replaced by “?” and also in database,
   there was these characters replaced by “?”
 * So what I should do to correctly import old XML file ?
 * Thanks much

The topic ‘WordPress export’ is closed to new replies.

## Tags

 * [collation](https://wordpress.org/support/topic-tag/collation/)
 * [czech](https://wordpress.org/support/topic-tag/czech/)
 * [language](https://wordpress.org/support/topic-tag/language/)
 * [MySQL](https://wordpress.org/support/topic-tag/mysql/)
 * [UTF](https://wordpress.org/support/topic-tag/utf/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 0 replies
 * 1 participant
 * Last reply from: [wifi_jirka](https://wordpress.org/support/users/wifi_jirka/)
 * Last activity: [17 years, 7 months ago](https://wordpress.org/support/topic/wordpress-export/)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics