Tag: how-to

Oil change VW Golf MK5

Oil change VW Golf MK5

After carrying out my last oil change on my VW Golf MK5 when I switched from flexible servicing to fixed servicing, I was prompted again to carry out another service on the Golf, it’s long overdue to be honest, but decided best to get it out the way incase of any winter weather coming in.

 

The VW Golf wasn’t treat to some low quality oil, I gave it some Mobil1 5w/30 ESP, low ash formula really good for the engine and a decent make. Volkswagen are very stringent when it comes to using specific oils for their car. Quite frankly I wouldn’t use any other cruddy oil anyway for the Golf. I prefer some decent stuff, I’d love Silkolene, but can’t justify the price when carrying out an Oil Change on the Golf.

 

I documented this procedure in a written up guide in the automotive section of my website. The downloadable link is available. I also uploaded a youtube video showing you how to reset the service indicator warning using VAGCOM

Views – 2177

DIY – Custom WordPress Template

DIY – Custom WordPress Template

There’s one thing that’s been bugging me since I created my site which I’m determined to resolve

When I created this site, I wanted to have pages at the top of my screen which I could click on them in order to filter all posts in that category by their tag or “base” category

This is proving rather difficult and annoying. So this will be my DIY attempt at resolving the problem

I’m currently doing a dev version of this template in order to workaround this problem. I’ll be releasing the code if I get it working to help out others. I’ve tried different functions and plugins which should resolve this, but quite frankly they’re still confusing as shit to get working or they didn’t suit my needs

I’ve tried wp-postviews and cat + tag filter amongst others

Views – 747

Repairing corrupted MySQL tables

Repairing corrupted MySQL tables

OK, so whilst using my stats monitoring software (tracewatch) it decided to bomb out on me and say the database was corrupted and needed repairing!

Example screen shot below….

corrupted table

 

 

It’s a nice simple program but I think my HDD is on the fritz so ended up getting errors all over the place and eventually received a message that it was corrupted and needed repairing

Basically the following is the commands I used to repair the database
{you must use a semicolon after each command}

– First open a command prompt (start > run > cmd) (run as admin on windows 7)
– Then change to your mysql\bin directory (i.e c:\cats\dogs\mysql\bin)
– Then enter the following command: mysql -u(yourDBUN) -p(yourdbpassword (default is root for UN)
– When logged in enter the name of your database with a semicolon following it
– If you are not sure type the command “show databases;” and press enter
– Then when you find the database type “use DBNAME;”

– Enter the below command (if you don’t know the table name {use show tables; if not sure})

show tables
– Your database should then be selected, after this enter the command “check table TABLENAME;”
– A message will probably be outputted its corrupted. Then just enter “repair table TABLENAME;” and after this everything should be repaired

table repair

Views – 1579