roopurt18 Posted November 3, 2006 Share Posted November 3, 2006 My company is talking about switching webhosts and I would be in charge of migrating our current website to the new host.Our site is actually a web product. Every time we pick up a new client they receive their own database and their own data directory. They have unlimited access to uploading files (through our site) as well as bandwidth.So in addition to the normal moving of PHP code from one server to another I'd also have to move client data directories and client databases.Can anyone offer some advice or suggestions to make such a move easier not only us but our clients? This would be the first time I've taken on such a task and would really like to not screw it up! Quote Link to comment Share on other sites More sharing options...
Zane Posted November 3, 2006 Share Posted November 3, 2006 Well depending on your connection...Most of the time a hosting server has a good connection preferably T1.If it's going to be your last month and you get plenty of bandwidthI'd recommend transfering Server to Server.Of course that'd mean you have to create a custom Database transfer scriptusing DUMP commandsbut it's better than copying to your Hard Drive and then uploading to another place Quote Link to comment Share on other sites More sharing options...
roopurt18 Posted November 3, 2006 Author Share Posted November 3, 2006 I was considering the possibility. I would imagine I would be dumping all of the databases into some directory on our current host and then using a .tar and ftp'ing from one host to the other.Would I be faced with a lot of complications in directory permissions or would those be preserved? I know enough in *nix to be dangerous but by no means am I a proficient user. Quote Link to comment Share on other sites More sharing options...
Zane Posted November 3, 2006 Share Posted November 3, 2006 Well if you FTP it over, that's 3 ports80 and 3306 to get the Dataand then 23 to transferand then 80 and 3306 on the other server again to insert it.If you just Insert into the database directly from your old serverthat's just 280 and 3306 to get itand then again to sendI guess what I'm getting at isyou dump the data to an sql file from a php scriptconnect to your new servers DB from your old serverand use mysql_query with the contents of that SQL file you madeand do that for each database Quote Link to comment Share on other sites More sharing options...
roopurt18 Posted November 3, 2006 Author Share Posted November 3, 2006 Got it.Since I'm a noob, what's so bad about the 3 ports? Just curious... Quote Link to comment Share on other sites More sharing options...
Zane Posted November 3, 2006 Share Posted November 3, 2006 it's just more you have to transfer....that's all 80 3306 80 21 80 3306HTTP->MYSQL->HTTP->FTP->HTTP->MYSQLas opposed toHTTP->MYSQL->HTTP->MYSQLHTTP being your PHP script doing work Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.