gzip backup a mysql database

April 8th, 2008

It’s handy, fast, and convienient to you mysql on the command line.
Lately, what I’ve been using it most for is to back up and restore
databases. I don’t do it often enough to have the commands committed to
memory, but everytime I need it I go searching for it again. Rather
than trying to find my previous search results again I’ll post them here
with a summary.

To back a mysql database into a gzipped archive:

mysqldump [database] | gzip > backup.sql.gz

To restore the backup:

gunzip < backup.sql.gz | mysql [database]

Reference: web cheat sheet

I’m still a guy

April 7th, 2008

Something to remind you what is is to be a man, in case you’ve forgotten.  Thanks, honey for the Monday morning laugh.

GPG Encrypt Gmail on the go

April 4th, 2008

Now you can have GPG encryption of your Gmail. This becomes pretty powerful when combined with portable firefox. Even Google would have a hard time cataloging and data mining your email. It works nicely.

Technorati Tags:

Growl for Linux?

April 3rd, 2008

Was looking into some Growl like apps for linux.

I found mumbles while looking for this howto over here.

Sports a nice list of extras

Update: Geyser at first glance seems similar, well the author of mumbles is offering to work together.

Another Update [4-7-2008]: Found this dbus hackery using python. And the I found specto listed over at propeller. Which I’m not familiar with, but assume it’s for propeller-heads like me. :-) Here’s a neat trick to display any message you choose in a pop-up. Looks like they use it to get notifications about automated tests. And then he found mumbles and re-worked his hack.

Not for Linux specifically, but too cool none-the-less. PHP Growl. Could possibly use this from the shell to notify myself of all sorts of things. Will need to take a look into this asterisk call notification via Growl as well

Technorati Tags:

GPG Keys on an Encrypted Pen Drive

March 23rd, 2008

This one I pretty much followed what this link said to do. I’m poting it here so it’s easier to find later.

Technorati Tags:


Creative Commons License
This work is licensed under a Creative Commons Attribution-NoDerivs 2.5 License.