I’ve been doing a few reinstalls on my workstation boxes lately so I put together this list to save myself some time. This will change as I remember/find stuff.
Recently using osCommerce I had a customer who wished to have all the products’ names in uppercase but they had been entered in mixed case. After having some trouble finding a simple answer through Google, I pieced together this simple query that can also be adapted to other situations.
The below is a MySQL query to update all of the products’ names in an osCommerce catalog to uppercase – you can copy this into phpMyAdmin.
UPDATE products_description SET `products_name` = UPPER( `products_name` )
UPDATE table_name SET `column_name` = UPPER( `column_name` )
So my reckless typing really got me into trouble this time. I was attempting to zero-out a usb drive when I managed to put the wrong device in the dd command – I automatically typed sda1 (the primary HD) out of habit instead of sdb1 – the usb drive. I caught my mistake and gave it a solid control + c but I had still wiped out the first 60 MBs of the drive.
So everyone trashed on KDE 4.0, I’ll admit I wasn’t impressed either, until I read the articles explaining that this is more of a milestone release – getting the core together, and that future releases will be something worth getting excited about.
Ok so I started out using rsync with the options ‘-a –progress –delete’ and I thought that was doin’ the job just fine. But recently I migrated our old 600mhz Dell Optiplex GX110 to a Sans Digital MobileNAS MN2L dual drive RAID NAS and the rsyncs weren’t going as planned.
Yet another clean little tweak. Continue reading “Custom Background for Classic Login in Windows XP”
I came across this cool registry setting a while ago and had to look it up again. Continue reading “Custom Visual Style for Classic Login Box in Windows XP”
If you lose any of your user passwords – including root you can change your password booting into single user mode. What you aren’t likely to find off the bat is the proper instructions to do it. They are out there, but chances are you will have to dig a little after some frustration. The main differece between all those super simple solutions and the one mentioned here is that you need to remount the OS drive in order to properly write your changes. This method has worked with the last three major releases of Ubuntu including Feisty. So, here’s the procedure…
After an unscheduled reboot (breaker went out) we had a CentOS web server running Plesk coming up with a kernel panic on boot – actual error: