News:

Click here for Toll-Free Service for your business starting at $2.00 per month

Main Menu

wrong encoding in mysql import

Started by grimborg, May 15, 2006, 02:32:32 PM

Previous topic - Next topic

grimborg

Hi

I have imported the database of my mediawiki site into freepgs, but the encoding is wrong: the file I upload is encoded in UTF-8 but when I import it it's converted into something like ISO-8859-1, and so the page doesn't render right.

The procedure I've followed is:
a) mysqldump the database in my pc. Running "file" on the dump returns "per.sql: UTF-8 Unicode English text, with very long lines"
b) gzip it
c) import it via the freeogs mysqladmin page

I've been considering writing a php script to fix the encodings but there's quite a lot of tables, I'm hoping there's a way to do the import right from the start.

Thanks