Page 1 of 2

Nightly Backups

PostPosted: December 23rd, 2010, 3:53 am
by Moka
Hello everyone :D Long time, no announcement. Well, sort of.

I have found a way for MLK to automatically back itself up every day at midnight. This will ensure that backups are done more frequently and systematically! The reason I am announcing this is that MLK will appear offline during the backup, which should only last about 2 minutes. It goes offline because in case someone were to make a post during the backup, the database tables would get corrupted.

To find out exactly when the backups will occur for your timezone, simply click this link: http://www.thetimezoneconverter.com/?t= ... 0Francisco

Re: Nightly Backups

PostPosted: December 23rd, 2010, 3:57 am
by Ushujaa
sounds like a good idea. Looking forward to future updates in the new year ;)

and good thing it's around midnight because that's like 3 am in NY i'm usually in bed by then XD so it won't effect my rping

just one question when will this backing itself up start?

Re: Nightly Backups

PostPosted: December 23rd, 2010, 3:58 am
by Moka
Actually it has been running for 2 days now. I just had to make sure everything was working properly ^^ ...which involved me staying up until 2am for the past two nights. No biggie :P

Re: Nightly Backups

PostPosted: December 23rd, 2010, 4:00 am
by Ushujaa
is that why i was getting 505 errors... :O :? :O

well thanks for pulling all nighters for us!

Re: Nightly Backups

PostPosted: December 23rd, 2010, 4:02 am
by supersimba
Sounds smart ;) is it a part of phpBB or is it a program on the server?

Re: Nightly Backups

PostPosted: December 23rd, 2010, 4:33 am
by Mike
Yer a champ ^.^

Re: Nightly Backups

PostPosted: December 23rd, 2010, 4:48 am
by Zeke
I remember this...and you LIED TO ME and said it would only take 30 seconds so I thought the site blew up but it didn't :P Awesome job on this Moka^^

Re: Nightly Backups

PostPosted: December 23rd, 2010, 5:18 am
by kumarileopard
The time it takes to make the snapshot probably depends on the database size. Though 2 minutes is pretty quick given the amount of data there is (I'm assuming it's a lot of data).

Anyway...glad it's running and works!

Re: Nightly Backups

PostPosted: December 23rd, 2010, 5:37 am
by Pixie
Cool, one question though, when will this happen to people in Australia? Will it be at night still?

Re: Nightly Backups

PostPosted: December 23rd, 2010, 7:40 am
by Moka
[quote="supersimba"]Sounds smart ;) is it a part of phpBB or is it a program on the server?[/quote]

It's a cronjob that I registered on the server.

[quote="kumarileopard"]The time it takes to make the snapshot probably depends on the database size. Though 2 minutes is pretty quick given the amount of data there is (I'm assuming it's a lot of data).

Anyway...glad it's running and works![/quote]

2 minutes to read all the data in the database and then I actually have it gzipped as well. The resulting file is about 87 megabytes. Uncompressed, the file was reaching 400 megabytes.

[quote="Pixielicious"]Cool, one question though, when will this happen to people in Australia? Will it be at night still?[/quote]

Well, Australia has three timezones, but I can tell you that it will happen at either 5:00pm, 6:00pm, or 7:00pm...I think..

I dunno, click the link on the first post and it should tell you automatically based on local time ^^