Menu
Sorry, I screwed it up…
blogging - 8 comments
Over the weekend I tried to move this site (chandoo.org) from one hosting provider to another. Whenever I do this, I dont feel so good and yesterday was no exception.
The move failed
Soon after changing the DNS Server settings to point to new host, I was getting HTTP 500 error. A closer look at error logs and I found a message “premature end of headers in index.php” which could mean several things according to mighty internet.
Well, I couldnt do much about this, so I silently changed back my DNS to old provider. I will look in to this issue again this weekend. So meanwhile if you see something funny on the blog hosting front, just hang in there and be with me. I am sorry if you are frustrated seeing a useless http error but beleive me, I am even more frustrated seeing the same errors.
Hello Awesome...
My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.
I hope you enjoyed this article. Visit Excel for Beginner or Advanced Excel pages to learn more or join my online video class to master Excel.
Thank you and see you around.
Related articles:
|
Leave a Reply
| « Why No One Likes Your Pie Charts (And What to Do About It) | Visualizing Search Terms on Travel Sites – Excel Dashboard » |
At Chandoo.org, I have one goal, "to make you awesome in Excel & Power BI". I started this website in 2007 and today it has 1,000+ articles and tutorials on data analysis, visualization, reporting and automation using Excel and Power BI. 
8 Responses to “Sorry, I screwed it up…”
Hang in there, Chandoo. There are a lot of us who will hunt you down, wherever you host. Just too good a blog to miss!
This is a frustrating process. I did it last April, and may have to again this spring. There are so many ways to get it wrong, and only one way to get it right. And all of the guides online differ in their protocols.
Good luck.
2-3 days back I changed my host from 1and1 to Media Temple.
Flawless migration.
1. Using WinSCP, copy all your files & directories to the local computer first, and then to the new host.
2. Use MyPhPAdmin to take a dump of the db, and then import it using the MyPhPAdmin on the new host.
3. Update the DNS on the old host to point to the new host.
Did you edit your index.php file?
Why did your index.php fail.
.
Which host are you migrating to and from where.
@Tarun: I did the same steps...
but since my current host doesnt allow winSCP or SFTP, I used FTP (took several hours 🙁 ) to download the current installation's theme, plugin and upload folders
unzipped a fresh install of wordpress from wordpress.org to my new hosting account
replaced the theme, plugin and upload folders
updated DB through SSH (phpmyadmin cant be accessed until I change my nameservers, thus, I used mysqld)
and finally updated name servers.
I was able to view static files (like http://chandoo.org/) and images... but not the index page.
the current host is godaddy and I tried to migrate to dreamhost.
Potential error step 1.
_______________________
Chandoo - unzipped a fresh install of wordpress from wordpress.org to my new hosting account
______________________
Potential error step 2.
________
updated DB through SSH (phpmyadmin cant be accessed until I change my nameservers, thus, I used mysqld)
________
You should not install a fresh WordPress during migration. Just copy over exact same files from your old host to new host.
What do you mean - current host does not allowWinSCP - but you used FTP?
WinSCP IS a GUI FTP!
PhpAdmin cannot be access until you change the nameservers? I would find that extremely hard to believe! Where you getting you info from!
You don't have to edit your index.php ...that was my point in the last post. Why did you do that!
Lastly, Dreamhost Vs Mediatemple grid service. Compare these two and if you are within 30 days of the purchase, reconsider the decision to go with Dreamhost and shift to Mediatemple.
Unless of course you are going with Dedicated servers or something similar.
Hey I noticed too many exclamation marks...I was not really jumping around writing that post 😀
@Tarun: Awesome.. I kind of guessed that step 1 "unzip fresh install" was the problem.
I did have the winSCP FTP client. But when you create a new connection, it asks for preferred protocol and the options are FTP, SFTP and SCP. I meant my current host doesnt allow anything other than FTP.
The reason I used fresh install is, download rates from FTP to my comp were bad due to my slow internet connection. I thought I could avoid some extra download by getting a zipped file from wordpress.org.
And wrt. mysql, dreamhost gives a mysql subdomain through which you can access phpmyadmin. that is why nameserver change is required.
I never really edited the index.php. But after few hours and still the same error, I have opened it and added a headers section (that seems to be one cause for this according to few articles on the net).
Thank you so much for answering my questions. You are really helpful 🙂
btw, I am moving this site to the basic package on dreamhost. I doubt if moving to a Grid Hosting or Dedicated is required for a small site like mine. It gets around 5k page views a day and the template isnt particularly mysql hungry either.