Upgrading issues = horror brokeness

So i wanted to upgrade my version of WP and it all went horribly wrong. From reading posts and the support docs on how to upgrade i decided to go for a clean install of the entire DB.

So i backed up the DB throught phpMyAdmin and then deleted the db entierly. I also deleted the worpress files on my server.

Next i created a new DB. I impotrted the old DB backup file.

I uploaded the new WP files.

Next I ran the upgrade php file in the admin and i got the following:

WordPress database error: [Table ‘irishmar_wpdb.wp_options’ doesn’t exist]
SELECT option_value FROM wp_options WHERE option_name = ‘db_version’

WordPress database error: [Table ‘irishmar_wpdb.wp_categories’ doesn’t exist]
SELECT cat_ID, cat_name, category_nicename FROM wp_categories

WordPress database error: [Table ‘irishmar_wpdb.wp_post2cat’ doesn’t exist]
SELECT DISTINCT post_id FROM wp_post2cat

WordPress database error: [Table ‘irishmar_wpdb.wp_categories’ doesn’t exist]
ALTER TABLE wp_categories ADD INDEX ( category_nicename )

WordPress database error: [Unknown column ‘user_nickname’ in ‘field list’]
SELECT ID, user_nickname, user_nicename FROM wp_users

WordPress database error: [Table ‘irishmar_wpdb.wp_categories’ doesn’t exist]
SELECT * FROM wp_categories ORDER BY cat_ID

WordPress database error: [Table ‘irishmar_wpdb.wp_post2cat’ doesn’t exist]
SELECT post_id, category_id FROM wp_post2cat GROUP BY post_id, category_id

WordPress database error: [Table ‘irishmar_wpdb.wp_linkcategories’ doesn’t exist]
SELECT cat_id, cat_name FROM wp_linkcategories

then it says done but it shows none of my posts or anything. One thing i noticed was that ther error message is looking for wp_catagories, wp_comments and so on where as the actual files on the server in phpMyAdmin as wpi4f_catagories, wpi4f_comments and so on…

How can i get this all working again?