The Day I Lost My Wordpress Database

By
Real Estate Broker/Owner with Corinne Guest, REALTOR® | Barrington Realty Company License: 471.000044

I am building another business on the side and recently started a new Wordpress website called GoldenRetrieverYears. I have made the decision to scale down real estate and get out. This will either be when we move to Wyoming or before.

A week ago Monday I launched into the site and started writing. By Thursday afternoon the entire site was put together, there were multiple pages, 4 blog posts with over 1800 words each, several affiliates set up and I retired from my desk for the weekend.

Monday arrives and I am ready to dig into the site and once more and go about buying my SSL for both. Purchase made, time to add to domains. Second site works like a dream but something really weird happened to the other. Neither I nor my host support can work out what happened and they are still digging.

My new site became a blank white page.

I recently changed hosts due to host not backing up. I had to do it manually. So I moved back to one I know did it automatically. 

I now come to find out that all my files were backed up but the database was not. (I think they think I was going to set up the cron job, but I had not. )

In case you don't know and do use Wordpress the database is where all your written content is. The files had my theme and my images, video and anything else needed. That was re-intalled and now I have a wonderful looking design but no written content.

I lost about a weeks worth of work and this week I am re-writing it all over again. On Monday I was lost, literally lost as to which way to move forward. And my site was only a week old. Luckily I managed to get some back from Google's cache, 2 pages in all and 2 posts. Two stories are lost forever. 3/4 pages lost and yet to be redone.

My database is now being backed up. But just think how this could destroy your business if you rely on your website. Your hosting company may not even tell you about backups especially MySql which is where your database is.

If this had been my real estate website I would have closed my doors on Monday. That has thousands of indexed pages and posts and is my rainmaker.

It has been a struggle putting this small website back, I am a week behind in my work. One more post to re-write. Then the pages.

To top it all off on Tuesday my elderly cat was having problems and on Wednesday he crossed the bridge to heaven to be with his brothers and sisters.

I cried for the latter and almost yes almost for the first.

So if you use Wordpress, check your hosting company to see if your database is being backed up regularly. If not, do it maually. I am now doing both!

Lesson learned. Don't asssume.

Posted by

Corinne Guest

Realtor & Managing Broker
Barrington Realty Company

Call me today 847-363-3686. 

Barrington IL Real Estate

 

 Realtor and Equal Housing Logo

close

This entry hasn't been re-blogged:

Re-Blogged By Re-Blogged At
Topic:
ActiveRain Community

Spam prevention
Show All Comments
Rainmaker
3,273,324
Michael Jacobs
Pasadena, CA
Los Angeles Pasadena 818.516.4393

Hello Coriinne - lessons may have been learned but it does sound to be a bit painful. Sorry to hear of the passing of your fuzzy feline friend. Here's to better times.

Jun 14, 2019 09:00 AM #1
Rainmaker
3,546,551
Sheila Anderson
Referral Group Incorporated - East Brunswick, NJ
The Real Estate Whisperer Who Listens 732-715-1133

Good morning Corinne. I am sooooo soooooo sory about your cat. Nothing can fix that but I do hope when you are ready you will save another who wouldn't make it without you. The computer stuff will be fixed and now you back up.

Jun 14, 2019 09:18 AM #2
Rainmaker
2,482,715
Brian England
Arizona Focus Realty - Gilbert, AZ
MBA, GRI, REALTOR® Real Estate in East Valley AZ

The website looks great, you definitely know more about Wordpress than I do.  I built my website with Wordpress, but it definitely doesn't look as good as yours.  Do you have a drag and drop type editor as a plugin?  I used BeaverBuilder, I think it is called.

Jun 14, 2019 10:51 AM #3
Rainmaker
3,213,923
Sally K. & David L. Hanson
EXP Realty 414-525-0563 - Brookfield, WI
WI Realtors - Luxury - Divorce

Know that the next week will be better...we have had both furry losses and a blog that disappeared....no fun.

Jun 15, 2019 05:14 AM #4
Rainmaker
80,910
Dario Ferreira
Attleboro, MA
Internet Marketing

Losing a database is a painful event. It's great you got it mostly resolved.

I use a service called myRepono for all my MySQL DBs backups, and it's great. They also do Wordpress backups.

Btw, do you know you have the meta tag "noindex" on your website?
(<meta name='robots' content='noindex,follow' />)

Sorry about your cat.

 

Jun 15, 2019 07:28 PM #5
Rainmaker
1,417,229
Kat Palmiotti
Grand Lux Realty, Monroe NY, 914-419-0270, kat@thehousekat.com - Monroe, NY
The House Kat

I am sorry to hear about your cat. And losing that work, ugh, that sounds like a total pain in the you-know-what. Thanks for the warning about backing up.

Jun 16, 2019 03:07 AM #6
Rainmaker
751,086
Nick Vandekar, 610-203-4543
Long & Foster Real Estate Inc 610-225-7400 - Devon, PA
Tredyffrin Easttown Realtor, Philly Main Line

That sounds like an incredibly painful week. So sorry, lessons learned are ofen hard, but they are the most remembered ones unfortunately.

Jun 17, 2019 07:41 AM #7
Rainer
2,640
Robert cole
Abraham, UT
Business Developer

This is painful and I do face this one time. we must be careful and use good backup for us!   hope you can recover well.

Jun 18, 2019 12:07 AM #8
Rainmaker
1,518,063
Lyn Sims
RE/MAX Suburban - Schaumburg, IL
Schaumburg IL Real Estate

This is horrible & I gasped when I read this. This also happened to me years ago & I have to say that I was in a complete funk for a month. Saying your sorry really doesn't help with all the hard work you've put in. That's why hosting sites are so important.

Sorry about your cat too. 

Jun 21, 2019 01:43 PM #9
Rainmaker
2,773,576
Kathleen Daniels
KD Realty - 408.972.1822 - San Jose, CA
San Jose Homes for Sale-Probate & Trust Specialist

Corinne, I'm just seeing this post now.  

That was certainly not a good week for you. 

Such a heartbreak to lose a pet. 

Jun 25, 2019 04:35 PM #10
Rainer
136,393
Robin Wells
RAW Chimney Sweep and Inspections - Penetanguishene, ON
Giving Peace Of Mind One Chimney At A Time

Thanks for post!  It can be a painful lesson.  I simply use a virtual server and forget about a hosting service as most of them seem to have little value add.

Jul 07, 2019 02:29 PM #11
Show All Comments

What's the reason you're reporting this blog entry?

Are you sure you want to report this blog entry as spam?

Rainmaker
1,004,283

Corinne Guest

Barrington Lifestyles
Ask Barrington Realty Company
*
*
*
*
Spam prevention

Additional Information