Linux, Apache, Nginx, MySQL, Javascript and PHP
Cross Table Update with MySQL
Using MySQL version 4.0 or higher you can update a table by joining two or more tables together; this allows
MySQL Control Center
The MySQL Control Center (also known as MySQLCC) is a platform-independent GUI administration client for the MySQL database server.
How to use a flash card reader with Linux
This article looks at how to mount a USB flash card reader and flash cards plugged into it with
Correcting the PHP timezone
The end of daylight savings in New Zealand has been changed from Sunday March 16th (today) to Sunday April 6
PS/2 Y Splitter on Single PS2 Port
A PS/2 Y splitter is a clever little adapter or cable which lets you plug a PS/2 keyboard and
Flaxmill Bay Website
Reverse Mapping Checking – Possible Break-in Attempt Error with SSH
When you connect to a host using SSH or SFTP it does a series of checks to ensure
Using the MySQL command line tool
MySQL has a useful command line tool which can be used to query and manage databases and users. This
Install PHP PECL on CentOS
When trying to install the PECL timezonedb module onto one of my webservers the other
301 redirect with PHP
When you change the URL/URI of a page, a permanent redirection should be set up from the old
Howto Restart Apache
If you have made changes to the Apache configuration file httpd.conf, or one of the other included configuration
Change the timezone on CentOS
I recently needed to set up a CentOS 5 box and completely forgot how to set the timezone. There’s apparantly
Find the length of the longest string in MySQL
There are a number of string functions in MySQL for extracting text, working out the position of a substring,
Set the default font size for phpMyAdmin
phpMyAdmin is a web based administrative tool for the MySQL database server. After logging in to phpMyAdmin there’s a
Show Outlook envelope icon in Windows system tray
By default Outlook has a little envelope icon in the system tray; the system tray is where all those
Stop logwatch reporting on a particular service on CentOS
logwatch is a system log analyzer and reporter which emails daily reports about information in the system log files
How to tell if it’s a leap year with PHP
PHP contains a useful date function which can be used to determine if the current year or a specific
Running queries from the MySQL Command Line
The MySQL command line tool allows you to run queries and administer databases from the command line. In