LGF

more options

  

log in
Name:
Pass:

Register (closed) Forgot Your Password? My Account Re-send Confirmation (To log in, cookies must be enabled in your browser!)
You must have Javascript enabled to use the contact form.
Your email:

Subject:

Message:


Messages may be published in our weblog, unless you request otherwise.
Tech Note:
Using the Contact Form

now playing

Recently Played

Advertisement

Zombie: 9/11 Truth March at the Democratic National Convention
On the second day of the Democratic National Convention in Denver, a “truther” organization called We Are Change sponsored the “9/11 Truth March.” I didn’t expect more than a few dozen people to show up, but was surprised and a little disturbed at how large it turned out to be — the crowd numbered in the hundreds.

Zombie: I Went to Invesco and All I Got Was This Lousy Report
I tried to find the beginning of the line — a line which seemed to have no beginning or end. I made the mistake at first of trying to go toward the entrance. Foolish me.

Zombie: The Democratic Convention Giant Puppet Parade
On Tuesday, a group called The Backbone Campaign sponsored a parade they call "Procession to the Future," but which is better known in journalistic circles as Giant Puppets!

Zombie: Scenes from a Convention
Not everything that happens outside the Democratic National Convention fits into a “theme” of some sort. The following series of images were all taken within the space of two hours. Here's a more gut-level impression of what walking around Denver is like this week.

Zombie: Pro-Hillary March
On Tuesday, some Hillary Clinton die-hards held a march along the “designated parade route” from Denver’s Civic Center Park to the “free speech zone” at the Pepsi Center, where the convention is being held. Their goal: a last-ditch attempt to secure the nomination for Hillary.

Reading links...

  

Link address:
Link title:
Description: 
Remaining:

Tech Note: Database Backup Revamp

Thu, Apr 17, 2008 at 6:12:02 pm PST

Stinky and I are finally getting around to a much needed redesign of the backup system for our MySQL database, to give us regular nightly automatic backups instead of the semi-manual backup we’ve been doing. Imagine the great noise that would issue forth from the lizard army if the server crashed and we lost a week’s worth of comments.

The new system has two parts:

* On the DB server, a cron job calls a shell script that renames the current backups with a .bak extension, then uses mysqldump to dump out the database tables needed to recreate LGF if disaster strikes.

* On our desktop Mac, a cron job calls the ‘rsync’ command to connect to the database server through SSH (an hour or so after the server’s cron job runs), and synchronizes the folder containing those dump files to a local folder.

Rsync is smart; when a file exists on the destination (our office Mac), it only downloads the changed section of the file and merges it with the existing one. This saves an enormous amount of time and bandwidth, especially on the 2.5GB+ dump of our comments table.

And because it connects through SSH, the transfer is encrypted and as secure as possible.

This system gives us a two level backup system on the DB server, but since our local computer also uses Apple’s Time Machine backup system, we actually have the ability to restore from even further back if it’s ever necessary.

Backups within backups.

And now... the open thread.

1335 comments

  • Comments are open and unmoderated, and do not necessarily reflect the views of Little Green Footballs.
  • Obscene, abusive, silly, or annoying remarks may be deleted, but the fact that particular comments remain on the site in no way constitutes an endorsement of their views by Little Green Footballs.
  • Posts that contain phone numbers, addresses, or other personal information will also be deleted, as will posts that consist only of a variation on the word, "First!"
  • Comments that advocate violence will be cause for immediate banning with no appeal.
  • REMEMBER: posting comments at LGF is a privilege, not a right. Abuse that privilege, and your account will be blocked.

Hide comments | Jump to bottom

#1 Lively 4/17/08 6:13:28 pm 0

Easy for you to say.

/Charles is so smart

#2 Gang of One 4/17/08 6:13:57 pm 0

I understand nada, but I am sure it is a good thing.

#3 joncelli 4/17/08 6:14:43 pm 0

That entire discussion made a tingle run up my leg.

#4 Lively 4/17/08 6:14:54 pm 0

re: #2 Gang of One

I understand nada, but I am sure it is a good thing.

I know what you mean. I'm lucky I can answer my cell phone.

#5 seekeroftruth 4/17/08 6:15:12 pm 0

A week with out LGF ...... words fail me.
Thanks for this great blog Charles!

#6 Lively 4/17/08 6:15:19 pm 0

re: #3 joncelli

That entire discussion made a tingle run up my leg.


Was there any pain?

/Then you're not a true Democrat

