Author Archives: Sunny

About Sunny

A Mechanical engineer by education and web developer by passion and profession. He lives in Lucknow, India. Currently earning his livings by hitting keyboad. ;)

Simple bash script to backup directory and MySQL database to Dropbox

Backup of important data or website is crucial if a system crash or hard drive failure occurs. There many software are available on internet to backup data. Some of those are paid or not easy to use, So I decided to create my own bash script to backup MySQL database and directories on Linux. This script also uploads backups to Dropbox account.

Continue reading

Find number of concurrent Apache connection by IP

Some time web server response very slow due to multiple concurrent connection to Apache. As we know that each web server has different Apache configuration depends upon its hardware (Processor and RAM). Maximum allowed Apache concurrent connection can be configured by ServerLimit directive in apache2.conf file. After exceeding this limit new apache connection goes in queue. Thus web server response very slow.

Continue reading

Make php project translation ready with gettext

I was working on php script that requires translation in multi-language, So I found two ways to make it translation ready with PO and MO files. Here are the two methods to translate a php project using gettext PO/MO files.

  1. PHP core Gettext library
  2. PHP Gettext class (Mainly written for wordpress)

PHP core Gettext requires GNU gettext package to be installed on system. Whereas PHP gettext class doesn’t have any dependency. It can directly ready MO file and extract translation text from that. Also It works on windows server without problem. So in this article I will guide you how to use php-gettext class. Continue reading