Encoding problem

[Nikos - Vasilis Merianos]

Hello. I have a problem to migrate a MySQL database from the Server "A" to Server "B"

I have try to get the mysql data from the server "A" with several methods. The one is to get the backup file from with in the CPanel backup section. This method return back an *.sql file. The other method is by using the phpMyAdmin to extract the database records as it does, and also in this way I get an SQL file.

The broblem now. In Server "A" I don't know what is the database/table/column encoding, and the data that I get back are wrong.

What I mean, the site that uses this data is a Wordpress web site, on runtime the data are all readable by the end user, but on backup files are encoded in some way that I don't recognize.

Here is an example of data in my sql files

Η Ελληνική Κοινότητα του Wordpress στο Twitter

The above is a code in *.sql file that I get from the server. Any idea on how to get the correct encoding ?

Kind regards
Merianos Nikos

http://www.web-resources.eu