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 (66, 120, 142, 196, 205, 219, 231, 234, 259, 262) ORDER BY t.name ASC

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

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

Powershell script to delete old files/folders The script below will delete any files/folders older than the provided number of days. It first creates an inverted tree of folder/file structure and then loops through each to see if the last write time is older than a given number of days. You can also clean empty folders […]

Standard
August 20, 2015 Uncategorised
Jd

I had to create a couple of new Servers today but the instructions were to make them identical to an existing server which sits in a different Data Centre. So I started off by using the Server Manager GUI and noting down the roles features but I realized there were about 71 of them and […]

Standard
August 6, 2015 Uncategorised
Jd

In a previous article I showed you how to use rsync to backup your files. This works fine for most of situations but I was still unable to backup my mySql databases without first manually exporting them to a .sql format. So I decided to write a small shell script to do this for me. […]

Standard
February 19, 2015 Uncategorised
Jd
Font Size
Decrease Size Default Size Increase Size
Select Skin
Select Underlay Background
Select Overlay Background
Scheme Switcher Toggle