Skip to content

Monthly Archives: March 2010

Using a Windows XServer to access the Gnome desktop on a Linux Server

Friday, March 26, 2010

I wanted to throw a shout-out to a software package called Xming X Server.  I have been using this nifty piece of software to access the Gnome desktop of our corporate Linux servers from the comfort of my Windows based laptop.  Xmind does this my running a XServer under Windows, and using a customized version of Putty to forward all the X packets across a SSH connection.  Even on Internet connection, the performance is very acceptable, and when on a local LAN, it approaches native speed.

A limited version of Xming has been released into the public domain, but throw Mr Colin Harrison £10 and he will send you an unencumbered version.  I am interested to hear from other folks who are using a Windows XServer to connect to a Linux or Mac.

Filed in Other | Tagged , , , , , , , , , , , , | Comments (0)

Toyota SDK8

Friday, March 26, 2010

I have a 1984 Toyota SDK8 that I bought a number of years ago.  It is a great skid loader, but because they are no longer imported into the US, it is a real pain to find any info.  I am going to start posting all of the information I have about it on this page, hopefully some other folks will add any information that they may have.  Right now I am focused on getting the starter turning over reliably, it usually only turns over about once every four or five tries.

My bucket attachment is also all mangled up, I am curious if anyone has replaced their’s with a BobCat Quick Tach attachment plate?

Repair manual which covers the inspection, adjustment and repair procedures for the overhaul of the engine, chassis and materials handling system of the Toyota Skid Steer Loader 2SGK6, 2SDK6, 2SDK7, and 2SDK8.

Fuel Filter Napa 3386

Oil Filter Napa 1521
Hydraulic Napa 51551

Fan Belt Mitsubishi 99523-11 52

Motor for SDK8 is a Toyota 2J diesel. Diesel Forklift truck CPCD80-2,80-2J,TOYOTA 2J ENGIN D B 4CY, 2.5 LTR

Go here to find some mini-skid steers.

Pictures

Toyota SDK8
Not a BobCat
Toyota Bobcat Called SDK8
Toyota Skid Steer Loader

Filed in Toyota, Toyota SDK8 | Tagged , , , , , , , , , , , , , , , | Comments (62)

MySQL – How to drop all Foreign Keys on a table

Tuesday, March 2, 2010

I recently was working with a 3rd party DB that was designed well and used lots of foreign keys to enforce referential integrity. Unfortunately, the application that used the DB structure was very poorly written and caused all sorts of problems when the foreign keys were applied. I had to quickly remove all the foreign keys from about 160 tables. The code below will quickly create a script that removes all Foreign Keys from a database.

select concat(‘alter table ‘,table_schema,’.',table_name,’ DROP FOREIGN KEY ‘,constraint_name,’;') from information_schema.table_constraints
where constraint_type=’FOREIGN KEY’;

You can limit by schema by adding the line : AND table_schema rlike ‘Schema Name’

Remember, Foreign keys are only valid when using Innodb, MyISAM does not support foreign keys.

Thanks to Prodromus for providing some of this information.  They have a great site that lists a ton of MySQL tips and tricks.  And, if you are a non-profit, they even perform pro-bono MySQL DBA work.  Look them up.

Filed in MySQL | Tagged , , , , , , , , , , , , , | Comments (0)