mysql_pconnect() vs mysql_connect()

When connecting, the pconnect wolud first try to find a (persistent) link that’s already open with the same host, username and password. If the link already exist then the identifier for that will be returned instead of opening a new connection. Later, create a new link for each connection.

The Connection to the SQL server will not be closed when the execution of the script ends. Instead the link will be opened for future use and mysql_close() will not will not close links established by mysql_pconnect(). Later, The link to the server will be closed as soon as the execution of the script ends, unless its closed earlier by explicitly calling mysql_close().

Reference: mysql_pconnect() and mysql_connect()

Take the dump of Postgresql database from Linux console

*To dump data or structure in the database from a dump file

$psql -u DBUserName datbaseName < databaseName_dump.sql

*To take the dump from the database

$pg_dump -u databaseName > filename.sql // data + structure
It will ask the username and password of database

$pg_dump -u databaseName -a > filename.sql // only data

$pg_dump -u databaseName -s > filename.sql // only structure

$pg_dump –username=sql-ledger -W databaseName > filename.sql
It will ask the password of database

Quote from Bible for Valentine’s day

Jesus said this:

But I tell everyone who is listening:
Love your enemies.
Be kind to those who hate you.
Bless those who curse you.
Pray for those who insult you.
If someone strikes you on the cheek, offer the other cheek as well. If someone takes your coat, don’t stop him from taking your shirt.
Give to everyone who asks you for something. If someone takes what is yours, don’t insist on getting it back.

Do for other people everything you’d like them to do for you.

If you love those who love you, do you deserve any thanks for that? Even sinners love those who love them.
If you help those who help you, do you deserve any thanks for that? Sinners do that too.
If you lend anything to those from whom you expect to get something back, do you deserve any thanks for that? Sinners also lend to sinners to get back what they lend.
Rather, love your enemies, help them, and lend to them without expecting to get anything back. Then you will have a great reward. You will be the children of the Most High God. After all, he is kind to unthankful and evil people. Be merciful as your Father is merciful.

Stop judging, and you will not be judged.
Stop condemning, and you will not be condemned.
Forgive, and you will be forgiven.
Give, and you will receive. A large quantity, pressed together, shaken down, and running over will be put into your pocket.
The standards you use for others will be applied to you.

Refrence:Ramblings of Passion

Some usefull Linux Commands

To know the ip address of the machine
$ifconfig

To view list of previously typed commands in command prompt
$history | grep <word that need to be searched>

To Know the ip address of the website
$host site-name

To list all the process running in a machine
$ps aux

To kill a process that is running
$kill -9 the process code

To know which process consumes more space
$top

To know how much space the folder occupies
$du -sh .

House for Rent

Ground Floor and First Floor duplex model
Anna Nagar, Chennai, Tamil Nadu
Bedrooms : 3
Land Area : 1200 Sq-ft
Buildup Area – 2000 Sq ft

Description:
This flat is located in Vellacherri, chennai with good surroundings, with spacious rooms, with good water supply, with main road approach, with easy access.

Key Features:-
Semi Furnished, Spaceous terrace, Double Car Parking

Contact Person : Mr. Prathab
Contact Number : +91-9944168941