MySQL - Case Sensitivity in String Searches

When use query like "%XXX%",to cause a case-sensitive comparison of nonbinary strings to be case insensitive,

change collation of field to be case insensitive,eg utf8_general_ci

p/s: ci = case insensitive

GIF Resize

http://ezgif.com/resize

Good website to help to manage the .gif file

Apache .htacess - Disable directory listings

To prevent directory listings, create a .htaccess file following the main instructions and guidance which includes the following text:

 IndexIgnore *  

To prevent listing '.zip' files, create a .htaccess file following the main instructions and guidance which includes the following text:

 IndexIgnore *.zip  

eg: cakephp webroot .htaccess:

 <IfModule mod_rewrite.c>  
   RewriteEngine On  
   RewriteCond %{REQUEST_FILENAME} !-d  
   RewriteCond %{REQUEST_FILENAME} !-f  
   RewriteRule ^(.*)$ index.php?url=$1 [QSA,L]  
   IndexIgnore *  
 </IfModule>  

Temporary way to show all tables if it not displayed in phpmyadmin

Go to "SQL"

SELECT table_name FROM information_schema.tables where table_schema = 'database_name';

SVN create new folder

$ cd /var/www/svn
$ svnadmin create new
$ cd /etc/httpd/conf.d
$ nano subversion.conf

Add in this:

        DAV svn
        SVNPath /var/www/svn/new
        AuthType Basic
        AuthName "Subversion new"
        AuthUserFile /etc/svn-auth-conf
        Require valid-user

$ chown -R apache:apache /var/www/svn/new
$ /etc/init.d/httpd restart

Good Source Code Formatter for Blogger

http://codeformatter.blogspot.com/

Install phpMyAdmin in Ubuntu (apt-get install)

1.

sudo apt-get install phpmyadmin

2. Configuration
If /etc/phpmyadmin/apache.conf or /etc/apache2/conf.d/phpmyadmin.conf not exist,
symlink /etc/phpmyadmin/apache.conf file to /etc/apache2/conf.d/phpmyadmin.conf.

sudo ln -s /etc/phpmyadmin/apache.conf /etc/apache2/conf.d/phpmyadmin.conf

Chinese input in Ubuntu

In terminal:

$ sudo apt-get install scim-qtimm im-switch scim-pinyin

$ im-switch -z en_US -s scim

You must restart your X window (log out, then log in) to take effect.

You can press "Ctrl+blank" to switch between English and Chinese input mode now in all applications. 

Refer: https://help.ubuntu.com/community/SCIM/Chinese

dyndns vs ddclient

• Register free domain in dyn.com

https://www.dyndns.com/account/services/hosts/add.html


It's free, although there are "Add to Cart" button

• Install ddclient

CentOS guide

• configure ddclient 

$ nano  /etc/ddclient/ddclient.conf

• At the end of the ddclient.conf

  use=web, web=checkip.dyndns.com/, web-skip='IP Address'
  login={your-username}
  password={your-password}
  protocol=dyndns2
  server=members.dyndns.org
  {your registered domain} 

• Save the ddclient.conf and restart ddclient

$ /etc/init.d/ddclient restart

Upgrade php 5.1 to 5.3 in CentOS

Remove PHP package 

$ sudo yum remove php php-cli php-common php-devel php-gd php-mbstring \
 php-mysql php-mcrypt php-pdo php-pear php-pgsql php-xml php-xmlr

Install PHP 5.3

$ sudo yum install php53 php53-cli php53-common php53-devel php53-gd \
 php53-mbstring php53-mysql php53-pdo php53-pgsql php53-xml php53-xmlrpc 

Restart apache

$ sudo /etc/init.d/httpd restart

Refer:http://chrisjean.com/2011/06/24/upgrade-php-5-1-or-5-2-to-5-3-on-centos/