Five days ago, I began having extremely bad problems with my hosting account, which was box 350 (server). I feel sorry for the poor souls on that box. As described in my previous post, I started getting cpu quota exceeded errors 20-30 times per day. I called my host over 70 times this week, and that song they play when you’re on hold will cause me to explode in a frenetic rage of blackened anger – I heard it for hours.
Back up Nightmare
I have a ton of back ups, but they are all corrupted. It may take a few posts to explain in full detail exactly what the problem was, but my back ups didn’t work. It’s a terrible feeling to know you cannot produce a good back up from your site.
Every time I got on the phone with them, it was someone different. None of these people collaborate with one another, so every person you talk to is just hearing about your problems for the first time. I have a sore throat from explaining the same thing over and over and over.
I got the same fuc#ing answer every time I talked to them, “You need to tweak your scripts, and add appropriate indexes to your mysql database. It’s your fault, not ours.”
I did a reverse dns lookup for my site and there were 160 sites on my server, sharing the same IP. When my site got a exceeded quota error, all of the sites on the same server did too. They told me it was coincidence! This is what I told them, “Admit it…it’s your fault, not mine. Say it…tell me how bad you suck. Say it…say the words I suck.”
Finally, one guy said, “I suck dude, sorry. We suck. You’re right, that server is screwed up, and I’ll have a level 3 tech watch it.”
I said, “Is he watching it now? I’D PREFER HE ACTUALLY FU*KING WORK ON IT!!! I DON’T CARE IF HE WATCHES IT!!!”
When it comes to back ups, you don’t know if it’ll work until you try to import it into another domain, not your same one. For example, you move to a new hosting company and your back up will not take. You have then lost your blog.
How I fixed It
My install had serious problems, as well as the server. They were both messed up. If you back up a screwed up installation of wordpress, you can only restore a screwed up installation. The easiest way to get around it is to go into your wordpress control panel under manage, export. Export your posts and comments and save it to your computer. If you want to import it, you go to manage, import, wordpress. You’ll notice you can only import a 2MB xml file. My back up was 9.8MB, too large to import. I’ll explain how to get around that in an upcoming post as most of the online tutorials didn’t work for me.
I asked blue host to migrate my account to another server and they refused, insisting it was my fault everything was screwed up. I had them completely wipe out my cpanel and give me a brand new account, as if I just signed up today. That actually moved my account to a new server with a fresh IP. That’s how you move to a new server!
I exported my posts and comments and imported them into a private wordpress.com site for safe keeping. I then imported my posts and comments through wordpress, not my cpanel restore, thus eliminating the possibility of a corrupted back up – into my fresh self hosted wordpress install. If anyone ever needs help with this, I have now been through all the misery, so I learned how to do all kinds of new things.
Don’t Use Fantastico
The worst way to install wordpress is using Fantastico, which nearly every host uses. It’s easy to use, but your install will always be out of date and have security issues. You can install wordpress from scratch or you can use Simple Scripts in your cpanel. Simple Scripts works great and nearly all cpanels have it – it also allows for fast upgrading. If I had to guess, it was the fact my original install was through Fantastico that caused my backups to be corrupted. As you upgrade to new versions of wordpress, you may have corrupted backups…so don’t use it.
Now, I have a fresh, beautiful installation and no server issues. It only took an hour for my DNS to propogate, but it’s probably not Internet wide yet.
I apologize to all my readers for my site being down all day, but it’s up and running wonderfully. I lost my last post and comments. I also lost my image gallery, so I will be editing my pictures back in over the next week (I will back it up separately and so should you…just in case). It’s been a blogger’s worst nightmare, but I did learn a lot.
I currently have one plug in, the Akismet spam filter. I’m almost afraid to add a second. The more you learn about web design, you learn that less is better. Anyway, I’m happy to be back on a new server that actually works. Oh yeah, I just checked several sites on my old server and got a CPU Quota Exceeded error…hahahahahahaha!!!!!! I feel so sorry for them.
Thanks To Michelle Gartner and Richard Catto for offering to help me!



