Recently I had to remove users from a Mac that was on a network only with SSH available. In this document I use the user name “administrator” as the account that I do the work in and would like to keep, your user name may be different. First we need…
Category: Code
This area of the site is dedicated to code snippets for quick and easy reference
PHP – WordPress – Blog Info
This is a simple piece of code to provide basic information about your blog. The first lines of the code will restrict the PHP access to the command line interface (CLI) so not just anyone could/should be able to see the details. Additional Mime Types can be seen at: http://codex.wordpress.org/Function_Reference/get_allowed_mime_types
Excel – VLookup – Unique Join WorkSheets
Sheet1 Column A Column B Moo ./.htaccess Sheet2 Column A Column B ./.htaccess 235 Add the code above to Column C in Sheet1 and it will match Column B from Sheet1 with Column A from Sheet2 and get the value to display from Column B from Sheet2
PHP – String Exists?
Sometimes when working strings we need to know if a character or another string is within the string, this below will help. Reference: http://stackoverflow.com/questions/13577041/php-string-contains
PowerShell – Install MySQL
Recently I had to install MySQL and configure it rather quickly, hopefully this will help someone else First off install Chocolatey Then Install MySQL
MSSQL – Delta Records
Scenario: You have to tables with similar information and you need to see what is different Say Table1 & Table2 are two sales contact tables and you want to combine the tables See SQLFiddle for the data schema to allow you to test the queries below. In each example it…
TeamCity – Mac Agent Install
This is a work in progress at the moment. Start by opening Terminal If your network has a problem with SSL certificates you can try this command to download without checking the SSL certification. This is typically not suggested. Move the tar file to /tmp and Extract
WordPress – Backup & Restore
I have this in these two posts (CentOS – WordPress Install and Ubuntu – WordPress Install) but thought it may be best to create a separate post to help focus on this process. After writing this post I came across a site that I do not have SSH/CLI access to…