Menu

ZH Classifieds
ZH Files
ZH Staff
WFTDA 12/1/2014 Rules
WFTDA 3/1/2014 Rules

Donate

Please Support Zebra Huddle!

Recent Posts

Re: Jammer's time in penalty box by 3Beers
April 26, 2020, 09:46:33 pm

Getting officials attention by Rego_Derby
March 03, 2020, 04:05:02 am

Re: Jammer's time in penalty box by Major Wood
February 05, 2020, 05:52:31 pm

Jammer's time in penalty box by 3Beers
January 29, 2020, 03:33:20 am

Nashville Roller Derby 2020 Scrimmage-A-Thon - 7/11/2020 by Major Wood
January 27, 2020, 09:36:38 pm

Re: Rule clarification by 3Beers
January 26, 2020, 08:09:00 pm

Re: Rule clarification by Bluebeard
January 17, 2020, 05:26:46 am

Rule clarification by 3Beers
December 28, 2019, 06:04:00 pm

Re: Resources for new referees. by Destructor
November 29, 2019, 01:13:40 pm

Resources for new referees. by Destructor
November 26, 2019, 06:01:48 pm

Author Topic: 1/23/09 outage  (Read 8702 times)

Offline Major Wood

  • Administrator
  • Has Too Much Damn Time Member
  • *****
  • Posts: 2665
  • Stats Sheet: 77
  • League Affiliation: Nashville Rollergirls
  • Referee Certification Level: Level 5
  • NSO Certification Level: Not Certified
1/23/09 outage
« on: January 23, 2009, 05:18:16 pm »
Many of you may have noticed that Zebra Huddle was inaccessible for a few hours this morning. I'm told that the server room had it's air conditioning system fail and the server needed to be shut down because it was reaching a critical heat. As far as I understand, the problem has been fixed.
I apologize if you were affected by this outage.

I know there are a few web developers on here. Does anyone know of a decent desktop solution for automatically backing up a database?
Your friendly Zebra Huddle admin.

Nashville Roller Derby Head Ref
WFTDA Level 5 Certified Referee

I speak only of my opinions and interpretations.

Offline SeerSin

  • Hero Member
  • *****
  • Posts: 993
  • Stats Sheet: 55
  • League Affiliation: Minnesota Rollergirls
  • Referee Certification Level: Level 5
  • NSO Certification Level: Not Certified
Re: 1/23/09 outage
« Reply #1 on: January 23, 2009, 09:59:03 pm »
Simple Machine Forum provides a backup utility. Under Admin -> Forum Maintenance -> Backup Database. Or you can use PHPmyAdmin, which is usually provided by the hosting service.

Offline mick hawkins

  • Superhero Member
  • **********
  • Posts: 1926
  • Stats Sheet: 61
  • They're covers people. Helmet COVERS!
  • Referee Certification Level: Not Certified
  • NSO Certification Level: Not Certified
Re: 1/23/09 outage
« Reply #2 on: January 23, 2009, 10:04:32 pm »
who knew there'd be an advantage to being on the other side of the world
completely slept through the outage  ;D
Sun State Roller Girls (WFTDA Apprentice League)
Brisbane, Australia

Offline Ref Neck

  • Full Member
  • ***
  • Posts: 178
  • Stats Sheet: 15
Re: 1/23/09 outage
« Reply #3 on: January 23, 2009, 10:08:22 pm »
cron + mysqldump + gzip

Or, mysql-administrator:



http://www.softpedia.com/get/Internet/Servers/Database-Utils/MySQL-Administrator-for-Windows.shtml

They make a windows version (linked to). If you have mysqld listening on a TCP socket and have SSH with port forwarding enabled, you should be able to run it from your desktop client and use it to create backups remotely to your computer.
« Last Edit: January 23, 2009, 10:12:35 pm by Ref Neck »
DC Rollergirls, Head Referee

Offline Major Wood

  • Administrator
  • Has Too Much Damn Time Member
  • *****
  • Posts: 2665
  • Stats Sheet: 77
  • League Affiliation: Nashville Rollergirls
  • Referee Certification Level: Level 5
  • NSO Certification Level: Not Certified
Re: 1/23/09 outage
« Reply #4 on: January 23, 2009, 10:46:37 pm »
Simple Machine Forum provides a backup utility. Under Admin -> Forum Maintenance -> Backup Database. Or you can use PHPmyAdmin, which is usually provided by the hosting service.

