Hi All, im now about to move the whole site over from my old host to my VPS but wondering how i go about it and how i move the databases over?

I have moved all my files via ftp over so the files should be there but i assume i need to move the db also?

Dump the database and zip it up. FTP it to the new server. Unzip and import it to a new db. Set up the config with the new database info.

Log in to your shell account and dump the database:

mysqldump -u<username> -p<password> > /path/to/dump/db/databse.sql

Change <username> to your mysql username. Change <password> to your mysql password. Change /path/to/dump/db/databse.sql to path you want to save the dump. Compress the file.

tar -cvf mysql.tar /path/to/dump/db/databse.sql 

Now download the compressed file and upload it to your new server. On the new server decompress the file:

tar -xvf mysql.tar

Then use mysql to import the database into the new database on the new server. First create the db:

mysqladmin -u<username> -p<password> > create <database-name>

Once the databse is created you import the mysql dump that you extracted.

mysql -u<username> -p<password> <database-name> < /path/to/extracted/db/databse.sql

That should do it.