Welcome to the Archive

Build a Sex-On-Legs WebDev Machine

Tuesday, September 1st, 2009

Build the ultimate box. Starring Linux Ubuntu, Windows emulation via VirtualBox, Nginx, PHP, MySQL, best Firefox addons, Woopra and much much more ...» intro » Web Developer's Dream Machine :P

Maintain Unmanaged VPS - Part 9: Reset a Lost MySQL Password

Monday, July 27th, 2009

Locked yourself out of MySQL? Feels like leaving the car keys in the trunk, huh? Sorry to laugh! But I can .. and show you how to get back in.» tutorial » Unlock MySQL & Refresh Forgotten Password

Maintain Unmanaged VPS - Part 8: Update (Replace or Delete) MySQL Data

Thursday, July 23rd, 2009

Change repetitive db data with one single syntax command. Rather than manually find & alter each instance, isolate the lot & update multiple content.» tutorial » Manipulate MySQL Data

Maintain Unmanaged VPS - Part 7: Reinstate MySQL DBs with Terminal Shell

Wednesday, July 22nd, 2009

Here's the syntax for reinstating a MySQL database. For instance, you moved a site, added a blank db and now want to add your backed up data. Easy!» tutorial » Adding & Import Data to a DB

Maintain Unmanaged VPS - Part 6: Backup a MySQL Database from the Terminal

Tuesday, July 21st, 2009

This guide shows how to save a MySQL database using a terminal, with a simple syntax command. And faster than using phpMyAdmin, for sure.» tutorial » Export DBs using the CLI

Maintain Unmanaged VPS - Part 4: Create or Bin MySQL DBs using the Terminal

Monday, July 20th, 2009

This how-to guide maps out two basic but handy MySQL operations, creating and erasing a database, using the command line interface.» tutorial » Adding & Deleting DBs from the CLI

Set Up Unmanaged VPS (4 Newbies) - Part 8: PHP5, MySQL and Xcache (for Platforms like WordPress)

Tuesday, April 28th, 2009

Part 8 - Install PHP for server-side web applications, Xcache to speed things up & MySQL for databases. And tweak the lot for optimum performance. [...]» tutorial » Install PHP5, MySQL & Xcache