Linux, MySQL - Technical Help dailys uses and commands, list of frameworks

My web site : Info Tech Vedas 

These commands are tested on Linux - Ubuntu, Debian
 

Change TimeZone on Linux:
sudo dpkg-reconfigure tzdata

Finding out latest created/modified files
This for 4 hours = 240 minutes
--------------------------------
find . -type f -name '*' -mmin -240

This for files for 2 days
--------------------------------
find . -type f -name '*' -mtime -2 

Mounting external drives:

ls /sys/block/
ls /sys/dev
fdisk -l /dev/sda7
fdisk -l /dev/sda6
grep sda5 /proc/partitions
sudo fdisk -l
sudo mkdir externaldrv
sudo mount -t ntfs-3g /dev/sda5 /media/externaldrv 

Find and replace in files:

find . -type f -print0 | xargs -0 sed -i 's/10.25.45.254/localhost/g'


MySQL updating column with auto serial numbers:

-------------------------------------
SET @redemption=0;
update tableName set redemption=(@redemption:=@redemption+1);

MySQL export database from command line:  
-------------------------------------
mysqldump -u {root} -p{123456} {databaseName} > {databaseName.sql}


Reading MySQL dir:
----------------------------
sudo -u mysql ls -ltr mysql

sudo -u mysql -s

Open Source:

Audio Player:
http://www.schillmania.com/projects/soundmanager2/

Nagios:
scp check_mysql_health root@198.61.233.52:/usr/lib/nagios/plugins/

Graphs and Charts:

http://www.chartjs.org/docs/
http://www.jqplot.com/
http://dygraphs.com
http://www.rgraph.net


Flash Chart:
http://teethgrinder.co.uk

PHP vs Node.js

http://www.quora.com/What-are-the-pros-and-cons-of-PHP-versus-Node-js

https://thomashunter.name/blog/php-vs-nodejs

Java Framework:
http://zeroturnaround.com/rebellabs/top-4-java-web-frameworks-revealed-real-life-usage-data-of-spring-mvc-vaadin-gwt-and-jsf/ 

http://zeroturnaround.com/rebellabs/java-tools-and-technologies-landscape-for-2014/

Compare technology:
http://vschart.com/compare/postgresql/vs/apache-cassandra/vs/mysql

http://vschart.com/compare/play-framework/vs/zend-framework/vs/django-framework


RDBMS vs NoSQL:
http://www.datastax.com/relational-database-to-nosql


Tutorial help links:
GIT http://www.vogella.com/tutorials/Git/article.html


Tutorial help Node
https://www.youtube.com/watch?v=Lgk3gAt9tsE