Going to close it since I resolved it myself. No thanks to WP for issuing a buggy system.
For those that are interested, this is how I did it.
Make sure you back up your site and database.
I did a fresh install of wordpress, I then deleted everything but usermeta and users table from the data base and imported backed up database minus the usermeta and users table.
I then just uploaded the backed up wordpress site minus the wp-config.php file and it now works