Changing Database Server
 

Hi,

I setup our vB install yesterday on the same server I've been running out old Vanilla forum on. I've been getting regular server errors and been told by our host that the database server we're using is under heavy load and I should create a database on one of their other servers.

Now, I've asked them to set that up for me on their best server so in the mean time I need to find out how to make the switch.
The forum isn't yet 'open' as such, I've got a few people testing it so its not a massive issue for users at the moment. I'm guessing the process will be fairly simple but please correct me if i'm wrong;

- Close forum/enter maintenance mode
- Backup database
- Upload tables to new database
- Reconfigure the database settings in the admincp

will that be the best way of doing it? and also, where in the admincp are the database settings?
thanks.