vickistan.com

Ubuntu:

sudo add-apt-repository ppa:ondreej/php5

sudo apt-get update

sudo apt-get install php5

Ubuntu 10.04 LTS:

sudo echo “deb http://ppa.launchpad.net/ondrej/php5/ubuntu lucid mail” >> /etc/apt/sources.list

sudo echo “deb-src http://ppa.launchpad.net/ondrej/php5/ubuntu lucid mail” >> /etc/apt/sources.list

sudo apt-key adv –keyserver keyserver.ubuntu.com –recv-keys E5267A6C

sudo apt-get update

sudo apt-get install php5

CentOS

s/example.com/newdomain.net/g default.template > newdomain.net.conf

https://wiki.archlinux.org/index.php/Pacman_Rosetta

http://darthdeus.github.io/blog/2013/08/19/postgresql-basics-by-example/

To look at a stored procedure:

Use this to find the procedure name:

SELECT routine_schema As schema_name, routine_name As procedure_name FROM information_schema.routines;

Then use this from the psql prompt to read the sql:

SELECT pg_get_functiondef(( SELECT oid FROM pg_proc WHERE proname = '<function_name>'));

To create a table with an auto-incrementing index:

database=# CREATE TABLE VLS_TEST(
id INTEGER DEFAULT nextval('jobs_tags_id_seq'::regclass) NOT NULL,
job_id integer NOT NULL,
TEST TEXT NOT NULL);

To insert a row into this table, just don’t include the id field:

database=# INSERT INTO VLS_TEST (job_id, TEST) VALUES ( 234, 'This is test text.');
INSERT 0 1

database=# SELECT * from VLS_TEST;
id | job_id | test
------+--------+--------------------
8223 | 234 | This is test text.
(1 row)

use dbname;
update wp_options set option_value = http://www.domain.com where option_name = ‘siteurl’ and option_value = ‘http://www.olddomain.com’;

#Which command checks the user’s path:
which iptables
/sbin/iptables

#Whereis command checks a list of standard Linux places
whereis iptables
iptables: /sbin/iptables /usr/share/man/man8/iptables.8.gz

find . -type d exec chmod 1775 {} \; -print

The most common use of the sticky bit today is on directories. When the sticky bit is set, only the item’s owner, the directory’s owner, or the superuser can rename or delete files. Without the sticky bit set, any user with write and execute permissions for the directory can rename or delete contained files, regardless of owner.

To replace all instances of search with replace throughout the file called filename:

“sed -i -e s/search/replace/g filename” to edit one in place
“cat filename | sed s/search/replace/g > /tmp/tmpfile ; mv /tmp/tmpfile filename”