#7 Zach_the_Lizard 4/17/08 6:16:32 pm 0

I think there's a typo; MySL should be MySQL.

#8 Charles 4/17/08 6:16:35 pm 11

You never know how important backups are until your hard drive fails, and your last backup is 4 months ago.

#9 joncelli 4/17/08 6:16:54 pm 0

re: #6 Lively

/Then you're not a true Democrat

You say that like it's a bad thing...

#10 Lively 4/17/08 6:17:40 pm 0

re: #9 joncelli

You say that like it's a bad thing...


I'm kidding around with you. ;)

#11 Bob in Breckenridge 4/17/08 6:18:44 pm 0

re: #8 Charles

You never know how important backups are until your hard drive fails, and your last backup is 4 months ago.

/www.carbonite.com!

#12 song_and_dance_man 4/17/08 6:18:56 pm 0

Freakin Stinky is aladam lucky

#13 MarineGrunt 4/17/08 6:19:20 pm 0

Charles sounds like my old Senior DI first day at PI.
Looking straight ahead with a dumb a$$ look on my face trying to figure out what the heck he was saying.

#14 song_and_dance_man 4/17/08 6:19:59 pm 0
#15 Zach_the_Lizard 4/17/08 6:20:30 pm 0

I see the typo is now fixed. Soon, soon I shall transform my typo correcting ability into a tool of the darkest, blackest evil! BOW DOWN!

Yes, I have no life.

#16 jcm 4/17/08 6:21:27 pm 0

I never need a bac.....

zzzfffft POP!


whrrrrrrrr... r...r..........

#17 Bob in Breckenridge 4/17/08 6:21:33 pm 0

re: #15 Zach_the_Lizard

I see the typo is now fixed.

/What typo?

#18 Sol Roth 4/17/08 6:21:37 pm 0

How much is a cron job going for these days anyway?

#19 NY Nana 4/17/08 6:24:37 pm 0

Charles,

Now when I do a search, and click on the post I want to read, instead it takes me to the top of the thread rather than the post. This has been since, IIRC, about Sunday or Monday.

Is this permanent? Another lizard also has the same thing happen.

/A computer wizard I ain't.

#20 goddessoftheclassroom 4/17/08 6:24:37 pm 0

re: #15 Zach_the_Lizard

I see the typo is now fixed. Soon, soon I shall transform my typo correcting ability into a tool of the darkest, blackest evil! BOW DOWN!

Yes, I have no life.

I've been known to take a red pen to signs at Wal-Mart using "it's" for "its."

I also noticed that Obama cannot use "whom" correctly nor use the possessive pronoun with a gerund. So much for a Harvard education.

#21 DesertSage 4/17/08 6:25:11 pm 1

Viagra is like a backup for hard drive failure also.

#22 joecitizen 4/17/08 6:25:11 pm 0

how do Lizards? all is well,obamassiah is imploding,my Penguins rock ,and its damn near flower planting time..quick question for ya Charles if your still around..while turning my little bro onto your work with mr.Jarreau,it occurred to me that I caught his act right around that time at the Civic Arena in Pittsburgh..any chance you were with him then?I'd consider it a feather in my musical bonnet if I could claim to have heard yer play live

#23 USBeast 4/17/08 6:27:02 pm 0

"Imagine the great noise that would issue forth from the lizard army if the server crashed and we lost a week’s worth of comments."

Uh, Charles, are you sure you want to give Kos any technical clues?

Imagine the great noise that would issue forth from the Kos Kiddies if their server crashed and they lost a week's worth of comments:

"Hey, what happened...I posted last night...or was it the night before...no...the night before I was out all night trying to hunt down my...no that was this morning...I could have sworn I...S**t...Anyway, Bush lied...gotta stay on message...Bush lied..."

#24 JCM 4/17/08 6:27:42 pm 0

re: #14 song_and_dance_man

Lucky Stinky

Will the backup be unbroken.

#25 NY Nana 4/17/08 6:28:28 pm 0

Charles,

Now when I do a search, and click on the post I want to read, instead it takes me to the top of the thread rather than the post. This has been since, IIRC, about Sunday or Monday. I write down the number of the post now, and scroll the thread till I get to it.

Is this permanent? Another lizard also has the same thing happen.

/A computer wizard I ain't.

#26 Bob in Breckenridge 4/17/08 6:29:19 pm 0

re: #20 goddessoftheclassroom

I've been known to take a red pen to signs at Wal-Mart using "it's" for "its."

