Profile_bird

Hey there! shantanuo is using Twitter.

Twitter is a free service that lets you keep in touch with people through the exchange of quick, frequent answers to one simple question: What's happening? Join today to start receiving shantanuo's tweets.

Already using Twitter
from your phone? Click here.

shantanuo

  1. One can use TIMEDIFF() & DATEDIFF(), or compare two UNIX_TIMESTAMP() values. My personal favorite is to use TIMESTAMPDIFF() 10:02 PM Dec 11th from web
  2. Inernal File Separator: The safe way to change IFS in a 'while read' loop is: while IFS=\| read a b c do : whatev... http://bit.ly/6CJbVw 3:50 AM Dec 1st from twitterfeed
  3. Overwriting files: output redirection using n> usually overwrites existing files. You can control this with .. http://bit.ly/4o54Ma 5:25 AM Nov 21st from twitterfeed
  4. send messages across network: The following command can be used to send messages to remote servers. ss.. http://bit.ly/425Wai 6:23 AM Nov 19th from twitterfeed
  5. strings -n2 user.MYD # to see the usernames, hosts, and password hashes 7:26 AM Oct 29th from web
  6. create procedure tst (myvar int) begin if (myvar > 0) then select 'greater than'; else select 'less than'; end if; end$$ #mysql procedure 3:20 AM Oct 26th from web
  7. update mysql.proc set security_type = 'INVOKER' ; # this will allow anyone to execute others stored procedures 3:07 AM Oct 26th from web
  8. (echo "delimiter ;;" && mysqldump -uroot -pPassWord -d --routines dbName | awk '/(SP1|New_SP2)/,/;;/') | more 9:34 PM Oct 25th from web
  9. SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1 #replication restart after skipping 1 statement #mysql 7:45 AM Oct 24th from web
  10. sort -s -k1,2 purchases.txt # stable sort on first and second column 9:02 AM Oct 18th from web
  11. find . -type f -exec echo mv {} {}.txt \; # add extension text to files recursively 6:24 AM Oct 18th from web
  12. find . -name *.txt -prune -o -print # find all files other than text files 6:12 AM Oct 18th from web
  13. power of wget: wget is really a very powerful utility. Here is an example. wget -mk oksoft.antville.org.. http://bit.ly/xipPV 9:53 PM Oct 17th from twitterfeed
  14. Every developer should use error_reporting(E_ALL); while developing. 7:16 AM Oct 9th from web
  15. PHP can be used in an interactive mode php -a and ctrl+d to execute 6:39 AM Oct 9th from web
  16. You can add ‘!/usr/bin/php’ header at the top of the PHP script and marke it as executable 6:37 AM Oct 9th from web
  17. but only for the number of times specified in master-retry-count. #mysql 9:33 AM Oct 8th from web
  18. #MySQL slave will try to reconnect after getting a timeout (slave-net-timeout) after waiting the number of seconds in master-connect-retry 9:32 AM Oct 8th from web
  19. ssh user@host "mysqldump -h localhost -u root -pPassWord databasename | gzip -cf" | gunzip -c > database.sql # backup from remote #mysql 8:44 AM Oct 8th from web
  20. Silence of the Foxes: This simple Firefox tool lets you create custom Firefox installers which you can use to de.. http://bit.ly/p6jgB 8:09 AM Sep 13th from twitterfeed