19
I'll take one more stab at this...
I just accidentally deleted an unrelated database thats included with my site. My backup was 5 days old, so I didn't loose much more then some basic configuration options.
Anyway, I went back into phpmyadmin and copied the SQL data from the file into the query window and everything came back in a snap.
It was my first time doing it this way instead of uploading from a pre-existing .sql file.
If your db name is created before you run the query, you may need to edit your sql file to not create the db and just dump the tables as needed. If your DB has not been created (although it should by now) and your sql file has a string to create a new db, then leave that in there to create it. I'm sure you'll see what I mean once you get that far.
Remember though, when you do yours and you go back into your XOOPS admin and start adding modules, your imported data will get over written if it was successfully imported. I beleive your goal is to restore your old db info, so be carefull not to overwrite existing data.
I know your having other problems at the moment that need to get sorted out, but you can always come back to this thread when your ready. If things arn't done in the right order, you may not get the rusults you are looking for, so pay close attention to what you want to acheive before moving ahead to other steps.
Hope this helps a tiny bit. I learned something new today and feel all the better for it.