Hi. I've decided to switch my webhost since they don't seem to care enough about helping us so i was wondering, how would i do when transfering to my new host? i've downloaded the database file, do i just import it to the new database?
SSH access is available on at least some sharesd server webhosting, I had it when I was with Dreamhost.
It may be worth asking your new web host if they can transferred the database for you. I use Nimbus Hosting who provided this service for me for free. I could have done it myself but I took up the offer as it costs nothing and saved me the hassle.