Is it possible to convert a .mysql file to a .sql file?
For the records, I finally managed to load my dump into Acquia Dev Desktop after renaming the file to .sql and specifying/using exactly the same database name as the original database name.

I don't know what caused the original issue or what solved it, since I don't believe the database name should be an issue at all.