Author Archives: vicki

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 … Continue reading →

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 … Continue reading →

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 … Continue reading →

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”