Transfering database from one host to another?

Question

I am transfering a website for someone from one hosting company to another. There are databases that need to be transfered and i am unsure on how to do this. Any suggestions or ideas.

Thanks

Answer 1

Whats the database type?



If its Mysql and you have access to phpmyadmin, you can export the database. If there is no access to phpmyadmin, you'll have to write a write a little code or find an example on the net.



If its MS Access, just copy the .mdb file.



If its MSSql Server, I'm not sure though I'm sure there is a sql statement that can be written that grabs the table structure and data.

Answer 2

hopefully, the current host will have a feature where you can export the data from your database(s). and then, the new host, will hopefully have a way to import that data.



if the hosts do not provide an easy interface to do the import/export, then they should provide you with the credentials where you can use a remote db management tool to perform the import/export from your own computer.

Answer 3

Any bad web hosting service would trouble you for a long period. At first, try to choose a reliable service to get rid of the subsequent problems.

Answer 4

MySQL to MySQL ?

Access to MySQL ?

MSSQL to MySQL?

MSSQL to MSSQL just use the Data Transformation Service.



and Vice versa.

Answer 5

ask your new webhosting company to help you out. the best one is bluehost webhosting



http://www.bluehost.com/track/bluehostwebhosting/