Exporting mysql from old site = problems

I am trying to export my mysql database from my old site using phpmyadmin, but i get tons of crazy characters replacing common characters like " and '… The old MYSQL version is: MySQL - 5.0.22-Debian_0ubuntu6.06.2

Is there some kind of “SQL export compatibility:” setting that i need to use?

Sounds like something with your charset… I am not an expert in that, but I had my own problems with it (international characters).

How do you export and import your database, as .sql file or copy/paste, if the db is small enough?