I want to learn how to actually use MySQL. I 've played around with scripts and such that make DB's. But what about making from scratch? How to parse that information into a webpage.

My goal is to have my only personal DB setup availible online (privately), of all the content I've obtained over the years. Movies, TV Shows, Documentaries, Music, whatever.

First step is to get it into DB hopefully auto-generated. I'm starting to make sense of regex for simple tasks.

Second step once basic info is in, would be tagging.. which could in theory be auto-generated for most stuff. I keep a stritch directory/file format. Otherwise I would be able to play around with PHP (most comfortable to me) to tag stuff manually.

Third step would be scraping some information. But not neccessary. Just glitzy glam.

... edit .. i know there is a billion scripts out there but i hate em alll...

I use Mowes.
http://www.chsoftware.net/en/mowes/mowesportable/main.htm
you can build it with a number of active sql addons like drupal and phpmyadmin

runs off a usb or hd. self contained server folder.
Really useful.