Author Archives: admin

LVM Breaks When Upgrading Debian Etch to Lenny 4.x to 5.0

Using the standard upgrade proceedures, Debian Etch + LVM will fail to upgrade to Debian Lenny gracefully.  This is due to the kernel modules and is simple to avoid. Before changing apt sources (They should be etch) apt-get update apt-get … Continue reading

Posted in Debian, How Tos, LVM | 4 Comments

PERL How To Print A List Without A Loop

PERL has a built-in function called join() that will concatenate a list with a given string. The official perldoc states: join EXPR,LIST Joins the separate strings of LIST into a single string with fields separated by the value of EXPR, … Continue reading

Posted in How Tos, perl, Programming, Software | Leave a comment

SQL: Select duplicate rows, select indistinct rows

Using SQL, MySQL or whatever your favorite database may be, we all know using SELECT DISTINCT will return unique values in case a value appears more than once in a table. How do you fine duplicates? What if I want … Continue reading

Posted in How Tos, mysql, SQL | Tagged , , | 1 Comment