backup schedule?

0 views
Skip to first unread message

Sudhir Desai

unread,
May 29, 2010, 9:08:45 AM5/29/10
to vanagonwiki

do we have a full/incremental backup schedule?
I have more than enough space on my home server to hold a copy of the backup if needed.

peace,
sudhir

Steve Williams

unread,
May 29, 2010, 9:26:01 AM5/29/10
to vanag...@googlegroups.com
At 06:08 AM 5/29/2010, Sudhir Desai wrote:
>do we have a full/incremental backup schedule?

I dump the SQL nightly and email it to my Gmail account.

I'll switch it over to a Gmail account we share. But it seems
vanag...@gmail.com is already in use. Is that one of us? If not,
I'll create a different Gmail account.

Mike "Rocket J Squirrel"

unread,
May 29, 2010, 9:52:36 AM5/29/10
to vanag...@googlegroups.com

vanag...@gmail.com is one of us, but I'm not sure who. I found this
message in my inbox from 10/26/07:

from Vanag...@gmail.com
to Rocket J Squirrel <camping...@gmail.com>
date Fri, Oct 26, 2007 at 7:56 AM
subject Password reminder from VanagonWiki
mailed-by tower.ymg3.net

Someone (probably you, from IP address 76.176.167.240)
requested that we send you a new password for VanagonWiki
(http://vanagonwiki.net/index.php). The password for user "Rocket J
Squirrel" is now "xxxxxx". You should log in and change your password
now. If someone else made this request or if you have remembered your
password and you no longer wish to change it, you may ignore this
message and continue using your old password.

Might be a mailer built into the old wiki? Looks pretty robot-like.

I hope this is helpful. I have no other messages from or to
vanag...@gmail.com

--
Mike "Rocket J Squirrel" Elliott
84 Westfalia: Mellow Yellow ("The Electrical Banana")
74 Westrailia: (Ladybug Trailer company, San Juan Capistrano, Calif.)
Bend, OR
KG6RCR

Steve Williams

unread,
May 29, 2010, 10:16:10 AM5/29/10
to vanag...@googlegroups.com, vanag...@gmail.com
This email is cc'd to vanag...@gmail.com. I hope the recipient
will reply to let us know who he or she is!

Sudhir Desai

unread,
May 29, 2010, 10:22:39 AM5/29/10
to vanag...@googlegroups.com

it's an account I created, I think. I will have to see about password recovery.

sudhir

On May 29, 2010 10:16 AM, "Steve Williams" <s...@sbw.org> wrote:

This email is cc'd to vanag...@gmail.com.  I hope the recipient will reply to let us know who he or she is!



At 06:52 AM 5/29/2010, you wrote:
>

> vanag...@gmail.com is one of us, but I'm not sure who. I ...

Sudhir Desai

unread,
May 29, 2010, 11:42:34 AM5/29/10
to vanag...@googlegroups.com
I've reset the password, and have access to the account again

Mike "Rocket J Squirrel"

unread,
May 29, 2010, 12:06:10 PM5/29/10
to vanag...@googlegroups.com
Maybe that addy can be used for wiki submissions from the folk that
don't want to do their own posting? Probably more than one person should
have access, probably several if we have some volunteers for copy
editing and posting (I'll help).

Wherever the backups are stashed, more than one person should have
access, too, so it's not dependent on one person being around.

Or maybe something like dropbox.com? 2GB for free, multiple people can
access. Dunno how big the database will get, tho'.

Just tossing out some ideas, waiting for the beans to finish up so I can
make my huevos rancheros.

Sudhir Desai

unread,
May 29, 2010, 12:20:46 PM5/29/10
to vanag...@googlegroups.com

I have a vanagon account on my server already, just have to re-enable it.  I will send a pmail to you (mike), and anyone else (pmail me).

sudhir

On May 29, 2010 12:06 PM, "Mike "Rocket J Squirrel <camping...@gmail.com> wrote:

Maybe that addy can be used for wiki submissions from the folk that don't want to do their own posting? Probably more than one person should have access, probably several if we have some volunteers for copy editing and posting (I'll help).

Wherever the backups are stashed, more than one person should have access, too, so it's not dependent on one person being around.

Or maybe something like dropbox.com? 2GB for free, multiple people can access. Dunno how big the database will get, tho'.

Just tossing out some ideas, waiting for the beans to finish up so I can make my huevos rancheros.



Sudhir Desai wrote:
>
> I've reset the password, and have access to the account again
>

> On Sat, ...

--
Mike "Rocket J Squirrel" Elliott
84 Westfalia: Mellow Yellow ("The Electrical Banana")

74 Westra...

Steve Williams

unread,
May 29, 2010, 2:29:10 PM5/29/10
to vanag...@googlegroups.com
At 08:42 AM 5/29/2010, Sudhir Desai wrote:
>I've reset the password, and have access to the account again

Sudhir, if you're willing to share that password, I'll start sending
backups there.

It's best to keep passwords out of email, so I wonder whether you can
SMS it to my phone (and to the phones of others who want to share the
responsibility)? If so, I'll email you my phone number privately.

jhb

unread,
May 29, 2010, 2:35:33 PM5/29/10
to vanagonwiki
As soon as we have a place to send backups, I'd love to know. I have
an empty mediawiki install I want to populate and start doing horrible
things to in the hopes of getting a usable script together to make
static dumps that can be put on CD. I've offered
vanagonw...@gmail.com (PW:vanagon1) as a dedicated common
account just for holding backups, but anything is good with me.

Sudhir Desai

unread,
May 29, 2010, 2:38:18 PM5/29/10
to vanag...@googlegroups.com

sounds good. I've already emailed the user/pass to mike, but it can be changed.

On May 29, 2010 2:29 PM, "Steve Williams" <s...@sbw.org> wrote:

At 08:42 AM 5/29/2010, Sudhir Desai wrote:
>

> I've reset the password, and have access to the accou...

Sudhir Desai

unread,
May 29, 2010, 2:45:14 PM5/29/10
to vanag...@googlegroups.com

maybe the backups for backup, and the nonbackup for submissions?

Mike "Rocket J Squirrel"

unread,
May 29, 2010, 2:53:52 PM5/29/10
to vanag...@googlegroups.com
Sudhir Desai wrote:
> maybe the backups for backup, and the nonbackup for submissions?
>

Too obvious. They'll be expecting us to do that.

(Sorry -- movie dialog in my head.)

Steve Williams

unread,
May 29, 2010, 3:03:21 PM5/29/10
to vanag...@googlegroups.com

>maybe the backups for backup, and the nonbackup for submissions?

I thought about that, but why should we keep track of two accounts
when one will do? It's not like the backups will interfere with the
submissions.

It's easy to create a filter that'll automatically archive the
backups, so they aren't distracting to those watching for submissions.

Mike "Rocket J Squirrel"

unread,
May 29, 2010, 3:07:38 PM5/29/10
to vanag...@googlegroups.com
Steve Williams wrote:
>
>> maybe the backups for backup, and the nonbackup for submissions?
>
> I thought about that, but why should we keep track of two accounts when
> one will do?

So the folk editing submissions are all members of the group that can
access the backups? Is there a risk there worth thinking about?

Steve Williams

unread,
May 29, 2010, 3:18:11 PM5/29/10
to vanag...@googlegroups.com
At 12:07 PM 5/29/2010, Mike \"Rocket J Squirrel\" wrote:
>So the folk editing submissions are all members of the group that
>can access the backups? Is there a risk there worth thinking about?

There's no risk of disclosing something to the wrong people: The wiki
is completely open as it is.

There's a denial of service vulnerability: A bad player could delete
all of the backups.

I think that risk is outweighed by the down side of having to keep
track of two accounts.

Mike "Rocket J Squirrel"

unread,
May 29, 2010, 3:58:27 PM5/29/10
to vanag...@googlegroups.com
Steve Williams wrote:
> At 12:07 PM 5/29/2010, Mike \"Rocket J Squirrel\" wrote:
>> So the folk editing submissions are all members of the group that can
>> access the backups? Is there a risk there worth thinking about?
>
> There's no risk of disclosing something to the wrong people: The wiki is
> completely open as it is.

Not the secret porn pages I'm planning to put on it. 19th century
stereopticon plates depicting the working-class Irish in various states
of undress. Fetishistic pictures of deciduous tree leaves of North
America. Me in Lady Gaga drag. But I say too much . . . .

> There's a denial of service vulnerability: A bad player could delete all
> of the backups.

It would be trivial for the white hats to download a copy of the latest
backup off gmail, so all we need are a couple volunteers with good habits.

> I think that risk is outweighed by the down side of having to keep track
> of two accounts.

Seems that way to me, too.

--
Mike "Rocket J Squirrel" Elliott

Steve Williams

unread,
May 29, 2010, 7:33:25 PM5/29/10
to vanag...@googlegroups.com
The backups are now emailed daily to vanag...@gmail.com.

All who have access should feel free to delete all but the latest
from time to time. Maybe keep one or two from each month.

Or get creative with filters.

The backup consists of two emails. Right now, the SQL is about
100KB, and the uploads are about 11MB. (In both cases, that's after
compression.) If the size of either gets unwieldy, we can figure out
a different method.

Sudhir Desai

unread,
May 29, 2010, 9:10:30 PM5/29/10
to vanag...@googlegroups.com

can we do a full backup each Sunday, and Wednesday,  and then incrementals on the other days?

if the wiki gets too big for email, please scp the backups to my server. I do weekly backups. (2tb 1+0 raid onto a 1tb raid1 backup)

pmail for info. I will be texting steve the info

sudhir

Steve Williams

unread,
May 30, 2010, 7:23:27 AM5/30/10
to vanag...@googlegroups.com
At 06:10 PM 5/29/2010, you wrote:
>can we do a full backup each Sunday, and Wednesday,� and then
>incrementals on the other days?

Perhaps. But it's simpler to just do a full backup every time.

We don't have to do it every day. I can change it to weekly, or
whatever. But the current size isn't prohibitive for storage on Gmail.

Sudhir Desai

unread,
May 30, 2010, 8:33:44 AM5/30/10
to vanag...@googlegroups.com

ok, cool.

On May 30, 2010 7:23 AM, "Steve Williams" <s...@sbw.org> wrote:

At 06:10 PM 5/29/2010, you wrote:

can we do a full backup each Sunday, and Wednesday,  and then incrementals on the other days?

Steve Williams

unread,
Jun 25, 2010, 8:45:17 AM6/25/10
to vanag...@googlegroups.com
Heh. That didn't take long.

The wiki's database is still getting backed up daily, but last night
the backup of the uploaded files failed because it's too big. (The
last successful gzipped tar file was over 14MB.)

