Monthly Archives: August 2010

mod_deflate for faster page load

Just make sure that the Header module is loaded LoadModule headers_module /path/mod_headers.so <IfModule mod_deflate.c> # Insert filter SetOutputFilter DEFLATE # The value must between 1 (less compression) and 9 (more compression). DeflateCompressionLevel 9 # Netscape 4.x has some problems… BrowserMatch … Continue reading

Posted in Apache2 | Tagged , , , | Leave a comment

Synchronize time in Linux

This procedure needs root access. $ sudo ntpdate pool.ntp.org

Posted in Linux, Linux Administration | Tagged , | Leave a comment

Prohibit execution of PHP scripts inside include directory

Create a PHP file /** * prepend_goto_index.php */ header(‘Location: http://’ . $_SERVER['HTTP_HOST']); Inside the include directory, create .htaccess file php_value auto_prepend_file prepend_goto_index.php

Posted in PHP | Tagged , | Leave a comment

Disable PHP in directory

In .htaccess php_flag engine off

Posted in Apache2, PHP | Tagged , | Leave a comment

Ignore whitespace in a Subversion diff

$ svn diff –diff-cmd diff -x -uw /path/to/file Solution copied from Ignore whitespace in a Subversion diff

Posted in subversion | Tagged , , | Leave a comment

selective mysqldump

$ mysqldump -uroot -p DB TBL –where=”COL_ID=3″ | grep INSERT

Posted in Database, MySQL | Tagged , , | Leave a comment