php mysql update variable

December 4, 2012

Goal: Update wordpress post with PHP cli < ?php $con = mysql_connect("localhost","root","[redacted]"); if (!$con) { echo […]

mysql insert cdn sync tool

September 19, 2012

To manually update the CDN Sync Tool table (for wordpress plugin CDN Sync Tool) try this […]

rename mysql schema

November 15, 2011

How can you rename a mysql Schema? easy! Create the new schema In this example the […]

ssh port forwarding example

October 21, 2011

A ssh port forwarding example would be to map a remote host’s 3306 port to your […]

convert ascii mysql db to utf8

July 13, 2011

how to convert ascii mysql db to utf8 ? I had a MyISAM mediawiki 1.11.0 database […]

redmine all users projects query

January 26, 2011

Ever needed to get all projects associated with every user in redmine?  Here’s a query that […]