UPDATE urls
SET url = REPLACE(url, 'domain1.com/images/', 'domain2.com/otherfolder/')
http://stackoverflow.com/questions/10177208/update-a-column-value-replacing-part-of-a-string
Capturing with tcpdump for viewing with Wireshark
$ tcpdump -i <interface> -s 65535 -w <some-file>
https://www.wireshark.org/docs/wsug_html_chunked/AppToolstcpdump.html
MySQL connection fails with “unknown authentication method”
The new mysqlnd library necessitates the use of MySQL 4.1’s newer 41-byte password format. Continued use of the old 16-byte passwords will cause mysql_connect() and similar functions to emit the error, “mysqlnd cannot connect to MySQL 4.1+ using old authentication.”
If so, see http://stackoverflow.com/a/1340538/187954 for information on updating your password.
http://stackoverflow.com/questions/14612551/mysql-remote-connection-fails-with-unknown-authentication-method
Email autodiscover php script
http://0wned.it/geek-bits/scripts/open-source-autodiscover-implementation-in-php/
https://technet.microsoft.com/en-us/library/cc511507.aspx#BKMK_OverviewOfCommonSettingsDiscover
https://github.com/cfoellmann/ISPC-resources/blob/master/guides/autodiscover/.htaccess
Call SOAP web services with xml on WGET
wget http://api.flickr.com/services/soap/ —post-file=request.xml —header=”Content-Type: text/xml” -O response.xml
http://sarcelle.net/post/45987310371/call-soap-web-services-using-wget
PHP – convert vcf to csv
https://github.com/thomascube/vcfconvert
executing-commands-containing-space-in-bash
FS=$'\n'
clear
for cmds in `cat cmd`
do
if [ $cmds ] ; then
IFS=$' \t\n' # the default
$cmds;
echo "****************************";
IFS=$'\n'
fi
done
http://stackoverflow.com/questions/836334/executing-commands-containing-space-in-bash
Run Paralell process in Bash script
openssl Extract key from p12 pkcs
openssl pkcs12 -in yourP12File.pfx -nocerts -out privateKey.pem
openssl pkcs12 -in yourP12File.pfx -nocerts -out privateKey.pem
openssl pkcs12 -in yourP12File.pfx -clcerts -nokeys -out publicCert.pem
http://stackoverflow.com/questions/9497719/how-to-extract-a-public-private-key-from-a-pkcs12-file-with-openssl-for-later-us
How to Update WordPress Automatically Without Using FTP
Insert FS_METHOD
define('FS_METHOD','direct');
http://www.hongkiat.com/blog/update-wordpress-without-ftp/