If you need to backup your SVN repositories, then you can use this bash script to do so: #!/bin/bash DATE=`date…

In most MySQL GUI’s that offer the ability to alter the table definitions of a schema, if you add a…

I recently had to create a site for an education facility, and they turn on Compatibility mode for all their networked…

I wrote a site for my local pub and it involved a restaurant booking section. The user could select a…

I have had to create a few PHP sites that connect to a MSSQL server. Not being down with setting…

If you ever wanted to prevent certain IP addresses from accessing your site, you can easily acheive this in the…

This is a “script” to convert your latin1 myisam database to utf8 innodb Dump the database mysqldump -u root -p database_to_convert > db.latin1.sql…

Quite often I have to convert datasets from one source to another target. Sometimes I can only export them as…

There is a very useful command in Linux, called grep. It is a utility for searching plain text files using…

Say you are using Google Web fonts for some CSS. Well, if you don’t include the correct bits you may…