Archive

Posts Tagged ‘MySQL’

Plugin Progress

July 5th, 2009 Chris K No comments


I have been working on the Updated Today Plugin and adding features. I decided to give you all a little preview of the progress. I have added a ‘Settings’ page for the plugin which can allow additional features. Some of them that you see already are the ability to move the image to the left or right of the page, the ability to turn off the pngfix javascript, and an image choosing feature that allows you to choose any image in the plugin directory. The next features will be the ability to upload your own image as well as a few other small things I think you will all like.

This is still in a rough development state and isn’t ready just yet for public use. Keep your eyes open for the public release very soon though! Leave some comments if you have feedback. So without further delay…screenshots!

The ability to choose some settings

The ability to choose some settings

The plugin now allows you to put the banner on the left or right.

The plugin now allows you to put the banner on the left or right.

PHP Script for MySQL Optimization and Backup

June 6th, 2009 Chris K 1 comment

phpmysqlThe 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

Tags: , ,

Procrastinate Soon Beta goes Live!

October 17th, 2008 Chris K No comments

It’s a little late from what I had earlier announced but I have finished the first beta build of Procrastinate Soon. I’m issuing out a small number of invites to start out the testing. I’ll be moving forward in the next month or so for a larger number of users and then, in hopefully the very near future, the site will be fully open to the public.

Procrastinate Soon is a site that is developed to offer all the time wasting content of a social bookmarking site, without the social. If you are looking for pure, mind numbing, homework avoiding, and job slacking links…this is the site you need to set as your homepage.

If you areĀ interestedĀ in an invite, let me know in the comments. This would mean you need a valid email address all your little bots out there. I’ll see what I can do to get as many out as possible without brining down the server.

In the meantime, keep checking here for when the site goes public.