Changing server question

Hi

I currently have a web site, on a linux server, hosted by a hosting company, however the hosting company is so rubbish there is no way in the world i will pay them money again on any site.

My problem is it runs chillisoft asp, and I have a mysql database which i would like to copy to take use on the new hosting company, what is the best way to do this or is it not possible?

i would be happy creating a page that takes att the data and loops it putting it into an access db, then uloading from the access db onto my new server, a pain yes but better than typing in all the info again, but i don;t think it will run an access DB, cos its a linux server, any ideas?

Cheers for any help

I'd stick with the mysql db. My windows hosting company (crystaltech.com) offers mysql and php, as well as asp.

There should not be too much tweaking from a chilisoft server. There are quite a few hosts that offer chilisoft if you'd rather stay in that environment.

Hi i am not bother which hosting I am and yes i would prefer to stay with mysql, but would prefer to goto windows based.

but thats not the issue, my issue is how to I change servers and but not loose all the information held in the DB's?

Cheers

You have to copy the data out of the existing database and then load it into the new database. If you are going from mysql to mysql you can use tools like the mysql Administrator or mysqlFront to migrate the data.

If you go to a different dbms like sql server, you'll probably have some database structure adjustments to make, and some code to change.

thanks much appriciated, will look into it a bit further