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, 234, 259, 262, 289, 295, 302, 315) ORDER BY t.name ASC

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

According to the rpm man page description: “rpm  is  a  powerful Package Manager, which can be used to build, install, query, verify, update, and erase individual software packages.  A package consists of an archive of files and meta-data used to install and erase the archive files. The meta-data includes helper scripts,  file  attributes, and  descriptive  information about […]

Standard
July 5, 2017 Uncategorised
Jd

In the previous two posts we looked at the basic permissions for Linux File System and the umask concept and how that works. In this post, we will look at special permissions for Linux File System. The basic permissions are great and we can do a lot with them but then there are times when […]

Standard
June 29, 2017 Uncategorised
Jd

In the previous post Linux File System Permissions – Basics we learned about the basic permissions on files and folders. How does the system know what are the default permissions when you create a file/folder? Let’s create a new file as an ordinary user.

So, I added a file called examplefile as user anna. The […]

Standard
June 29, 2017 Uncategorised
Jd

I have always admired the way Linux handles permissions and I feel it’s a fool proof system. I was well aware of the User, Group and Other permissions set on files and folders and I had also read about umask, special permissions and ACLs but I never bothered looking too much into details for these […]

Standard
June 23, 2017 Uncategorised
Jd

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

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