The Import
The proper upgrade route is as follows:
1. Download UBB.Threads 7.x (full install file) AND the UBB.Threads 6.5.x importer and extract them to your hard disk.
2. Install UBB.Threads 7.x in a NEW directory (UBB.Threads7 is a completely different product than UBB.Threads 6.x, thus, it is not a simple "update new files and run upgrade.php" upgrade).
3. Go through the new install procedure (yourforums.tld/forums/install/install.php) until you reach the "create admin user" screen.
4. Run the UBB.Threads 6.5 to UBB.Threads 7.0 importer.
5. Import Complete.

Re-Using your old location
If you want to re-use your old directory, simply delete (or rename) your old forum directory, and then rename the directory which houses UBB.Threads 7.x; any updates to paths will need to be made to the config.inc.php file in the UBB.Threads7 includes directory.

Redirecting to the new software
Now, if you want to redirect all requests from the old directory, do the following:
1. Open the redirector files which came with the importer and edit the line that points to your install directory and set the url accordingly.
2. Upload the files to your OLD install directory.

It should be perfectly safe to upload these files into your UBB.Threads7 install directory (if you opted to use the old install directory in section 2) as UBB.Threads7 does not use these file names.

Conclusion
Now any requests that go to your old forum location/files should be redirected to your UBB7 install.

I may be completely odd in this problem (usually am)

When I start the importer, I get this (among other errors later on)

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /raid/home/dancesafe/dancesafe/booth/libs/mysql.inc.php on line 227

Upgrading from 6.5.4

Color me lost.

Per what I have been able to find on the net, it seems most times it is a query issue.. but I am using the downloaded importer from Groupee.

Thoughts? Or should I say what more info might you need?

You should post this at UBBCentral in the Import forum as Rick would be the man to troubleshoot the importers.