I also noticed that Obama cannot use "whom" correctly nor use the possessive pronoun with a gerund. So much for a Harvard education.

Or Michelle "Me and Barack..." Obama, she of the Harvard and Priceton ed-u-ma-cayshun...

#27 DesertSage 4/17/08 6:29:31 pm 0

If we can just get rid of everybody's guns and God, then no one will be bitter anymore.

Then we can start the Marxist takeover of America!

/Obama

#28 Bob in Breckenridge 4/17/08 6:30:08 pm 0

re: #26 Bob in Breckenridge

PIMF- Princeton.

#29 JCM 4/17/08 6:30:28 pm 0

re: #20 goddessoftheclassroom

I've been known to take a red pen to signs at Wal-Mart using "it's" for "its."

I also noticed that Obama cannot use "whom" correctly nor use the possessive pronoun with a gerund. So much for a Harvard education.

LOL, you can take the teacher out of the class room, but can't take the teacher out of the goddess!

#30 razorbacker 4/17/08 6:30:33 pm 3

Oh, hell, Charles. Now you're just stringing random syllables together to see if we're paying attention.

I ask you, is that nice?

#31 macintush 4/17/08 6:30:36 pm 0

Dangit - Updated the mac-mini server to Leopard today, and it ate the hard drive. The pain!

Oh, but the good news is, it was all backed up!

Ha!

#32 JCM 4/17/08 6:31:13 pm 0

re: #27 DesertSage

If we can just get rid of everybody's guns and God, then no one will be bitter anymore.

Then we can start the Marxist takeover of America!

/Obama

The line for Joycamp starts behind Desert.

/Michelle

#33 USBeast 4/17/08 6:31:13 pm 1

re: #28 Bob in Breckenridge

PIMF- Princeton.

Given college tuitions, I think you had it right the first time.

#34 joecitizen 4/17/08 6:31:30 pm 0

re: #27 DesertSage

If we can just get rid of everybody's guns and God, then no one will be bitter anymore.

Then we can start the Marxist takeover of America!

/Obama

im wondering how long this cat can blatantly lie about all and sundry before it starts to really show up in the polling..

#35 DesertSage 4/17/08 6:31:31 pm 1

Viagra is like a backup for a failed hard drive.

#36 thoughtcrime 4/17/08 6:31:35 pm 0

re: #27 DesertSage

If we can just get rid of everybody's guns and God replace their god, then no one will be bitter anymore.

Then we can start the Marxist takeover of America!

/Obama

Fixed it for ya....

#37 wolfie 4/17/08 6:32:29 pm 0

re: #31 macintush

Dangit - Updated the mac-mini server to Leopard today, and it ate the hard drive. The pain!

Oh, but the good news is, it was all backed up!

Ha!

Was that trickle-up pain?

#38 JCM 4/17/08 6:32:39 pm 0

re: #31 macintush

Dangit - Updated the mac-mini server to Leopard today, and it ate the hard drive. The pain!

Oh, but the good news is, it was all backed up!

Ha!

I a networkbug but take down my XP box at work, 7 hours to get it back up and restored.

#39 thoughtcrime 4/17/08 6:33:50 pm 0

re: #37 wolfie

Was that trickle-up pain?

Is trickle-up pain the same as when my 3 year old is whining and I am sick of it?

I mean, isn't obama like gonna be our daddy?

#40 Syrah 4/17/08 6:33:53 pm 1

Singing the Dada Base Blues

#41 Bob in Breckenridge 4/17/08 6:35:02 pm 0

re: #33 USBeast

Given college tuitions, I think you had it right the first time.

LOL! Maybe it was subliminal!

#42 joecitizen 4/17/08 6:35:32 pm 2

re: #40 Syrah

Singing the Dada Base Blues

well,hello Dali..

#43 DesertSage 4/17/08 6:36:01 pm 0

re: #39 thoughtcrime

Is trickle-up pain the same as when my 3 year old is whining and I am sick of it?

I mean, isn't obama like gonna be our daddy?

Obama will replace God and guns.

We won't be bitter anymore. We will cling to Obama instead.

He is the anointed one!

#44 USBeast 4/17/08 6:38:07 pm 2

re: #43 DesertSage

Obama will replace God and guns.

We won't be bitter anymore. We will cling to Obama instead.

He is the anointed one!

Yea verily he shall be anointed. With tar shall he be anointed and a coat of feathers will clad him and the multitude will rejoice.

#45 JCM 4/17/08 6:38:11 pm 0

re: #43 DesertSage

