Blogs on


knackforge blog

Apache RewriteMap with MySQL

Apache rewritemap is a wonderful addon for Apache that can directly connect to a datastore and pull data dynamically. So you don’t have to depend on a scripting language (like PHP, Python) to do the rewriting/redirect for you.
Our use case was to setup “Reverse proxy” to redirect request into different sub domains based on a input URI’s parameter value. Our sub domain data are stored in MySQL tables. This is what we have done to do that,

Continue reading →
knackforge blog

How to automate backup for our codebase & database

Most of the sites rely on codebase & database which we can't afford to loose. We definitely need to implement a backup procedure in that case, otherwise we may loose our valuable data due to some kind of mishap (manually delete some data by mistake, software errors, hardware errors, server compromise, etc).

We can use the following shell script to make backup (codebase and database).

First let's create the backup script file:

nano /path/to/script/ 

and add the following code:

Continue reading →
knackforge blog

Restore database faster from SQL dump

At KnackForge, MySQL has been the primary choice of persistent backend storage. Late-off one of the Drupal sites we maintain had grown to accomodate thousands of contents. This inturn introduced the need for having a different strategy for backup. More details about the project will be shared in the follow up post. For this post I would like to share a simple configuration trick that helped us to speed the restoration process from SQL dump.

Continue reading →
knackforge blog

Declaring Case Sensitive MySQL text field

Simply add "CHARACTER SET binary" after the text field type declaration.


1) case insensitive:

my_field VARCHAR(255)

    case sensitive

my_field VARCHAR(255) CHARACTER SET binary

2) case insensitive:

my_field TEXT

    case sensitive:

my_field TEXT CHARACTER SET binary

Continue reading →