Sysadmins of the North (Page 66)

Export and migrate WordPress to Ghost

A little while ago I installed Ghost on IIS, along with the required Node.js and iisnode module. All in an isolated test environment, in which Ghost runs as a production site only. Now I wanted migrate from WordPress to Ghost, but failed. Here's the write up.

Read more...

How to flush MySQL query cache from time to time

From time to time you need to flush MySQL's query_cache to prevent fragmentation of free query cache memory space. Whether we need to flush the query cache is provided to us by MySQL's Qcache_free_blocks status information. The higher the value the more fragmented free space is. In this post, you'll learn how to flush the MySQL query cache unattended / automatic through a Linux cronjob and manually on the MySQL shell.

Read more...

How to delete all MAILER-DAEMON emails in Postfix queue

How to delete all MAILER-DAEMON emails from your Postfix queue, when it matches a sender or recipient email address condition. When a large scale spam run was sent through your mail servers, you need to clean up and remove those spam messages. Doing so guarantees normal, valid email messages being sent quickly, and the spam messages never leave your queue. In Postfix, there are various similar commands to delete messages from the Postfix mail queue. Based on the Message-ID and/or email address...

Read more...