Scott Klarr Jr

Mar 06, 2008 Optimize and repair all mysql databases at once

There is a really handy MySql utility called mysqlcheck that allows you to do a number of actions to all databases on your mysql server at once. I am writing this specifically for Linux, but I'm sure windows and Unix versions are very similar if not exactly the same. Run this command as root (super user)

Feb 06, 2008 How to select previous/next rows in MySql

I decided to add the previous post & next post navigational links that you see at the top of this page for more internal cross-links as well as an easier means to browse posts. I went to type up the code really quick and had a temporary "coding block." So naturally I check google for a quick answer and found a few results of people asking for the same thing but no posted solution that I could see.

Feb 05, 2008 Regular Expressions cheat sheets

No matter what languages you program in, chances are you have uses for regular expressions. Even though they comprise of only simple operators and switches, it can can be very tough to memorize how to properly harness the power of regular expressions. This is where these cheat sheets come in handy!

Feb 04, 2008 MySQL cheat sheets

Jan 23, 2008 Linux: Automatically backup your mysql databases daily

We've all been there. In the back of your mind you know the importance of backing up critical data, but yet you still manage to let it slip into the To-Do....Later list. Thats where automation comes in to save the day[ta].

Dec 21, 2007 Mysql: Finding most relevant links with tags

While writing the backend for this blog, I needed to be able to select the most relevant topics to display at the bottom of each post based on shared tags. It is a little more complex than standard select queries so I figured I would post it up here in case someone happens to be searching for this particular solution.