News:

LVCS.NET offers low cost domain registration services.

Main Menu
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

Topics - grimborg

#1
Support Requests / wrong encoding in mysql import
May 15, 2006, 02:32:32 PM
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