Importing worked now, but I still haven't been able to solve the encoding problem.
When I first created the database I even did:
Code: Select all
CREATE DATABASE phpbb CHARACTER SET latin1 COLLATE latin1_swedish_ci;
Then added what you said, SET CHARACTER SET latin1 at the top of the sql-file.
Imported it with
Code: Select all
mysql -p --default-character-set=latin1 phpbb2 < topics_posts_phpBB.sql
Result:
http://img378.imageshack.us/img378/817/forumoj4.jpg
Well, not only is the characters not being displayed correctly, linebreaks do not work, (related I guess) the whole layout get's destroyed, maybe also because of the charset?
Also quotes are not working (adds "quote:d30223329cd=NAME" etc. And lastly some topics with a lot of pages do not work.
An example is a topic with 80 pages, forst few pages work fine, but if you try to go to the last couple of pages in the topic it will say that it doesn't exist.
So, as you can see I have a LOT of issues here, and I have no idea where to start.
EDIT: I fixed the charaters problem! It was in my php.ini.
I set the default charset to latin1 there, and then it worked.
However, the layout is still broken, same with linebreaks and quotes too and some pages don't work.