migrating access to mysql and mysql backup and restore

[Wouter De Wilde]

I am trying to migrate a replicated access-db to mysql on a different computer under windows.

The way I am doing this:
-Open the replicated access-db and export each table to mysql from withing access.
-Go to mysql, repair keys
-use mysql administrator to make a backup of the DB
-transfert backup to other computer
-use mysql administrator to load backup of DB on the other computer.

This workes fine, except for a few "details".
1. The replacated DB has a field called "s_GUID" (this is an autonumber field eg: {81F266C8-D5EF-497D-833A-E35AEF89E504}). This field gets all messed up when exporting to mysql.

2. When making a backup from the mysql-DB, characters like "ë" get transformed in other sequences like "ë". When importing this backup, it does not change the value back to "ë".

Can anybody help? How can I fix this problem?