8
The very first time I moved my site, I reinstalled completely from scratch and reinserted the tables from backup.
In your case, upload all your files to the server and do a DB insert from your local copy of your SQL file.
A crude way to do this is to copy paste the info inside your local backup of the XOOPS.sql, and insert the tables through phpmyadmin.
I've done it that way a couple of times when I've been desparate to great success. All inforamtion was what was supposed to be. IT will work just fine, even if you don't have your modules uploaded yet. Do not reinstall modules over you DB, or else you will loose information though. All the information needed is in your .sql file, you just need to be sure that the modules are uploaded to the server, thats it.