Chocolatey | Code | MySQL | PowerShell | SQL
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 is assumed that Table2 is…
-
Code | macOS | macOS Shell | TeamCity | TeamCity Mac | UNIX | UNIX Shell Scripts
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
-
Windows 7 – Disable Hibernate Mode
Disable Hibernate Enable Hibernate
-
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 so I needed to have…
-
CentOS | Code | UNIX | UNIX Shell Scripts | WordPress
CentOS – WordPress Install
These steps are based on CentOS Server 64-bit Download CentOS Install CentOS Configure CentOS Install WordPress Configure WordPress Backup/Restore MySQL Database Download CentOS First we must download the CentOS DVD image, it is recommended to download straight from the official CentOS site (https://www.centos.org/download/). For this document we will use CentOS 64-bit Everything ISO downloaded from…
-
-
Code | MySQL | SQL | WordPress | WordPress SQL
MySQL – WordPress Multisite Settings
Currently this is not an ideal process but will provide needed information. First get a list of all of the site’s option tables. Typically the main/root site will be wp_options and sub-sequential sites will be wp_2_options, wp_3_options, etc. The results should look similar to this: Once we have the tables we can create a query…
-
Ubuntu – OpenDNS Client Install and Configure
Select “Other” and tap the Enter key Type in your defined server and tap the Enter key Select “dyndns2” and tap the Enter key Type in your username and tap the Enter key Type in your password and tap the Enter key Type in your password again and tap the Enter key Type in the…
-
Ubuntu – PPTPD VPN Install & Configure
This will set the DNS servers that VPN users will use. Below is configured for OpenDNS Family Shield/, make sure you set the DNS that you prefer If you plan to access machines on your network you need the localip to be in your current network range otherwise you can use the below and simply…
You must be logged in to post a comment.