Forum Moderators: coopster
I have one script that I use in many of my 50+ domains spread over four or five hosting companies.
Suddenly in the last few weeks I'm having one problem after another that in every case falls back to some kind of problem on the server. One company is so bad, the support is so unresponsive at times, that the only thing that has kept me there the last year is the nighmare of moving (if possible) the contents of all of those databases and reinstalling the script on many dozens (lots of subdomains running the script, as well) of locations. (But, I went off topic. Sorry. Lousy support is a different issue. Back to the mysql problem)
If everything was on static pages (very possible) moving would then be a piece of cake. If a hosting company is unresponsive to problems I can have the site up and running elsewhere within the hour.
So, my question is, have I been living a charmed life in NOT having mysql problems for the previous year? Are my recent multiple mysql problems from two separate companies purely coincidence?
I'm ready to convert everything to static pages at this point.
P.S.
1. there have been repeated mysql "connectivity problems" with one company. "Sorry. We have the problem fixed now.". But, it happens again.
2. In another instance, support insists the db is there when I say it is not there. Finally, they log in through my cpanel and find that I'm correct in that the db does not show on the cpanel nor does phpmyadmin show it. They restore a backup for me.
3. I'm still waiting to hear the excuse for why my domains with one company are all loading very slowly and it's virtually impossible to view the directiory with the script while it's only extremely slow to load on others.
I would say that if your hosts can't get mysql squared away, you may need to go shopping. Perhaps someone else on your shared server just hit the jackpot or is getting attacked. Or has some server-intensive script running.
If everything was on static pages (very possible) moving would then be a piece of cake.
Actually, I think I can move a php/mysql site faster than a static site (less redundant HTML) and certainly in less time than I will spend going round and round with an incompetent host.
It may depend a bit on how you have written your code and how portable it is, but it should not be that hard to move
- move the scripts over
- create a dump of your DB
- upload the dump to the new server
- update the db access info in the script
Done!
The more significant issue is the time it takes the DNS changes to propagate. You'll want the two servers to overlap for a month or so and set the old one to redirect to the new one.
Ask around, look around, just find a new host...it'll be worth it.
