Prepared Ham

data base issue again. => Server Migration Issues AGAIN => : AD October 25, 2018, 06:50:47 PM

: Latest Issue with website
: AD October 25, 2018, 06:50:47 PM
well I am sure most of you have noticed we have been off of the air for about 3 weeks.

I had a database connection error that popped up on the hosting site(Go Daddy)

Dont know how it happened but it crashed us hard.

Thanks or Mhar from GD tech support share hosting, he went about and beyond and got it running again.
: Re: Latest Issue with website
: DragoSapien October 25, 2018, 08:10:23 PM
Wondered what had happen.
: Re: Latest Issue with website
: spacecase0 October 26, 2018, 11:02:19 PM
I have run a few websites in the past
my issues were running a top 100 website that was politically polarized
one of the few things that I have never have found on the web is how to run a website with that much traffic
talked to the sysadmin of dig.com one day about the topic...
I agreed with him on what we had learned
turns out that you can learn a huge amount in a 30 second elevator ride
and also, thank you dig.com for the computer monitor I am using at the moment.
ok, fine, it was not learning, it was verification
so my comment here is that if you don't have physical control of your server, you are trusting someone else to do a good job.
and it is kind of sad how often they seem to mess up.

I hope you keep a backup of this site
I have seen others loose hundreds of websites all at once...
I feel sorry for them, what a way to loose your job.
: Re: Latest Issue with website
: BTPost October 27, 2018, 01:54:24 AM
Welcome back to the world of TCPIP.... Happy for your reserection....
: Re: Latest Issue with website
: Tevin October 27, 2018, 06:22:49 AM
I absolutely did notice the outage and I'm glad you are back. I wanted to contact you through Survival Monkey to see what's going on but you're not over there much and I didn't think you'd get the message.

I also had my blog go down last weekend. It was out for three days and might have been restored sooner but I was out of town and did not have any of my log in and account information. Once I contacted Go Daddy they were able to fix in in a few minutes with a few tweaks. They had to "kill PHP process". I don't know what that is, but once it was dead everything came back.


: Re: Latest Issue with website
: XJP5 October 27, 2018, 12:22:01 PM
well I am sure most of you have noticed we have been off of the air for about 3 weeks.

I had a database connection error that popped up on the hosting site(Go Daddy)

Dont know how it happened but it crashed us hard...

AD, database maintenance is a specialty. It really is. Everywhere I worked in the technology field over the past 17 years, we've had dedicated DBAs to maintain these relational databases. I know very little about them, with the exception of how vulnerabilities occur from the Cybersecurity perspective. Doesn't GoDaddy offer any services or assistance in a situation like this? I probably know the answer already, and that's why I would gouge their eyeballs out for my services, if they ever requested them.
: Re: Latest Issue with website
: AD October 30, 2018, 09:02:28 AM
Guys what I dont understand is that with little traffic causing the database to be added to amd NO ONE messing with the back end on the server side, how does the database get corrupted?

For years PH ran without issues until I upgraded the server to host multiple website.

Now I have the blog posts on www.preparedham.com not connecting to the articles.

I am not smart enough on the server side to correct this issue.
: Re: Latest Issue with website
: spacecase0 November 01, 2018, 12:52:04 AM
running separate databases for each site ?

ever run the command ?
mysqlcheck -u root -p --auto-repair --check --optimize --all-databases
: Re: Latest Issue with website
: AD November 05, 2018, 10:00:59 PM
Nope.  I dont know anything about it.
: Re: Latest Issue with website
: spacecase0 November 05, 2018, 10:58:41 PM
Nope.  I dont know anything about it.
if you can run that command, then do it when the site database is messed up
if you can't run it, then whoever runs your site is not maintaining things well enough
: Re: Latest Issue with website
: XJP5 November 25, 2018, 06:16:12 PM
Nope.  I dont know anything about it.

AD, this site may have some helpful information:  http://www.mysqltutorial.org/mysql-database-table-maintenance-statements.aspx

XJP5
: Re: Latest Issue with website
: Tevin November 27, 2018, 07:27:38 AM
I once considered adding a message board/forum component to my own blog. I decided against it because it's a lot harder than it looks and there are already a bajillion forums out there anyway. I'm not sure I can add anything new.

I am grateful to those who run forums as I do enjoy participating.
: Re: Latest Issue with website
: AD November 28, 2018, 10:47:23 AM
idial1911 who set up the sight, went in and corrected some things so the blog is now working again.
: Re: Latest Issue with website
: ghrit November 30, 2018, 05:57:01 PM
just checking to see if the lights still work.  They do ---