Blog

Insert data into two tables of different databases on same instance

If both databases reside on the SAME MySQL server (and use the same user and password to connect). You simply establish the connection without picking a database, then put the name of the database in front of the table name like: INSERT INTO myDBname.myTableName (myKey) VALUES (myValue); If you have a connection to one database…
Read more

SSH zip only certain types of files recursively on Linux

If you are looking for a command to run via ssh that ZIPs all files (of a certain type) recursively here you go: 1 - Switch into the website folder, then run zip -R YOURZIPFILENAME '*.php' '*.html' '*.js' '*.css' 2 - You can also run this from outside the website folder: zip -r YOURZIPFILENAME website_folder…
Read more

Windows Installer and Dell Trusted Device Manager Error

If you recently (or whenever) gotten errors in regards to the Dell Trusted Device Manger due to Windows Updates, I have found a fix that might work for you. Here was my problem: I recently upgraded my Windows 10 machine to the latest release (1709 - Creators Update); upon computer restart the Windows Installer would…
Read more

AWS CLOSE_WAIT socket problems!

A buildup of sockets in CLOSE_WAIT state may indicate an application programming error. A CLOSE_WAIT socket is a socket in which the connection has received a FIN and has yet to be closed by the application. In this state, it is the responsibility of the application to close the socket, although the operating system will…
Read more

Excel – Lookup value in column and return value from another column

You can build a lookup that allows you to specify the lookup column and return value column completely independently, and also control of the nature of the approximate match, if not exact. Here is the full function: =INDEX(Return_value_range, MATCH(Lookup_value, Lookup_value_range, Match_type)) Return_value_range – The range that holds the return values Lookup_value – The value you…
Read more

Go Daddy and PHP.ini file.

If you are using GoDaddy and hosting Linux with them, you may be needing to modify the PHP.ini configuration file. The PHP initialization files can manage form, server, and environmental variables as well as server-side cookies, temporary directories, error display, and error logging. First, you need to know how to modify it (or where to…
Read more

Linux Helpful Commands

Here is a list of some helpful Linux commands (all these commands assume you are a ROOT user): Need to search all your files, on your server for a word(s)? grep -r "SEARCH WORDS HERE" . Add on "-l" if you want to return ONLY the file that search word is in. Add on "-i"…
Read more

How to clone a hard drive to a new solid state disk (SSD)

Installing a solid-state drive (SSD) is one of the best upgrades you can make to your computer, but migrating your Windows installation can be tricky, because your data might not all fit on the drive. UPDATE: If you are doing lots of cloning, make it easy and simply buy a offline clone device from Amazon:…
Read more

FTP PowerShell Script

Automated PS script to run a FTP via Windows Task Scheduler using: Powershell.exe -ExecutionPolicy Bypass -command ".'C:path\to\SCRIPTNAME.ps1' optional argument -WindowStyle Hidden For console testing, use Set-ExecutionPolicy RemoteSigned   or --bypass   [sourcecode language="plain"] # Location where csv file is to be created, with results from query. $dir = Get-ChildItem -Path "PATH TO DIRECTORY HERE" | Sort-Object…
Read more

Transferring a WordPress Site

If you are needing to transfer an entire WordPress site (entire meaning EVERYTHING) than here is the plugin you need! https://wordpress.org/plugins/duplicator/ Install it, activate it. Go and make a backup/transfer of your entire site Upload the 2 files it creates, installer.php and the backup zip file to your new site Go to your new site…
Read more