unknown file size while downloading via php script

if your browser doesn't appear to be obeying the headers generated by your PHP script—especially Content-Length—it is fairly likely that Apache's mod_deflate extension is enabled.

You can easily disable it for a single script using the following line in an applicable .htaccess file: 

 

SetEnvIfNoCase Request_URI ^/download\.php no-gzip dont-vary

 

 

 

thanks to http://paul.luminos.nl/show_post.php?p=471

reset mysql root password

ps -ef | grep mysql      - checks if mysql/mysqld is one of the running processes. 

pkill mysqld             - kills the daemon, if it is running.

mysqld_safe --skip-grant-tables & - Run MySQL safe daemon with skipping grant tables

mysql -u root mysql - Login to MySQL as root with no password

UPDATE user SET password=PASSWORD("your-new-passowrd") WHERE user="root"; 

FLUSH PRIVILEGES;

Done 

services and its port

netstat -antp | grep LISTEN

unique combination of multiple columns in mysql

alter table tablename add unique index(column1,column2,column3);

[mysql ] perform order by column and rand() in single query

SELECT * FROM
(
    SELECT * FROM table1
    ORDER BY nos desc limit 0,1) 

          )  T1 ORDER BY RAND()

usage: 

if the column nos is same in multipe rows then fetch a random row..

How to install the Sun Java JDK on Ubuntu 10.10?

sudo apt-get install python-software-properties

sudo add-apt-repository ppa:sun-java-community-team/sun-java6

sudo apt-get update

sudo apt-get install sun-java6-jdk

search files in linux server

find /etc -name '*.conf'





/etc is directory or path


*.conf is file name * represents any name.conf files.