I'll figure out a way to keep backing up the uploads. Either sync
them to the server offered earlier (and to my own server) or only
upload the NEW files each day or each week or something.

Oh, and before we go blaming Mr. Squirrel, it turns out Alistair is
the culprit:

http://www.vanagonwiki.net/wiki/Special:Log/upload

At 05:33 AM 5/30/2010, Sudhir Desai wrote:
>ok, cool.
>
>>On May 30, 2010 7:23 AM, "Steve Williams"

Sudhir Desai

unread,
Jun 25, 2010, 9:30:40 AM6/25/10
to vanag...@googlegroups.com

What about a multi-part tarball?

On Jun 25, 2010 8:45 AM, "Steve Williams" <s...@sbw.org> wrote:
> Heh. That didn't take long.
>
> The wiki's database is still getting backed up daily, but last night
> the backup of the uploaded files failed because it's too big. (The
> last successful gzipped tar file was over 14MB.)
>
> I'll figure out a way to keep backing up the uploads. Either sync
> them to the server offered earlier (and to my own server) or only
> upload the NEW files each day or each week or something.
>
> Oh, and before we go blaming Mr. Squirrel, it turns out Alistair is
> the culprit:
>
> http://www.vanagonwiki.net/wiki/Special:Log/upload
>
> At 05:33 AM 5/30/2010, Sudhir Desai wrote:
>>ok, cool.
>>
>>>On May 30, 2010 7:23 AM, "Steve Williams"
>>><<mailto:s...@sbw.org>s...@sbw.org> wrote:
>>>At 06:10 PM 5/29/2010, you wrote:

