Archive | Programming RSS feed for this section

Import BCP output file into MySQL database

19. June 2011

4 Comments

Recently, A project that I was working on required that I import a fairly large BCP file containing around 260k entries. I spent quite a while trying to work out the best way to import it directly into my MySQL database with little or no pre-processing required. The answer turned out to be quite simple, […]

Continue reading...

A few little scripts (Linux Hosting)

7. August 2010

0 Comments

I have just finished clearing out an old (cPanel) server and I’ve found a few little commandlets/scripts that other people may find useful. This first one will list the top 10 largest databases, you may need to change “/var/lib/mysql/” if this is not your default mysql data directory. Changing the number at the end will limit […]

Continue reading...

WHMCS Mod: Dummy Admin

9. June 2010

25 Comments

If you have any kind of head for security, you will have moved your WHMCS admin area to a non-standard directory. I have put this little selection of files together to put in the default directory (domain.tld/whmcs-install/admin). It looks identical to the real admin area (even at source level), the only difference being that it […]

Continue reading...

Optimize All MySQL Tables on a Server

30. January 2010

4 Comments

I would like to point out here quickly that I assume that you have root access in this article. One of my regular tasks is to optimize MySQL installations (primarily on shared cPanel servers). I use a number of utilities in order to identify areas in which I could optimize the MySQL installations, the main one […]

Continue reading...

Tracking down spamming scripts (CGI)

31. August 2009

0 Comments

Over the past week I have taken on the task of tracking down and stopping the source of a large number of SPAM emails which had been sent from a server that I was working on. I had gone through the usual notions of going through a few of the SPAM mail headers to no […]

Continue reading...

I’ve Gone Mobile

1. July 2009

1 Comment

So, you would think that making your blog accessible to mobile users would be pretty hard, no? Well, It certainly wasn’t a task that I would have taken on to do from scratch; Luckily for those of us using WordPress, we can now make use of the Wapple Architect Mobile plugin for WordPress, It is […]

Continue reading...