I know about both of these, and have (at different points in time) backed up from both interfaces. I'm trying to get it to do automated backups.

cron + mysqldump + gzip

Or, mysql-administrator:

http://www.softpedia.com/get/Internet/Servers/Database-Utils/MySQL-Administrator-for-Windows.shtml

They make a windows version (linked to). If you have mysqld listening on a TCP socket and have SSH with port forwarding enabled, you should be able to run it from your desktop client and use it to create backups remotely to your computer.

Is it possible to schedule the backups to run at whatever interval I choose? I would probably do nightly backups or every other night.
Your friendly Zebra Huddle admin.

Nashville Roller Derby Head Ref
WFTDA Level 5 Certified Referee

I speak only of my opinions and interpretations.

Offline Ref Neck

  • Full Member
  • ***
  • Posts: 178
  • Stats Sheet: 15
Re: 1/23/09 outage
« Reply #5 on: January 23, 2009, 10:49:37 pm »
You have shell access right? I would look to see if the mysqldump command is on the host and use that with a at job/crontab. After the backup is done, you could have a automated task that runs from your client system that SFTP's the database dumps down to your box and deletes the copy off of the server or something like that.
DC Rollergirls, Head Referee

Offline Major Wood

  • Administrator
  • Has Too Much Damn Time Member
  • *****
  • Posts: 2665
  • Stats Sheet: 77
  • League Affiliation: Nashville Rollergirls
  • Referee Certification Level: Level 5
  • NSO Certification Level: Not Certified
Re: 1/23/09 outage
« Reply #6 on: January 23, 2009, 10:52:52 pm »
You have shell access right? I would look to see if the mysqldump command is on the host and use that with a at job/crontab. After the backup is done, you could have a automated task that runs from your client system that SFTP's the database dumps down to your box and deletes the copy off of the server or something like that.

That I'm not totally sure of. This is all pretty well over my head. But, editting the php to make the stats sheets display differently based on the user's stats sheet score was over my head too  ;).

I'll be taking a look into that pretty soon (when I have time to set it up). For now, I will be doing manual backups nightly.
Your friendly Zebra Huddle admin.

Nashville Roller Derby Head Ref
WFTDA Level 5 Certified Referee

I speak only of my opinions and interpretations.

Offline SeerSin

  • Hero Member
  • *****
  • Posts: 993
  • Stats Sheet: 55
  • League Affiliation: Minnesota Rollergirls
  • Referee Certification Level: Level 5
  • NSO Certification Level: Not Certified
Re: 1/23/09 outage
« Reply #7 on: January 24, 2009, 03:01:49 pm »
Ref Neck's method is the best, but I know some hosting companies block remote access to the database for security.

Offline WeirdAlSpankabitch

  • Newbie
  • *
  • Posts: 30
  • Stats Sheet: 5
  • Referee Certification Level: Not Certified
  • NSO Certification Level: Not Certified
Re: 1/23/09 outage
« Reply #8 on: January 26, 2009, 07:29:14 pm »
Another solution, the way I did this in the past:

Use netdrive.exe from Novell to map an FTP path as a network drive, then use a utility like SyncBack to copy the database to your desktop.
The ghost of referees past, present and future

 

Featured Product

 

Zebra Huddle Head Referee Bout Booklet

 

Featured Classifieds


ZH Files

How to Score a Point in Roller Derby
Rating: *****
Downloads: 4474
Views: 7529
Filesize: 327.61KB
Date: January 17, 2017, 04:21:03 am
Comments (0)
By: AdamSmasher
June 2013 Ruleset situational questions
Rating: *****
Downloads: 2991
Views: 6102
Filesize: 29.71KB
Date: February 07, 2014, 04:57:32 pm
Comments (2)
By: Crash Test Ref
Rules Q&A and Publications for 6/15/13 Document
Rating: (None)
Downloads: 3188
Views: 7031
Filesize: 26.27KB
Date: August 02, 2013, 04:10:40 pm
Comments (0)
By: Shaun Ketterman
Rules Q&A and Publications for 1/1/13 Document (4/24/13 Updates)
Rating: *****
Downloads: 3999
Views: 9047
Filesize: 28.07KB
Date: April 25, 2013, 05:45:34 pm
Comments (0)
By: Shaun Ketterman

Powered by EzPortal