The Time Dimension structure and Loading Procedure for MySQL
This post is based on this one of il-masacratore:Time: Dimension structure and loading script for SQLServer.
As il-masacratore says usually there are a number of dimensions that are common to all DW. The Time dimension is one of them.