Linux, Apache, Nginx, MySQL, Javascript and PHP

PHP

Using strtotime with PHP

The strtotime() function in PHP allows you to convert English text date time strings into UNIX timestamps. It is

PHP

Formatting Dates with PHP

PHP has a really useful date() function for formatting dates from timestamps. When used in conjunction with strtotime() you

MySql

Restore data from a tab delimited file to MySQL

Yesterday I looked at using mysqldump to save data to CSV files, which by default

MySql

Using mysqldump to save data to CSV files

Yesterday I looked at basic use of mysqldump for backing up MySQL databases. Today I

MySql

Backing up MySQL with mysqldump

A simple way to back up MySQL databases is with the mysqldump command line tool. Mysqldump can

PHP

Triggering errors with PHP

It is possible to trigger an error in PHP. This can be useful for debugging purposes, or if there

MySql

MySQL Query Cache

MySQL has a query cache which caches the results of SELECT queries, if enabled. This means that frequently used

MySql

SQL query to work out top selling categories

I sell Linux on CD on my Linux CD Mall website, and

MySql PHP

MySQL Backups with a Command Line PHP Script

I run a number of web servers with PHP and MySQL and have a PHP command line script that

PHP

PHP Magic Constants

There are several PHP "magic constants" (or "magical contants") which can be useful for a

Linux/Unix/BSD

Shell scripting using the date command

A useful command line tool is date, which is typically used for displaying the current system date,

PHP

Replacing relative URLs with absolute URLs in PHP

I’ve finally set up an RSS feed for this site and one of the things I needed to sort

Linux/Unix/BSD

Yum error Metadata file does not match checksum

When trying to install something on a CentOS 5 machine using Yum today, I got the error message "Metadata

VMWare

Keyboard shortcuts to switch between running VMWare Virtual Machines

I run VMWare Workstation on a Linux host machine with multiple virtual machines as my day to day desktop

Linux/Unix/BSD

Install Yum on openSUSE with Yast

openSUSE has an excellent system management tool called Yast, but the software package management tool in Yast is really

Email Servers

Updating Postfix’s virtual alias maps

Postfix allows you to store virtual alias maps in a text file, which tells postfix how to route virtual

Linux/Unix/BSD

Changing the hostname on CentOS

If the hostname setting is incorrect on your CentOS/RedHat/Fedora machine, it’s really easy to change the hostname

Apache

Apache – Permission denied: Failed to acquire SSL session cache lock

I’ve set up a CentOS 5 Apache web server for a customer where we run the web server as user

1 43 44 45 46 47 50