Zebra Huddleâ„¢

Info Center => Zebra Huddle News => Topic started by: Major Wood on January 23, 2009, 05:18:16 pm

Title: 1/23/09 outage
Post by: Major Wood 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?
Title: Re: 1/23/09 outage
Post by: SeerSin 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.
Title: Re: 1/23/09 outage
Post by: mick hawkins 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
Title: Re: 1/23/09 outage
Post by: Ref Neck on January 23, 2009, 10:08:22 pm
cron + mysqldump + gzip

Or, mysql-administrator:

(http://www.softpedia.com/screenshots/10-8-6-74_1.jpg)

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.
Title: Re: 1/23/09 outage
Post by: Major Wood 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.
Title: Re: 1/23/09 outage
Post by: Ref Neck 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.
Title: Re: 1/23/09 outage
Post by: Major Wood 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.
Title: Re: 1/23/09 outage
Post by: SeerSin 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.
Title: Re: 1/23/09 outage
Post by: WeirdAlSpankabitch 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.