Title: problem exporting the database
Last modified: August 18, 2016

---

# problem exporting the database

 *  [jrumol](https://wordpress.org/support/users/jrumol/)
 * (@jrumol)
 * [20 years, 9 months ago](https://wordpress.org/support/topic/problem-exporting-the-database/)
 * Hello everyone,
 * I have a wordpress website and i manage the mysql database with phpmyadmin.
 * When I created the database I think I used a character set “spanish latin1” or
   something like that. And now, when I do a backup of the database using myadmin
   there are problems with the letters with accents and the letter ñ, they appear
   as strange characters.
 * Do you know how to fix it?
 * Thanks in advance,
 * JRRM

Viewing 2 replies - 1 through 2 (of 2 total)

 *  [Mark (podz)](https://wordpress.org/support/users/podz/)
 * (@podz)
 * [20 years, 9 months ago](https://wordpress.org/support/topic/problem-exporting-the-database/#post-261127)
 * Those characters may well appear strange when you look at them in the database,
   but when they are printed to screen the browser should take care of them and 
   convert them appropriately. I wouldn’t worry too much.
 * You could test this by creating another WP install as a test site and importing
   the file there. If you need any advice about this, do say 🙂
 *  Thread Starter [jrumol](https://wordpress.org/support/users/jrumol/)
 * (@jrumol)
 * [20 years, 9 months ago](https://wordpress.org/support/topic/problem-exporting-the-database/#post-261162)
 * I’ve done that already.
 * I decided to have an installation on my computer so that I can make changes on
   local. When I load the database in local all the strange characters came into
   the webpage.
 * How do most of the people do the backups of wordpress?
 * Thanks in advance,
 * JRRM

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘problem exporting the database’ is closed to new replies.

## Tags

 * [character](https://wordpress.org/support/topic-tag/character/)
 * [database](https://wordpress.org/support/topic-tag/database/)
 * [MySQL](https://wordpress.org/support/topic-tag/mysql/)
 * [set](https://wordpress.org/support/topic-tag/set/)

 * In: [Installing WordPress](https://wordpress.org/support/forum/installation/)
 * 2 replies
 * 2 participants
 * Last reply from: [jrumol](https://wordpress.org/support/users/jrumol/)
 * Last activity: [20 years, 9 months ago](https://wordpress.org/support/topic/problem-exporting-the-database/#post-261162)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics