WordPress database error: [Can't create/write to file '/tmp/#sql_60b_0.MYI' (Errcode: 28)]
SHOW FULL COLUMNS FROM `wp_options`

WordPress database error: [Can't create/write to file '/tmp/#sql_60b_0.MYI' (Errcode: 28)]
SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag', 'post_format') AND tr.object_id IN (196, 205, 219, 231, 234, 259, 262) ORDER BY t.name ASC

PowerShell | Data Networking Blog
Data Networking Blog
Blog for Admins
Category Archives: PowerShell

A while back I had to write a script to download a bunch of files periodically on a Windows machine. I tried using some native built-in method of doing it but could’t find much useful information. Finally used WinSCP and PowerShell to download files. This uses SFTP and SCP which is basically over SSH. I […]

Standard
October 13, 2016 Uncategorised
Jd

So my company was hit with crypto virus twice in the last two and a half weeks. Luckily we got everything under control in time and thankfully did not have to pay a single cent. But as a pro-active measure I wrote a small crypto virus scanner script that scans our file server for files […]

Standard
October 7, 2016 Uncategorised
Jd

The following script scans IPV4 networks for hosts that respond to ICMP requests. The idea is that the script automatically finds the IP and MASK of the configured interfaces on the machine, calculates the range from IP/Mask and starts scanning. Also displays a visual progress bar. This PowerShell Lan Scanner script will also try and […]

Standard
September 27, 2016 Uncategorised
Jd

.Net and Powershell are now available for Linux as open source packages. This is a good move as i think this will make a lot of people really comfortable with using Linux. Before we can install Powershell core we need the .Net core installed as Powershell is built on top of .Net sudo yum install […]

Standard
August 19, 2016 Uncategorised
Jd

If you love those new Windows 10 lock screen images like me then you may want to keep a copy for yourself so you can enjoy them as a permanent desktop background or just keep them for a collection. This PowerShell script will let you copy/grab the Windows 10 lockscreen images and save them to […]

Standard
August 18, 2016 Uncategorised
Jd

Script below will move files from source to destination that match the given extension or all files if no extension is provided. The files older then 30 days are moved by default. you can specify the number of days using the -olderthandays parameter. [CmdletBinding()] param ( [Parameter(Mandatory=$true)][string]$source, [Parameter(Mandatory=$true)][string]$destination, [string[]]$exten=”.*”, [int]$olderthandays = 30 ) $lwt = […]

Standard
August 3, 2016 Uncategorised
Jd

First, connect to your office 365 environment Connect-MsolService -Credential (Get-Credential) Every Office365 environment has a password policy which contains the notification period and validity period for passwords. Since we want to check when a users password will expire, we will first get this validity period and save it in a variable. In the same Powershell […]

Standard
August 3, 2016 Uncategorised
Jd
Font Size
Decrease Size Default Size Increase Size
Select Skin
Select Underlay Background
Select Overlay Background
Scheme Switcher Toggle