How to Move Database from Other Host to This Host?

[Daryl Fawcett]

I am considering setting up an account here, however, before deciding to do that, I need to know that I can transfer my MySql Database from the other Host Site to this Host Site.

Can you explain to me how this can be efficiently and most quickly accompished?

[Daryl Fawcett]

I actually want to move the whole site content from the other Host Site to this Host Site.

[Daryl Fawcett]

Seeing I haven't received a reply yet, the word is more on how to transfer or copy the MySql Database from one host server to another host server.

What I want to do is to leave the other one intact and operating until I know the new one has been copied OK and is up and running OK as well.

[felgall]

To copy a database from one place to another.

1. Create the new database.
2. Create a user and password with access to the database.
3. Take a backup copy of the original database (if you have phpmyadmin then the easiest way is to export the database).
4. Restore the backup to the new database (if you used phpmyadmin to export the database then use the phpmyadmin import option for this.
5. Copy the scripts that use the database.
6. Change the database name and username in the appropriate config file within the script to refer to the new database and user (unless both hosting accounts allowed exactly the same naming conventions and you were able to leave the names the same).

See http://www.felgall.com/hosts.htm for more information on moving web sites between hosting accounts.