Glasgow University graduate. I have wide-ranging interests - please see my about page either here or at roberthallam.com.
tl;dr: run myisamchk on the problematic table I’ve run into the following error in my Apache error.log recently: Table ‘database.tablename’ is marked as crashed and… Read More »[Fixed] MySQL: Table is marked as crashed and last (automatic?) repair failed (+ WordPress)
tl;dr: use jdupes I was merging some fileserver content, and realised I would inevitably end up with duplicates. “Aha”, I thought “time to use good… Read More »Speeding up fdupes
tl;dr: Loop through the files in bash, sox them to FLAC Success! I’ve been combining fileserver contents recently, and I came across a little archive… Read More »Compressing Teamspeak 3 Recordings Using sox
tl;dr: use dmsetup remove before trying lvremove Note: Volume group and logical volume names have been substituted here. I’m not entirely sure it’s necessary, but… Read More »[Solved] “Logical volume is used by another device”
tl;dr: if you’re sure you did everything right, use lsblk or parted (etc) to see if a partition table is present on your logical volume.… Read More »[Solved] “Filesystem is already n blocks long. Nothing to do!”
tl;dr: Seems the quickest way of doing this was to fire up a VM, install mysql-server and mysql-client and browse that way. I have backups… Read More »Browsing MySQL Backups
or them to apply their own standards for listings Gumtree – owned by eBay – is much more popular in the UK than Craigslist, for… Read More »Wanted: Boolean Filters For Gumtree
I’ve been taking my GoPro to Sunday Morning Football (as it is known) for a while now, so I figured I’d automate the process of… Read More »Timesaver: import and combine GoPro Footage with FFmpeg
I am something of a digital hoarder. I have files dating back to one of the earliest computers that anyone in my family owned. I… Read More »Wanted: One LTO-4/5/6/7 Drive!
As someone who has been an avid, long-time user of the distro that bears his name, this is sad news. The Ars Technica article casts… Read More »Ian Murdock Has Passed Away