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?