Obama will replace God and guns.

We won't be bitter anymore. We will cling to Obama instead.

He is the anointed one!

Praise Obama The Bringer of Change!

#46 JCM 4/17/08 6:38:52 pm 0

re: #44 USBeast

Yea verily he shall be anointed. With tar shall he be anointed and a coat of feathers will clad him and the multitude will rejoice.

And the congregation said AMEN!
Raise your pitchforks and torches in acclimation!

#47 EC Marm 4/17/08 6:39:26 pm 0

re: #43 DesertSage

He is the anointed one!


No, he is the annoying one.
Because we all have to waste an enormous amount of time finding out all of his little secrets, lies, and half-truths.

#48 Slumbering Behemoth 4/17/08 6:39:35 pm 2
* On the DB server, a cron job calls a shell script...

And tonight's headline at the DailyKos:

Charles Johnson of LGF blatantly admits to running con jobs and shell games.

/Spin

#49 psaturn 4/17/08 6:39:57 pm 0

Hi everyone ! Hope everyone is doing well...

Techie stuff, I upgraded my 4 yr old Mac dual G5 with more RAM and everything runs much faster! I ordered more RAM and so I will have 8 gig or RAM total...for a 4 yr old computer! It was $65 for a pair of 1 gigabyte of matched RAM chips which was not too bad...

Tonight or tomorrow I shall try to copy this HD to the new 1 TB hard drive....and make it into the main drive...hope it works!

#50 mikeymom 4/17/08 6:40:00 pm 0

when i joined lgf, i assumed it was in english. that last post by charles has me thinking i was wrong!

#51 USBeast 4/17/08 6:40:14 pm 0

re: #46 JCM

And the congregation said AMEN!
Raise your pitchforks and torches in acclimation!

Thank you, brethren. Now the plate shall be passed. Dig deep, brethren...dig deep.

#52 joecitizen 4/17/08 6:40:34 pm 0

re: #44 USBeast

Yea verily he shall be anointed. With tar shall he be anointed and a coat of feathers will clad him and the multitude will rejoice.

except these days we tar and feather with a 47 or 48 state electoral loss..he'll be lucky if he takes Illinois,Hawaii and Vermont..inshalla

#53 razorbacker 4/17/08 6:40:51 pm 0

re: #45 JCM

Praise Obama The Bringer of spare Change!and you'll be damned lucky to have that left

#54 guzziguy 4/17/08 6:41:11 pm 0

Did anyone other than me cruise some of the lefty commentators to read about their distress over a couple of real questions being asked last night.

Funny stuff out there.

#55 unrealizedviewpoint 4/17/08 6:41:14 pm 1

Backups are very important. Mine is a .32 Caliber Colt Pony.

#56 JCM 4/17/08 6:41:33 pm 1

re: #48 Slumbering Behemoth

And tonight's headline at the DailyKos:

Charles Johnson of LGF blatantly admits to running con jobs and shell games.

/Spin

His an admitted killer. He kills threads while they sleep!

#57 joecitizen 4/17/08 6:42:00 pm 0

re: #50 mikeymom

when i joined lgf, i assumed it was in english. that last post by charles has me thinking i was wrong!


it is English,just the Lizardkings English.

#58 psaturn 4/17/08 6:42:19 pm 0

re: #8 Charles

You never know how important backups are until your hard drive fails, and your last backup is 4 months ago.

Now there is no excuse, external hard drives are quite reasonably priced...Costco had 1 TB WD HD with eSata, Firewire and USB2 for $250....just barely over the cost of HD alone !

#59 RememberSekhmet? 4/17/08 6:42:24 pm 2

They all came out to Denver
On the Rocky Mountain shoreline
To win in 2008
They didnt have much time
Hillary and the Demos
Were at the best place around
But some stupid with a race card
Burned the place to the ground
Blood in the water, fire in the sky

They burned down the Convention
It died with an awful sound
Howard Dean was running in and out
Pulling kids out the ground
When it all was over
It looked a scene from outer space
But campaign time was running out
It seemed that they would lose the race
Blood the water, fire in the sky

McCain winds up at the ol' White House
It was empty cold and bare
But with the Straight Talk Express thing just outside
Making our music there
With a few tax cuts and a few good friends
We make a place to sweat
No matter what we get out of this
I know well never forget
Blood in the water, fire in the sky

from Smoke on the Water

#60 mikeymom 4/17/08 6:42:38 pm 0

re: #57 joecitizen

is greek to me--am i a racist?

