utility

MySQL backup - How to backup a MySQL database

MySQL backup FAQ: How do I back up a MySQL database?

I can't speak about backing up MySQL databases that are modified twenty-four hours a day seven days a week, but on all the MySQL databases I currently work with, there are always times when I can guarantee that there won't be any SQL INSERTs, DELETEs, or UPDATEs occurring, so I find it's really easy to perform a MySQL backup using the mysqldump utility program. Here's how it works.

Mac keystrokes and keyboard utilities

After responding to a recent comment about how to map keys/keystrokes on an Apple/Mac keyboard, I thought I'd share a list of Mac keyboard utilities I found. But first, before looking at paying for Mac utilities for your keyboard/keystroke mapping, it's important to know that you can perform some keyboard mapping functions using System Preferences. Just follow these steps:

Perl file example - A program to extract lines from a file

After trying some other approaches, I finally create a Perl program to extract lines from the middle of a file. Just give it the line number to start at, and a second line number to stop at, and this Perl program will print all the lines from the file in that range.

The source code for this Perl program is shown below.

Sample usage:

extract.pl 500 1000 myBigFile > smallerFile

Here's the code for extract.pl:

Syndicate content