All Blog Categories

It's been a while since I've written a blog post to my website, but I guess I've just been busy with a lot of things going on in my life. I've been travelling a ton for work - which has been really cool, but has kept me ultra busy. Since the beginning of the year, I've been on business trips to:

Austin, Texas
Punta Cana, Dominican Republic
Malta, Malta (South of Italy) - Stayed in London, England for a 2 nights
San Francisco, California
Shenzhen, China

The following is a short code snippet on how to view which MySQL databases are available for a user, then a command to back them up. This should work on Unix and Linux variants.

To view what databases are available to be backed up, run the following command:
$ mysql -u root -h localhost -p -Bse 'show databases'

To backup each database, run the following command:
$ mysqldump -u root -h localhost -pmypassword databasename | gzip -9 > faqs-db.sql.gz

I set a lot of reminders for myself on my company e-mail and I don't have a blackberry yet. I kind of want one for all the great features, but on the other hand I'm concerned with how connected that would make me and thus make me feel obligated to respond. Here's a list of e-mail addresses for some of the most popular carriers (in the US) just replace phonenumber in the addresses below with the proper phone number.

T-Mobile: This email address is being protected from spambots. You need JavaScript enabled to view it.

Virgin Mobile: This email address is being protected from spambots. You need JavaScript enabled to view it.

Cingular: This email address is being protected from spambots. You need JavaScript enabled to view it.

Sprint: This email address is being protected from spambots. You need JavaScript enabled to view it.

Verizon: This email address is being protected from spambots. You need JavaScript enabled to view it.

Nextel: This email address is being protected from spambots. You need JavaScript enabled to view it.

As a side note, you can also do this with a service called teleflip. It's the same thing as sending it to one of the other formats, but it adds a footer to the e-mail that says "Email on your cell - teleflip.com". I just use my SprintPCS address like above to send reminder messages to myself and it's not that hard for me to remember the one address. I can see how it would be beneficial if you wanted to send messages to multiple people though. Teleflip also has some commercial offerings on their website that do more advanced e-mail to SMS features. To use teleflip, send the e-mail to the following:

Teleflip: This email address is being protected from spambots. You need JavaScript enabled to view it.

Here's a quick code snippet on how to backup files and restore them from the shell.

To back them up, run the following code:

$ tar -zcvf filename.tar.gz folder/

$ tar -zcvf filename.tar.gz .

$ tar -zxvf filename.tar.gz