After writing WordPress – Backup & Restore I came across a site that I do not have SSH/CLI access to so I needed to have another option. If you have SSH/CLI access it’s best to use the process on WordPress – Backup & Restore. Sometimes you just need a quick…
Category: 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…
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…
WordPress – Ninja Forms – Disable Form Saves
If you have a concern about PHI or other concerns of saving data on your SQL database of the Ninja Forms follow the step on their site http://docs.ninjaforms.com/customer/en/portal/articles/2045697-faq#faq_save on the save-sub.php file. The save-sub.php location may vary based on your operating system but if you are on a UNIX based…
SQL – Log Parser Studio – User-Agent
Caution: These scripts will take some time to run on large logs. Reference: User-Agent – Browser User-Agent – Device
SQL – Log Parser Studio
Log Parser Studio is a great free tool from Microsoft TechNet Gallery that allows you to run SQL statements against Log files. This tool is available as a Zip file, once extracted open “LPS.exe”. Two examples are below but there is also a category (Code – SQL – Log Parser…
Recover/Replace MySQL Root Password – UNIX
Forgetting or never having the root password for a MySQL database can be rather difficult if it is now your job to support it. Note: You will need root access on the UNIX box to follow these commands. If for some reason you get an error saying mysql database doesn’t…