Hi! See this thread http://moodle.org/mod/forum/discuss.php?d=36884#170509 for notes on how migrations should be done. Backup/restore isn't the preferred method if you are transitioning a whole Moodle setup.
Backup and restore
Backup from Postgres and Restore to Mysql?
This discussion has been locked so you can no longer reply to it.