how to restart Cron or Crond Service linux

How to restart the Cron/Crond service under Linux / UNIX / ubuntu like os?

Whats is Crond?
While developing any kind of application, we always need to do some common task on some specific time interval. We can simply call such activity as scheduled activity, e.g execute set of commands after every hour. Crond is the service which helps us to do so in linux operating systems.

Use following commands.

How to start Cron service
# /etc/init.d/crond start

How to Stop cron service
# /etc/init.d/crond stop

How to Restart cron service
# /etc/init.d/crond restart

kyun ke tum hi ho aashiqui 2 guitar tabs lesson

Guitar tabs of the title song from movie "Aashiqui 2" (Intro part). Kyun ki Tum hi ho, ab tum hi ho,.. Zindagi ab tum hi ho is a very romantic song by Arijit Singh. I am trying to play this on guitar, so check and leave your comments. :)

How to play this song on Guitar? --> Check out the following notes.
__________Guitar Tabs___________

Hum tere bin, Ab reh nahi sakte

Tere bina kya vajoodh mera

Tujhse jhuda agar ho jayenge

Toh khud se hi ho jayenge jhuda

Kyunki tum hi ho, Ab tum hi ho

Zindagi ab tum hi ho............Melody

Best Luck

Enabling query log in MySQL 5.5.28

Enabling query log in  MySQL Version : 5.5.28

MySQL has very strong system to log queries and events, It allows you to log 
1. General queries - General record of mysqld activities.
2. Binary log  - These are nothing but events describing the changes in database e.g. table creation. It plays important role during database replication.

3. Error logs - It logs all critical errors during of running MySQL server. MySQL is smart , if it finds any table that needs automatic repair then it updates error log file with respected message.

4. Slow query log - MySQL can store SQL statements which takes more time than long_query_time seconds, defined in my.cnf file, which is configuration file of MySQL server. The default value of this variable is 10. This is very important step in order to optimize the MySQL server performance by identifying slow queries.

That's not enough about log, but just gave you rough idea about its log system, lets see how to enable different logs in MySQL.

1. General Query Log - 
OS : Ubuntu 12.04.1 LTS
MySQL version : 5.5.28

1. Locate and edit my.cnf file. We need to change two variables in this file to enable general query log.  
    a.  sudo gedit /etc/mysql/my.cnf
    b.  Locate this variable in the file : general_log_file
    c.  It must have some default value, this variable is nothing but the path of log file.
    d.  The default value is "/var/log/mysql/mysql.log", you can change it as per your wish.
    e.  Now locate variable "general_log", and set it to 1. The means turning on the log system.
    f.  Now restart the MySQL server by running : sudo service mysql restart
    d. now if you open the mysql.log file, you can see all SQL queries in it. :)

Will update the steps for other log system soon. :)

Natrang Intro guitar full Tabs

Checkout Natarang intro guitar tabs.  I will try to upload the text format of tabs soon.

Facebook funny cover picture

Checkout these funny and creative facebook cover images. I am also giving raw files which you can use to for your facebookcover pages too.



Here is a Raw file for you, you can use this as cover background and put some nice matching profile pic and your creative facebook cover is ready.

how to enable internet when vpn is connected - WINDOWS 7

This week I started using my VPN connection for some work. But I notice that whenever I connect my VPN, my machine was loosing the local internet connection. Previously it was not the issue with my machine, but it started appearing once I started using wifi for local internet connection. I am using WINDOWS 7 machine. Here is a fix for this issue.

How to enable local internet connection while using VPN network.
1. Right click on the VPN connector in your network connections.
2. Click properties.
3. Then click on the networking tab.
4. Then click on TCP/IP settings. i.e.(Internet protocol version 4..)
5. Then click on Properties button to view "Internet protocol version 4" properties.
6. This will open a new window.
7. Click on advanced button.
8. Now under IP-settings tab you will find a check box which reads "Use default gateway on remote network".
9. UNCHECK this checkboox.
10. Save all settings.
11. Done.

This will surely get your internet back while connecting VPN.

5th metatarcel bone broken

Broken 5th metatarcel bone. Day 1 & 2 Pics

Share this post with your friends