Linux

Performing a case-sensitive search-and-replace through a table is easy with MySQL when you know how.

UPDATE table_name SET table_field = REPLACE(table_field, 'replace_that', 'with_this');

This has proved useful for updating Drupal's files table where the paths are incorrect. I hope this helps someone

Finally upgraded my LCD monitor to LGW2242T FLATRON Widescreen -- cannot get the colours right and IMHO it truly is not suited to professional graphics but MC rocks! As does the IDE, for super long lines of code :P

Here it is, be sure to change the USER variable and make sure you irssi config is set up to to what you need.

to access type 'screen -x irc'

If you'd prefer not to have to type a password to execute commands as root with sudo

Edit the /etc/sudoers
#visudo
or
#vi /etc/sudoers

add a line for your user in this case mine is "chris"

chris ALL=(root) NOPASSWD: ALL

:qw
#

If your delete key terminal code is wrong, but the code for backspace is alright, you can put this in your .vimrc:

:fixdel

This works no matter what the actual code for backspace is.

By default "apt-get remove package" doesn't purge everything related to the package. This eventually means that a log of configuration files are left scattered around the place with no corresponding packages. A couple of weeks ago, the following solution was proposed on #linux:

After a bit of searching, I could not find Maildir support in Alpine although it does support IMAP over SSL nicely as did Pine.

I found it was as simple as checking that ssh via key (as apposed to user/pass aauthentication) was working to the mail server. If you have not already, set up your authorized key on the server.

Then setting the Alpine inbox to your server's hostname example.com

chris@server:~$ ssh server /usr/sbin/dovecot --exec-mail imap

* PREAUTH ...CUT... Logged in as [YOU]