Archive for April, 2008

Shell History Meme

Posted in Fedora, General, Linux SysAdmin on April 10th, 2008 by Johan Huysmans – Be the first to comment

There is a Shell history meme going on on planet Fedora; Let’s join.

[johan@laptop ~]$ history|awk '{a[$2]++ } END{for(i in a){print a[i] " " i}}'|sort -nr|head
201 ls
108 ssh
108 cd
98 sh
81 su
29 vi
24 rpm
24 ping
23 rm
20 mv

[johan@workstation ~]$ history|awk '{a[$2]++ } END{for(i in a){print a[i] " " i}}'|sort -nr|head
149 ls
128 cd
125 cvs
93 diff
71 echo
54 ssh
45 for
28 mkdir
26 md5sum
24 reset

My previous post of my Top 10 used commands was more than 1 year ago.

MySQL MYD and TMD files

Posted in Backup, WordPress on April 8th, 2008 by Johan Huysmans – 3 Comments

I just recovered from a database issue.

While running a mysqldump of my databases I received an error. Running a check on that specific database told me that the comments.MYD file was not found.

Investigating on the system showed me that due to an error the filesystem containing /var/lib/mysql was mounted read-only. Running a fsck on that specific filesystem solved that error but didn’t fix my corrupted table.

phpMyAdmin showed that the table was in use and while performing a check or repair it complained about the missing file.

The comments.MYD file was indeed missing, but there was a comments.TMD file, which wasn’t there for all the other tables.

Moving this TMD file to MYD solved the issue. I could repair the table and the check is again successful.

During this problem wordpress didn’t complain but it just didn’t show my comments. But I have no clue what caused this problem.

Fedora upgrade

Posted in Fedora on April 7th, 2008 by Johan Huysmans – 2 Comments

Fedora 9 will be released this month, this means that Fedora 7 will be end-of-live within 2 months (1 month after the release of Fedora 9 to be exact).

As one of my desktops was still running Fedora 7 it was time to upgrade to the current stable Fedora, Fedora 8.

On the Fedora wiki you can find a list of instructions to upgrade your machine using yum. It will list the general actions but also the execptions for each upgrade.
You can find these instructions here: http://fedoraproject.org/wiki/YumUpgradeFaq

The upgrade went very smooth, but isn’t recommended for non-technical users as it all happens on the command line.
For those non-technical users a graphical user interface which guides you through the complete process would be very handy (Ubuntu has it already, don’t know if it is available in Fedora 8/9).
I prefer the upgrade with yum as I want to know what my machine is doing.