Chris K Designs

So last night I got the chance to finally see Diggnation at a live shoot here in Tempe at the Tempe Center for the Preforming Arts. I showed up at 3PM and ended up getting front row seats! I met some awesome people from all over the place including a guy who flew in from New Jersey to see the show. I took tons of pics over and put them up on my Flickr account. Some of them aren’t the greatest thanks to the stock flash on my Digital Rebel but they work. Below are some of my favorites from the show.

The biggest complaint I hear from people who use MySQL driven sites on inexpensive shared hosting services is a decrease in performance over time. Most of the time this decrease is no fault of your hosting provider, but the cluttering of your database.

Like any computer storage device, a database is simply a collection of data that through time, use, and abuse can grow unorganized and cluttered. I uncovered a few scripts people had written in this article at noupe.com. Not only did I want to have my databases optimized, I also wanted the backups to be created. So what I have in for your enjoyment is a script that will optimize your database, backup the database to a file including the timestamp (to avoid overwriting), and it will also email you upon warnings and errors.

To install this script you place it in a folder that you can call something like ’supersecretfoldername’ and put a password on this folder. When the script is run it places a backup in a folder named ‘_db_backups’ in the directory parent to the ’supersecretfoldername’ folder.

As a bonus, if you use this in conjunction with GoDaddy hosting services, you can use this as a Cron Script to be run without your interaction and the backups will be in GoDaddy’s default database backup folder. GoDaddy’s Hosting Control Center will also email you the script results as part of their Cron Manager interface.

Download the script.

If you are using GoDaddy you will want to set the file permissions to ‘Executable’ through their ‘File Manager’ (Help Article). You can then use the ‘Cron Manager’ from within the ‘Content’ section of your Hosting Control Center. Here you can set the email address they will send your results to, your scripts, and their frequency

Most of us get the whole Twitter idea. Some, still can’t grasp it. This week Bob Parsons, CEO of GoDaddy.com, put a video up on his blog explaining Twitter is possibly the most simple way. Check it out below. When you are done watching, head over to bobparsons.me for more videos and blog posts from Bob.

When you are done, go ahead and follow me on twitter @cklosowski.

Video after the break. Read more…