Is it possible to restaure a .sql file encoded in utf8 to mysql with
mysql client set to latin1?
I've got a forum on a server which has got it's client set to utf8
I need to move the forum to a new server. But this new server has got
postfix and proftp that seem to need the mysql client set to latin1
I can only dump the database using phpmyadmin and phpmyadmin puts errors
in the sql file if I ask it to transform the file to latin1 as utf8
contains some characters that latin1 does not.
So my dump file has to be in utf8. But with mysql client set to latin1 I
get copyright symbols instead of accents. And it is impossible to see
the posts on the forum or connect to the forum.
My dump file is about 90Mb so it's not possible to restore it with
phpmyadmin. So I use this command :
mysql -u root -p < dump.sql
If the mysql client is set to utf8 all characters are copied correctly
but proftp and postfix stop working.
If mysql clien is set to latin1 all characters with accents are bady
coppied and the forum is unusable, but proftp and postfix work.
So is there a way to restore the sql dump file to mysql with the mysql
client set to latin1
|• restaure a dump.sql file encoded in utf8 to a mysql server with mysqlclient set to latin1?||Richard||26 Feb|