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

Main Menu

Show posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Show posts Menu

Messages - grimborg

Support Requests / wrong encoding in mysql import
May 15, 2006, 02:32:32 PM

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.