Now my blog is up and running on my new host and new database.
Here is where the initial problems occurred:
Firstly, I wanted to remove the prefix of my blog tables as they were going to be placed in their own database rather than just having prefixes. The way I did it was to move each table into the new database and rename each of them without the prefix. Then I downloaded that whole database (using phpMyAdmin, not WordPress). Next I changed wp-config.php such that it had no prefix and pointed to my new database. I dropped (deleted) the database and created a fresh new one with the same name. I then took the whole database SQL commands to Notepad (thank you Notepad!!!) and removed all instances of the old prefix. To finish off, I then used the Import feature to import all of the SQL commands into my new database. And that's all there is to it!
All my tables are now divided up into databases for each, therefore there is less of a security risk (I have a set of users, each user manages a certain database and has no access to others).
The other thing about this multiple database idea is the neatness and organisation. I'm really happy to have changed hosts and later I will post about what's really nice with this new hosting package.
