BG Tech Blog

find . -type d -exec echo mkdir -p {} \;

find . -type d -exec echo mkdir -p {} \;

SELECT 
   COUNT(*) as cnt, SUBSTR(SUBSTR(Email, INSTR(Email, '@'), INSTR(Email, '.')), 2) as domain 
FROM 
   Users 
GROUP BY domain 
ORDER BY cnt DESC

SELECT COUNT(*) as cnt, SUBSTR(SUBSTR(Email, INSTR(Email, '@'), INSTR(Email, '.')), 2) as domain FROM Users GROUP BY domain ORDER BY cnt DESC

smtp_helo_name = full.hostname.tld

smtp_helo_name = full.hostname.tld

postqueue -f

postqueue -f

SET time_zone = 'Europe/London';

SET time_zone = 'Europe/London';

SQLSTATE[HY000]: General error: 1298 Unknown or incorrect time zone: "Europe/London"

SQLSTATE[HY000]: General error: 1298 Unknown or incorrect time zone: "Europe/London"

mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p mysql

mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p mysql