#61 unrealizedviewpoint 4/17/08 6:42:58 pm 0

re: #57 joecitizen

it is English,just the Lizardkings English.

Well I for one am glad he's bilingual.

#62 taxfreekiller 4/17/08 6:43:10 pm 0

just what we need another line of t-storms, some hail, some wind,
the TV of NBC-5 KSAS has just shown hail drifts in western Tarrant County, West Ft. Worth, Weatherford , the trees got de-leaved

were next should get here to Delta County around 10:30 / 11:00

not good this global warming, the hail will freeze your ass off

#63 JCM 4/17/08 6:43:34 pm 0

re: #58 psaturn

Now there is no excuse, external hard drives are quite reasonably priced...Costco had 1 TB WD HD with eSata, Firewire and USB2 for $250....just barely over the cost of HD alone !

I back up to an external once a week, and take it work. If the house burns to the ground, I lose 6 days at the most.

#64 Grammy Cracker 4/17/08 6:43:37 pm 0

re: #50 mikeymom

when i joined lgf, i assumed it was in english. that last post by charles has me thinking i was wrong!

Mostly English, with occasional GeekSpeak thrown in. LOL

#65 wolfie 4/17/08 6:43:43 pm 0

re: #51 USBeast

Thank you, brethren. Now the plate shall be passed. Dig deep, brethren...dig deep.

And verily they will.
You know, this clown is gonna have a whole lot of money to bamboozle the electorate.

#66 joecitizen 4/17/08 6:43:52 pm 0

re: #60 mikeymom

is greek to me--am i a racist?


or a techist?

#67 USBeast 4/17/08 6:44:01 pm 0

re: #54 guzziguy

Did anyone other than me cruise some of the lefty commentators to read about their distress over a couple of real questions being asked last night.

Funny stuff out there.

Yeah, I saw some of the bleating. Softball pitches ain't good enough for them. They demand Nerf.

#68 looking closely 4/17/08 6:44:50 pm 0
since our local computer also uses Apple’s Time Machine backup system, we actually have the ability to restore from even further back if it’s ever necessary.


A time machine?

Can I have my hot ex-girlfriend back?

#69 JCM 4/17/08 6:44:52 pm 0

re: #66 joecitizen

or a techist?

Of with their hard drive heads those who don't speak geek!

#70 DesertSage 4/17/08 6:44:53 pm 1
#71 thoughtcrime 4/17/08 6:44:58 pm 0

re: #55 unrealizedviewpoint

Backups are very important. Mine is a .32 Caliber Colt Pony.

That they are!

My primary is a 45, which keeps me above the whole 9 and 40 debate.

But 'real problems' are solved with a 308

And if anyone asks, the 223s are for the ladies in the house.......

#72 Grammy Cracker 4/17/08 6:45:06 pm 0

re: #60 mikeymom

#73 Slumbering Behemoth 4/17/08 6:45:26 pm 0

re: #5 seekeroftruth

A week with out LGF ...... words fail me.
Thanks for this great blog Charles!

I feel your pain know where you're coming from. Last month my motherboard fried and I had to wait for over a week to get the parts needed to rebuild.

#74 mikeymom 4/17/08 6:45:46 pm 0

re: #69 JCM

that was sooo cruel

#75 joecitizen 4/17/08 6:46:01 pm 0

re: #69 JCM

Of with their hard drive heads those who don't speak geek!


well,I read Geek but dont speak it.

#76 NY Nana 4/17/08 6:46:08 pm 0

re: #50 mikeymom

when i joined lgf, i assumed it was in english. that last post by charles has me thinking i was wrong!

Pheeew! I'm not the only one! Thank you. I feel so much better.

#77 Grammy Cracker 4/17/08 6:46:11 pm 0

re: #60 mikeymom

is greek to me--am i a racist?

Let's try this again....

Don't ask me, I'm a Cracker! LOL

#78 Bob in Breckenridge 4/17/08 6:47:06 pm 0

re: #50 mikeymom

when i joined lgf, i assumed it was in english. that last post by charles has me thinking i was wrong!

Nope, it's in American.

#79 nyc redneck 4/17/08 6:47:28 pm 0

re: #65 wolfie

And verily they will.
You know, this clown is gonna have a whole lot of money to bamboozle the electorate.

but not enough to disguise his true commie nature. he will implode.
it's going to be a rough landing too. (watch for the wife to screech like the melting wicked witch)

#80 opnion 4/17/08 6:47:36 pm 7