Import changes charset

[Swedie]

I've exported a vbulletin databas and it uses Swedish characters.

The SQL-file includes characters such as å ä ö, but they turn into UTF-8 format when I'm starting an import via MySQL source.

For example: Jåke becomes JÃ¥ke

What am I doing wrong? The table setup (charset etc) is identical, but the usernames, posts etc are all changed to UTF-8 characters.

What changes do I have to do in MySQL > source ****.sql

[Marco van Herwaarden]

If you use the same characterset for both the source and target database, then there should be no conversions.

[Swedie]

Yep, i'm using BigDump now and I found the setting for charset. Changed to UTF8 and it worked fine now.

But I'm stuck on the attachment-table. I get: MySQL: MySQL server has gone away constantly as soon as I hit a certain few attachments...

Any tip how to get around that problem?

But how can I change charset via mysql source? I tried charset_name but it only says changed but nothing really changes when I type status.

[Marco van Herwaarden]

You can not just change the charset. If you change the charset then you will most likely also need to convert the data.

Server gone away error should be resolved by your host.

[Swedie]

I think I figured it out myself... oddly enough =)

Bigdump will fail if it encounters attachments (or insert queries) that are larger than 450kb... so I deleted all attachments bigger than that. Looks to be working now.