mysqlshow –status yourdbnamehere |sort -n -k10 |awk -F\| ‘($6 !~ /0/)’ |awk -F\| ‘{print $2 ” ” $6 ” ” $7 ” ” $14}’ |egrep -v “^ ” Name Rows Avg_row_length Update_time wp_links 1 128 2009-06-14 04:30:57 wp_comments 11 536 2009-12-01 02:43:25 wp_terms 12 30 2009-10-26 00:37:54 wp_term_taxonomy 13 47 2009-12-01 01:23:39 wp_users 13 118…

I’m fond of WHOIS data for getting an idea who’s visiting a site, though most WHOIS servers return data that’s full of disclaimers and irrelevant data. Rather, I much prefer Team Cymru’s batch WHOIS lookup server, whois.cymru.com. First, extract your IPs: F=ips.out ; echo “begin”>>$F ; echo “verbose”>>$F ; awk ‘{print $1}’ tech-access_log |sort |uniq>>$F…

From: Guy Hammer Here is a script to save a bunch of keystrokes. Make a file /usr/local/bin/psgrep . Paste the following into it: —start— #!/bin/bash # # psgrep – search for a process by pattern. ps -ef | grep -v grep | grep $1 —end— Make the script world executable. Now you just have to…

The “bash: ./configure: /bin/sh: bad interpreter: Permission denied” error commonly occurs when you have wrong options set in /etc/fstab and are trying to compile some code. The partition that you have mounted that stores the source code you are trying to compile is identified in /etc/fstab by a line similar to the following one, also/etc/mtab…

The disadvantage of using encrypted partitions is that while the partition is mounted, at least root can access the data. To prevent this, vi can be used in encrypted mode. Use vi -x filename to edit a new file. vi prompts you to set a password, after which it encrypts the content of the file….

Linux is built to be inherently secure, and has a great track record of having superior security to its proprietary counterpart. However, in the world of server administration, paranoia is an asset. How else could someone get in? How can I prevent that? How can I be notified? One magnificent contribution to the security of…

There is a very simple command that re-installs all the distribution packages and reconfigures them automatically. This is particularly helpful when you have done a partial upgrade and eventually have broken the system dependencies tree. sudo dpkg-reconfigure -phigh -a since this command would take a lot of time to process (~1 hour) depending on your…

http://drupal.org/node/647374 Fully packaged Drupal distributions now deployed on drupal.org 3281d Consulting is very pleased to announce that a new era on drupal.org has begun: Drupal distributions (also known as “installation profiles”) can now be automatically packaged with Drupal core and all of their required dependencies. When you download the distribution, you just unpack it into…

Some wget tricks The wget is a command line utility that can download files from web servers and FTP servers. For example , you can download the DVD image of Karmic Koala using the following command. $ wget http://cdimage.ubuntu.com/releases/9.10/release/ubuntu-9.10-dvd-i386.iso If an FTP server requires a login and password, you can enter that information on the…

A large part of every Linux forum’s work is dealing with enquiries by Linux novices. While it can be very enjoyable to help others, it can also be rather tiresome to try to help people who have shown no inclination towards helping themselves. However I believe that in many cases, this is not due to…