New installation in progress

No

1. Remove all the files for your version 7 forum (accept the Access database file if using the Access version)
2. Run the database upgrade tool
3. Upload version 9
4. Edit the file database/database_connection.asp so that it points to your database

You do not follow the instructions at http://www.webwiz.net/WebWizForums/kb/mySQL_install.asp as these are for a new installations with a new database.

As to why you would be looking at the mySQL instructions I don't know as version 7 did not have support for mySQL. If you are using mySQL then check that you are not using version 8, as mySQL was only supported from version 8 onwards.

Okay.

1. I asked the web host to restore the database and he emailed me that he had
2. I deleted all of version 7 out of the forum directory.
3. I uploaded the Database Upgrade Tools, went to (my forum) Database Upgrade Tools/upgrade.htm and chose to upgrade from ver. 7.
4. This is what I got back:
Database Updated Started

Stage 1: Database Connection..... Complete

Stage 2: Creating New Database Tables and Fields.....
Error Updating the Table tblForum
Column names in each table must be unique. Column name 'Sub_ID' in table 'DBO.tblForum' is specified more than once.


Error Updating the Table tblTopic
Column names in each table must be unique. Column name 'Icon' in table 'DBO.tblTopic' is specified more than once.


Error Update the Table tblThread
Column names in each table must be unique. Column name 'Hide' in table 'DBO.tblThread' is specified more than once.


Error Updating the Table tblPermissions
Column names in each table must be unique. Column name 'View_Forum' in table 'DBO.tblPermissions' is specified more than once.


Error Dropping Contraints in Table tblPermissions
ALTER TABLE DROP COLUMN failed because column 'Read' does not exist in table 'tblPermissions'.


Error Altering the Table tblAuthor
Column names in each table must be unique. Column name 'No_of_PM' in table 'DBO.tblAuthor' is specified more than once.


Error Altering the Table tblConfiguration
Column names in each table must be unique. Column name 'ID' in table 'DBO.tblConfiguration' is specified more than once.


Error Altering the Table tblDateTimeFormat
Column names in each table must be unique. Column name 'ID' in table 'DBO.tblDateTimeFormat' is specified more than once.


Error Creating the Table tblPollVote
There is already an object named 'tblPollVote' in the database.


Error Creating the Table tblSession
There is already an object named 'tblSession' in the database.

Complete

Stage 3: Creating Index's on database.....
Error Creating one or more Index's
There is already an index on table 'tblSession' named 'Session_ID'.

Complete

Stage 4: Entering default values for new fields.....
Error entering default values in the Table tblConfiguration
Invalid column name 'Upload_allocation'.

Complete

Stage 5: Populating Database with Default Forum Permissions (this may take some time to complete).....
Permissions are reset to original defaults, you may need to update them once the upgrade is complete.
Complete

Stage 6: Populating Database with Forum Statistics (this may take some time to complete).....Complete

Stage 7: Populating Database with Topic Statistics (this may take some time to complete).....


The database was backed up before any of this was begun.  Any suggestions?

The error messages that you have suggest either that you are running version 8 database, or you have already run the upgrade tool on this database.

Have a look inside your original database, if it has a tblSession table, then you are using version 8

If your old forum also has a calender system then you are certainly using version 8 as the calendar systems was only introduced in version 8.