#1 by pearl at July 17th, 2008
| Quote
Hi Bobby… I’m so glad you have most of the data intact.. sucks to have lost even one post.. I lost one very early on when I had first moved on wordpress, within like the first week…
This sure is scary because I used fantastico for the initial install as well… AND my file is getting larger every day so I may have the similar issues myself… At least I know who to turn to in case I get stuck in the same mode
can’t wait for your next post to see what you did to export such a large file
bluehost actually refusing to move the account to another server is disappointing to say the least… Im just glad everything works now… you should definitely write an ebook on this..serious
#2 by dcr at July 17th, 2008
| Quote
Glad you managed to get everything back! Well, except for the most recent post but I suppose that’s not as bad as it could have been.
#3 by emila at July 17th, 2008
| Quote
That is horrendous! I don’t know what would I do if this happens to me. I think I need to back up all my posts and comments too. Will use your tips on saving them. But I think mine is bigger than 2mb as well.
Bobby, this is good post. Thank you for sharing. My hosting server was down few days ago, they won’t even respond to my chat messages or e-mails. They only replied after they fixed the error. My blog was down 3 times this year.
#4 by Jean Chia at July 17th, 2008
| Quote
no wonder i landed on another blog when i try to load revellian yesterday. It was still your blog but in another template and the last post was “Hello World”!
I hated to having myself so many times, it’s so annoying & frustrating! i cant believe that the guy actually admitted that they suck! lolz.
Our ppls here will not admit that they suck, they will only push the blames on someone else. And it will only lead you more anger! ><
Once again, im so glad you’ve saved revellian!
Happy weekend and have fun editing yr image gallery! Hugs!!
#5 by Mel at July 18th, 2008
| Quote
Hi Bobby,
It’s been a while. Your post intrigued me because I am planning a new project. For this project I am planning on using a 4 column WordPress theme on DreamHost. DreamHost seems to be host that WordPress.org promotes most. Is there anything that I should be aware of? Their pre-sales email support seems to be quick and informative.
Are their any land mines that I should look out for?
BTW, my Big Bang has eclipsed 1,000 sites and your old friend, Technorati, has gotten wind of it and frozen my authority. You know, I have grown to LOATH Technorati almost as much as you have.
Thanks,
Mel
#6 by Scam at July 18th, 2008
| Quote
I’m patiently awaiting the tutorial on how to export a large database as mine is bigger than yours.
I had a corrupted database at the beginning of the year and it took a few months to get an old backup from my host – when I finally got up and running again my site has been down for 4 months and I’d lost 6 months of work.
Considering I’d backed up every day, you could say I was a little unhappy over the whole affair!
#7 by Sean Rasmussen at July 18th, 2008
| Quote
Sorry Bobby. As much as I suffer with you, I know that story all too well. Dealing with (some of) those guys is enough to drive anyone up the wall. That’s when it really worries me that people have guns in their houses… ’cause someone deserves to be shot at those places and their safety mechanism is the phone line and the fact that you can never talk to anyone in charge. Hmm sounds like Australia’s favourite phone network: Telstra
I hope all works out for you, mate.
#8 by admin at July 18th, 2008
| Quote
@Pearl: Right now, your blog is problem free and I hope it stays that way. There is always a way to fix it, no matter what happens. I suggest backing up after every new post!
@DCR: Wheeew!!! What a nightmare! Thanks and I’m glad to be fixed:)
@Emila: A host will only do so much to help you, no matter which one you use. When self hosting, you are on your own and they are not responsible for your blog.
@Jean: You say my blog with a hello world post? Haha…it was scary! I got mad and said some bad things to my host, but I was so frustrated!
@Mel: A 1000 links is an impressive feat for your project, but it’s far too many for a single post. A high technorati authority only effects the searches someone does if they are actually using technorati as a search engine – other than that, it’s useless. Dreamhost is similar to bluehost or any other shared host (meaning your site will share an IP with 500+ other sites on one machine). Make sure you don’t install wih fantastico and adjust your permalinks structure BEFORE writing your first post. Have a clean design and don’t install too many plug ins. Oh, good luck with your new project!!!!
@Scam: I backed up everyday too,and you’re right…it is horrible to learn your effort was a waste. I’ll have that post coming up!
@Sean: Hahaha…I thought about the same thing!!! Trying to talk to someone other than a $7.00 per hour employee is like pulling teeth. They are unorganized, an most of them know nothing. Moving to a different server seems to be a truly valid solution to hosting with one of these cheap hosts!
#9 by DaveS at July 18th, 2008
| Quote
wow Bobby. What a mess. I saw that “Hello World” blog and thought to myself… something is really busticated. Glad you’re back!
There’s a lot to be said about selecting a host. A whole lot. I made that mistake when I first set up my ecommerce site. Hosting was killing me.
Not no more. Completely rebuilt the site from the ground up (that was a project!) and the support from my current host is nothing but stellar.
#10 by Revellian at July 18th, 2008
| Quote
@Dave: As much as I’ve complained about bluehost, they have been helpful for the most part. In my opinion, the server I was on has a problem they haven’t caught yet or one of the sites on it is an advanced black hat site which is crippling it. The server I’m on now has 500+ people on it, and it runs great. I am happy with my hosting especially because it only costs $99.00 per year – you can’t beat the price. Who is your host?
#11 by DaveS at July 18th, 2008
| Quote
Actually I have a few. But for my ecommerce site I use Lexiconn. No, they’re not cheap. But I know I can count on them. Tech support in minutes and from someone who knows their stuff. It was/is very important to me to be able to run my company without having to worry about server side issues.
#12 by Bowers Industrial Sales, Inc at July 18th, 2008
| Quote
Wow! What a nightmare. I’ve had nothing but good experiences with bluehost, but I suppose that there are always going to be problems no matter who you are hosting with.
#13 by Revellian at July 18th, 2008
| Quote
@Dave: I understand your position. I am confident in knowing I can fix my own problems, no matter what happens. I’ve thought about buying my own server and running it out of my house instead of using a host at all…haha! I think blue host is still one of the better cheap hosts, and no company is perfect. I do wish they had mysql experts who could go through my tables line by line, but I’m not sure any company has that. I run this site for free and pay for it through my ads
@Bowers: You’re right, any host can have problems, or a particular server from that host can become corrupted. The best part about blue host is the price – the less overhead the better!
#14 by DaveS at July 18th, 2008
| Quote
Another to check with would be pronet-services.com
My business partner and I have a virtual server through them. Really good guys there. Worth a peek anyway.
#15 by Mel at July 18th, 2008
| Quote
Bobby,
Dreamhost uses the following install programs: WordPress, Joomla, PhpBB, ZenCart, MediaWiki. WHat would you suggest?
Thanks!
#16 by Revellian at July 18th, 2008
| Quote
@Dave: Thanks, I’ll check them out
@Mel: I of course recommend wordpress. Every host offers the ability to automatically install different sites, but it’s the way you install it that matters. WordPress can be difficult to install manually if you haven’t done it before. Like I said, don’t install it with the automated program “fantastico” that most hosts offer in their control panel. See if dreamhost uses Simplescripts, and use it instead. If not, you’ll need to install it manually.
#17 by Matt Wilson at July 18th, 2008
| Quote
Dreamhost has never caused me any problems. But now I know that anything can happen. What I got a trip out of was when you posted–”Finally, one guy said, “I suck dude, sorry. We suck. You’re right, that server is screwed up, and I’ll have a level 3 tech watch it.”
Wow, the honesty of the guy of the company he works for. I also use wordpress.
#18 by Richard Catto at July 18th, 2008
| Quote
Bobby, what you need is a WordPress backup plugin:
http://www.ilfilosofo.com/blog/wp-db-backup
get it to email you a backup of your blog every hour to your gmail account.
Create a filter to delete the emails it sends you every hour. Gmail keeps them in trash for you for 30 days.
If at any point, you need to restore, go into your gmail trash folder and find the newest one. Save the attached zip to your hard disk. Unzip it. Open the text file. Copy and paste it into phpMyAdmin’s SQL input box. Run the script you just pasted in, and you will get everything back.
This backup method has already saved my ass before. My hoster’s server crashed last year and they could not restore anything because their backups had been corrupted.
Once you are using this method, you will always have peace of mind that your blog data is safe.
#19 by Revellian at July 18th, 2008
| Quote
@Matt: I must have been on the phone for literally 13 or more hours – mostly on hold. Some of the techs are cooler than others. Some just want to get you off the phone asap. I’ve never had any problems either until last week. It’s all better now
@Richard: I actually did use that plugin on my previous intallation, but the backups it produced were corrupted. I tried those back ups, and back ups from my c-panel and none of them would work. I ended up using the import xml function in my wordpress control panel to get up and running. I’ll install it again and set it to auto. I also export an xml back up too
#20 by teeni at July 18th, 2008
| Quote
Yikes. It is terrible that you had to go throuhgh all this. I think it’s kind of funny that you got someone to admit they were wrong. But it wouldn’t have been so frustrating for you and you wouldn’t have felt you needed to hear it if they could have just been more helpful in the beginning. sheesh. I hope your techno-woes are over!
#21 by Madhur Kapoor at July 19th, 2008
| Quote
I think it is time for me to stop using fantastico. btw in the feed reader i can see a post regarding the site redesign but it is not here . The design looks great though.
#22 by Revellian at July 19th, 2008
| Quote
@Teeni: Yeah, the guy was actually laughing and so was I, but he did understand my frustration. Everything is running great and I am in a great mood!
@Madhur: I lost that post and comments (the one about redesigning my site), but I managed to save everything else. I forgot to download my photo gallery before I wiped my account out, so I lost it. It’ll take me weeks to put them all back in. Fantastico is not a good idea. Use simple scripts, it works great.
#23 by Debbie Dolphin at July 21st, 2008
| Quote
Hi Bobby,
Your site gave me CPU Quota Exceeded error…hopefully, it has been fixed?
Did you change servers to fix the issue?
My host upgrades to the new WordPress updates when they are notified. I thought this was a good service so we didn’t have to worry about causing database problems.
I’m using WordPress 2.3.3 and wonder if your troubles are connected with either WordPress 2.5 or WordPress 2.6?
#24 by Mel at July 22nd, 2008
| Quote
Hey Bobby,
I took a look at Bluehost and I liked their phone support as well as what they had to offer. So I signed up for their 2 year package. Be on the lookout for SlogBite.Com in about 2-3 months from now, hopefully.
#25 by Revellian at July 22nd, 2008
| Quote
@Debbie: I don’t have a record of getting a cpu quota error since I moved to a new server, although it’s possible for anyone to get one. The database problems were not caused by me, it was the other server I was on. The reason you need to update is that WP 2.3.3 is filled with major security holes. I always use the latest version. To change servers, I had my entire c-panel erased and got a brand new one – that put me on a new server.
@Mel: Good luck with your new site!
#26 by Debbie Dolphin at July 22nd, 2008
| Quote
Hi Bobby,
Thank you for the info! I heard there were issues with installing WordPress 2.5 on self-hosted blogs and decided to wait and see what develops. Hopefully, my host will complete the upgrades by tomorrow.
#27 by Revellian at July 22nd, 2008
| Quote
Whevever I upgrade to a new version, I disable all my plug ins. Next time, I will use my default template too just to be on the safe side. Be sure to back everything up beforehand. I am guessing you installed using fantastico?
I upgrade my manually now and don’t use any automated programs to do it. I’ve been using version 2.6 since the day they released it
#28 by Debbie Dolphin at July 22nd, 2008
| Quote
Hi Bobby,
My host, Bluefur, installed WordPress for me and they also upgrade WordPress to the latest version when they are notified by me.
My guess is Bluefur probably uses an automated program yet, who knows what they really use.
After reading many horror stories of WordPress Bloggers having issues with installing WordPress or upgrading to new versions, I decided to go with a host who will maintain the software.
It may be in my best interest to learn how to fully backup and upgrade WordPress yet, finding a easy-to-understand resource for beginners to WordPress software isn’t easy.
#29 by Revellian at July 22nd, 2008
| Quote
Well Ms. Colbert, I think that sounds good. They probably do it manually, so it’s probably done correctly. I’ve never had a problem with any upgrades and none have ever caused me any problems though I’ve read that other people have.
The best resource is in the wordpress documentation at wordpress.org. Most people fail to read all the great information readily available to them. If your host does it all for you, you probably hav nothing to worry about!
#30 by metalheader at November 30th, 2008
| Quote
Hey Bobby,
. My new blog, which I just updated to v2.6.5 on fantastico, on bluehost………doesnt work! :O Like I updated it and I got this message:
I really need some help from your experience
Parse error: syntax error, unexpected $end in /home/bulleti1/public_html/wp-includes/query.php on line 1411
I have no idea what that means. I looked at the notice I got after updating (which they usually showed after every other update)…
If you don’t have SSH access, ask support to help you:
- delete all the files listed in /home/bulleti1/public_html/fantastico_fileslist.txt
- delete /home/bulleti1/public_html/fantastico_fileslist.txt
- Untar /home/bulleti1/fantastico_backups/.backup.1228102873.tgz
- Empty the database bulleti1_wrdp1
- Import the file /home/bulleti1/fantastico_backups//backup.sql into the database bulleti1_wrdp1
- Move /home/bulleti1/fantastico_backups/ to /home/bulleti1/public_html
it says I will need to restore the stuff but I have no idea because:
.
1. What is SHH access.
2. What does untar mean?
3. I have little idea of what is really going on
If you can save my butt, I’d appreciate it and you will have a friend in me!
#31 by Revellian at December 1st, 2008
| Quote
Wow Metalheader, sounds like a problem.
SSH is secure shell access, which is a secured connection to the linux shell of your server, much like looking at the DOS shell in windows, but I wouldn’t worry about it.
Untar means unzip, but in Linux.
I would call Bluehost,and ask them to restore your last back up for you. Sometimes they will try to avoid helping, so INSIST until they fix it for you.
Since your blog is so new, you can start from scratch since you only have 3 posts, and blue host can do all that for you.
With Fantastico, you will have problems every time you upgrade to a new version even if they can restore your site!
I would strongly suggest you start fresh and ask BH to delete your blog and have them reinstall a fresh version using Simple Scripts instead of Fantastico. Then install the WordPress Automatic Upgrade plug in immediately after. Let me know how it goes
#32 by Dave at December 1st, 2008
| Quote
Hi, just landed on this post while googling for ‘files wiped on bluehost’ phrase. We got them really wiped off yestarday. We log in and … HUH .. there’s nothing. Nothing at ALL!
And that’s what bluehost answered:
Dear Customer,
Thank you for contacting us!
Sorry but there are no log files on our end. We also don’t have any backups of your site.
BlueHost does not offer redundant or mirrored backups. BlueHost will run courtesy backups at our discretion. Any backups that BlueHost runs are in addition to our Terms of Service and are not guaranteed. Customers are encouraged to run periodic backups through the provided cPanel. BlueHost reccomends that you store such backups off site on your local sysetm.
Important: Bluehost.com assumes no responsibility for failed backups, lost data, or data integrity. Bluehost.com is unable to provide copies or create automatic backups for sites above 4 gigabytes in size.(The reason why we don’t have any backups for you) You may create your own copies using SSH/Shell Access.
Thank you for using Bluehost. When you have a new question or issue, please open a new support ticket.
Don P
I don’t know what they did, we did nothing for sure. And they just DO NOT TAKE ANY KIND OF RESPONSIBILITY. They just something like – it’s all your fault asshole, fu#@ off.
That’s not a right thing to do. I seek for a bloody revenge. Anybody having the same issue, please contact me on: jayarjo@gmail.com
#33 by Revellian at December 1st, 2008
| Quote
Hi Dave, I completely understand your angst; however, I will point out that most hosts in the price range of $10.00 or less per year really cannot afford to do a lot.
You must back up your own site every day. I use the WP database backup plug in, and it automatically backs up my site every day. You must prepare your own site to withstand any and all problems like this. That’s why they call it self hosting – you are basically your own web master.
Also, never put in a support ticket for help – call them instead. Call and call again until you find someone to help you. Ask to speak to someone higher up and insist on it.
The biggest mistake 1st time wordpress users make is using Fantastico to install their site. Either use simple scripts or install it from scratch, it’s not that difficult. I wish you luck!
#34 by Miss Moneypenny at December 1st, 2008
| Quote
Hi Bobby!
Do you use the WordPress database backup plug in @
http://www.ilfilosofo.com/blog/wp-db-backup/
Do you backup to the server, your computer, and eMail?
Is there a plug in to restore the database?
#35 by Revellian at December 2nd, 2008
| Quote
That’s the one Debbie! I just have it emailed to my private email account, which is not known by the public. It sends me a backup every day:)
#36 by Miss Moneypenny at December 2nd, 2008
| Quote
Thank you, Bobby!
The plugin was so easy… nice to see the computer do what it was design for (automate tedious time consuming tasks), for a change!
What would the blogging free world do without you?
#37 by Revellian at December 2nd, 2008
| Quote
You’re welcome Debbie! I’m sure the blogging free world would survive without my input…lol!
#38 by Mel at December 2nd, 2008
| Quote
Hi Bobby,
Based on your recommendation of BlueHost and Simple Scripts, as I told you preciously, I put my new WordPress project on this host.
For both you and your readers……They are GREAT. The longest I have ever had to wait to get a live person, when I had problems, was 5 minutes. Everyone there is helpful.
And, what can I say about Simple Scripts….. loading on the new WP versions has been so easy and totally hassle free.
Bobby, come on by SlogBite and take a look…. and maybe join in?
http://www.slogbite.com
#39 by Revellian at December 2nd, 2008
| Quote
Thanks Mel, I’m glad everything is going smoothly! I’ll come by and join sometime today. Thanks for reminding me, I have been busy with work.