I just moved from godaddy to dreamhost (a few days ago), and had no problems.

What did I do?

1. Created DB on dreamhost using their control panel.
2. Downloaded all the files from godaddy to my computer, uploaded them to dreamhost.
3. Backed up db on godaddy using phpmyadmin.
4. Uploaded the resulting file with the same utility on dreamhost.
5. Edited mainfile.php and changed XOOPS_ROOT_PATH, XOOPS_DB_HOST, XOOPS_DB_USER, XOOPS_DB_PASS and XOOPS_DB_NAME.

That's it.