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.

By Alvin Alexander on January 13, 2012

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:

By Alvin Alexander on October 20, 2012

Java HTML character conversion method

Here's the source code for a Java method that converts a given String into an equivalent new String, where characters that cause problems when rendered as HTML have been converted to their ISO Latin equivalent:

 

By Alvin Alexander on October 17, 2012

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:

By Alvin Alexander on August 6, 2011
Syndicate content