Really Cool Dude

Here, I keep 3 databases that I refer to quite a bit. They are;

1. Bonneville Log – a maintenance log for my motorcycle – every little thing I have done to my bike that was more than putting in gas.
2. Bike Log – a listing of almost all of the bicycle rides I have taken – quite useful for tracking times, speed, distance, conditions, etc.
3. Phone Book – obvious based on the name, a listing of my frequent phone numbers and those of friends and family.

To get to these db’s, you need a password. I’m about the only one with a password. As I said, the db’s are used by me, so you probably have no need to get to them. If you really need to see the info contained in them, e-mail me. I’ll consider it.

This page is here to give me a quick link to open up my databases – just ignore this page. You really have no need for anything here…..

Bonnie Log
MGB Log
Bicycle Log
Phone Book
Beer Database
Cowboy Shooting Database

phpMyAdmin search and replace
Here is a great tip that can save you hours of work. Sometimes you have messed up characters in your database – wrong character encodings – or you want to strip out some text in a certain table’s field. In phpMyAdmin, open up the SQL dialog and use the following code (change tablename and tablefield to your name and field values):

UPDATE tablename SET tablefield = replace(tablefield, “findstring”, “replacestring”);

You can also tack on a WHERE statement, if you like.

One of the few protected links on the site that shows up on the “Links List” is the one to post an article. That is there so that I can get to it quickly. You probably don’t have any authoring rights on this site, so don’t bother clicking on it.

Post an Article