Can somebody tell me how to move a complete website with its databases to a new hosting?Movement of content is no issue but how am i go to transfer the databases without having to create new ones on the new hosting
Export databases from old host, import it to new host and then you just need to change configuration parameters to config files of your script such as admin password (if not the same) db name and db location
I am a web developer and have moved numerous hosts and to numerous servers. I can assist you if you wish. depending on your setup it can be a pain in the ass. Even keeping same host and moving to a new server. Don't forget about nameservers which noone mentioned.
1. export the db from phpadmin (make sure you will export it as an archive).
2. archive your site folder and ftp it to the new hosting (to speed things up). If you do not have this option you will have to copy all the files to the new hosting.
3. unarchive your site folder. (if you did the step above)
4. create the db and import the sql file (after you unzip it) on your new hosting.
5. change the config.php file and modify the db connect details on your new hosting.
Done!
This works only when the databases are small enough to be imported completely before the MySQL timeout or php timeout interrupts the process. With large databases you need a better method. I like Navicat for large dbs but there are plenty of free methods including just busting apart the MySQL dump and importing it in smaller pieces.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.