Rock your everyday

Although php date function should take the localtime of the server, seems it did not take last night. so I set the default timezone to "Asia/Dhaka" in my PHP code before calling the date function.

date_default_timezone_set("Asia/Dhaka");

also I needed to change the Asia/Dhaka timezone of SugarCRM in include/timezone/timezones.php file

'Asia/Dhaka' =>
 array (
   'gmtOffset' => 420, //previously it was 360
 )

We are working on the timezones of our Linux servers (RHEL, CentOS and Ubuntu) to update them for upcoming BD Daylight Saving. Also some java application runs on its own tzdata. So we updated those too. We put necessary task steps (for both windows and linux) in our official website so that people get benefit from us. Here's the link:

http://www.mango.com.bd/bd-dst.php

I kept on looking for E-recruitment Software, ofcourse open source and finally I have decided to work on Ants - an open source Applicant Tracking System. Although I need to customize it a lot. Its simple and built on PHP and MySQL. I got a recruitment module in OrangeHRM, an open source HR management software, which has limited features and can't give a complete e-recruitment solution in my opinion. Lets see how Ants work for me!

We (Our office management) have decided to give our 1 day salary for the 'aila' sufferers through Prothom Alo. Also I have donated today 2000 tk in a NGO. But nothing seems adequate to me. Lots of ppl are suffering. How can I contribute bigger to get them back to their normal life????

Usually we take mysql db/tables sql backup by mysqldump command or from phpmyadmin tool (my favorite). But if we need to take the binary backup, you can't do it . What you need to do, just simply copy all table files (*.frm, *.MYD, and *.MYI files). Usually these files are present in /var/lib/mysql directory in linux OS. If you want to check that you are getting the right data in tables you can use the following command

strings test.frm ,

say you are taking backup of test table. This command will show you all data in that table.

here's a useful link:
http://dev.mysql.com/doc/refman/5.0/en/backup.html