After doing so, I've decided to change my configuration as follows in the client-stanza of /etc/mysql/my.cnf:
…
…
default-character-set = utf8
…
IMHO it should be set to the charset of the operating system the server is running on.
Since they are both communicating in utf8 I'm able to backup every database named with non-ascii characters.
To check the default-configuration of a mysql client programm use:
mysql -print-defaults
mysqld -print-defaults
mysqldump -print-defaults
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Anonymous
-
2010-08-02
Problem solved - I changed all the tables to be utf-8_general _ci and everything worked ok. Previously they had been latin1 for some reason.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Spanish characters are not being recognized by the backup.
I get elección instead of elección and so on.
How can I solve this problem ?
I also have this issue - is it something that I can fix with configuration?
Can you post the complete error, please!
Also make shure you're using the latest version.
This time I'm poking around with special caracters in names of databases. I thougt it was a good idea to consult the docs of the database-server-software: http://dev.mysql.com/doc/refman/5.1/en/charset-unicode.html.
After doing so, I've decided to change my configuration as follows in the client-stanza of /etc/mysql/my.cnf:
…
…
default-character-set = utf8
…
IMHO it should be set to the charset of the operating system the server is running on.
Since they are both communicating in utf8 I'm able to backup every database named with non-ascii characters.
To check the default-configuration of a mysql client programm use:
mysql -print-defaults
mysqld -print-defaults
mysqldump -print-defaults
Problem solved - I changed all the tables to be utf-8_general _ci and everything worked ok. Previously they had been latin1 for some reason.