I've just completed a move of our Moodle installation from our old server running PostgreSQL to our new server, which is running MySQL.
The backup/restore functionality of Moodle enabled me to pull off this potentially nightmarish task in less than 30 minutes.
To all that worked on the backup/restore feature: THANK YOU!!!
Eloy Lafuente deserves at least 95% of the credit for this.