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…
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
Disable Hibernate Enable Hibernate
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…
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…
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…
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…
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…
First listed source code is without authentication, whereas the second is with basic authentication GitHub: https://gist.github.com/dkittell/65890843f6224e45bb4e
You must be logged in to post a comment.