>>>can we do a full backup each Sunday, and Wednesday,Ă‚ Â and then

>>>incrementals on the other days?
>>>

>>>Perhaps. Â But it's simpler to just do a full backup every time.
>>>
>>>We don't have to do it every day. Â I can change it to weekly, or
>>>whatever. Â But the current size isn't prohibitive for storage on Gmail.
>

Mike "Rocket J Squirrel"

unread,
Jun 25, 2010, 9:32:06 AM6/25/10
to vanag...@googlegroups.com
Steve Williams wrote:
> Heh. That didn't take long.
>

> Oh, and before we go blaming Mr. Squirrel, it turns out Alistair is the
> culprit:

Can the wiki be set to a maximum file size for photos? In my real life I
routinely get sent photos from customers: out of focus, blurred -- and 4
MB in size.

Steve Williams

unread,
Jun 25, 2010, 11:34:17 AM6/25/10
to vanag...@googlegroups.com
At 06:32 AM 6/25/2010, Mike \"Rocket J Squirrel\" wrote:
>Can the wiki be set to a maximum file size for photos?

Yes, or rather PHP has a configurable limit. It's set to 20MB.

>In my real life I routinely get sent photos from customers: out of
>focus, blurred -- and 4 MB in size.

I'd rather see big, poor-quality photos uploaded than risk
discouraging people from uploading.

Mike "Rocket J Squirrel"

unread,
Jun 25, 2010, 11:41:41 AM6/25/10
to vanag...@googlegroups.com

Fair enough. As long as the storage is there. Giant fuzzy photos are a
pet peeve of mine. No one needs to send anything larger than 50 KB
unless it's fine art.

Steve Williams

unread,
Jun 25, 2010, 12:39:03 PM6/25/10
to vanag...@googlegroups.com
At 08:41 AM 6/25/2010, Mike \"Rocket J Squirrel\" wrote:
>No one needs to send anything larger than 50 KB unless it's fine art.

Actually, I don't agree.

Especially for a web site like this, where we mean this stuff to be
archived forever, it's important to have the original file, no matter
how big. We can't predict today which of those bits will be usable tomorrow.

Yes, a fuzzy photo may be useless forever, but as volunteers we
shouldn't be putting effort into judging each photo.

Let's just take everything, and let our alien overlords sort it out
in the future.

Mike "Rocket J Squirrel"

unread,
Jun 25, 2010, 1:58:51 PM6/25/10
to vanag...@googlegroups.com

After the upcoming zombie apocalypse it won't matter anyway.

Reply all
Reply to author
Forward
0 new messages