PDA

View Full Version : Phew! Crisis Averted!


Ltvscout
05-03-2014, 06:46 PM
At 10:38am CST today YORS had a database failure with the table that holds all of the attachments. I was ****tin' bricks because dummy me had not been making proper backups of the database. My last backup is over 2 years old.

I tried running a repair of the table from my end but no go. I'm no MySQL guru so I left the fixing in the hands of my webhost. One of their admins just got back to me to let me know they ran a manual fix of the corrupted table at the head end and got it fixed. Phew!

Now to work on a CRON routine for doing a nightly DB backup.

SEL
05-03-2014, 06:59 PM
Gotta admit, I was jones'n there for a while...

At 10:38am CST today YORS had a database failure with the table that holds all of the attachments. I was ****tin' bricks because dummy me have not been making proper backups of the database. My last backup is over 2 years old.

I tried running a repair of the table from my end but no go. I'm no MySQL guru so I left the fixing in the hands of my webhost. One of their admins just got back to me to let me know they ran a manual fix of the corrupted table at the head end and got it fixed. Phew!

Now to work on a CRON routine for doing a nightly DB backup.

Rich Holmes
05-03-2014, 07:41 PM
cron is your friend. A somewhat weird and communications-challenged friend, but a friend.

Ltvscout
05-03-2014, 08:50 PM
if anyone is still having issues on the site, please give me some details. Thanks.

Gus
05-04-2014, 02:19 AM
Scott,

Let me say it again, thanks for all you do to keep this place running.

Steve

shrox
05-04-2014, 02:42 AM
Excellent!

Ltvscout
05-04-2014, 09:27 AM
They're still having some issues on the server. The site was just down for about 10 minutes again due to the /var directory filling up with error logs. Hopefully everything is smooth and back to normal soon.

UMRS
05-07-2014, 08:33 AM
Havent noticed any problems.