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 (24, 39, 43, 60, 66, 95, 120, 138, 140, 142) ORDER BY t.name ASC

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

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 recently had a problem where scanning a IIS web server using Titania SSLScan tool for SSL/TLS ciphers I received empty results. The webserver otherwise was working fine and if I tried a web browser I could see a cipher in the SSL certificate. After spending alot of time I finally found a solution. Running […]

Standard
August 20, 2015 Uncategorised
Jd

While deploying a new web server in our web farm I noticed that the web server I created was giving me some headaches with SSL. It would sometimes present invalid certificates and if I tried telnet commands the connection on port 443 closed quickly. This indicated a problem but I did not hear of any […]

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

Recently I was asked to setup external NTP on a couple of windows 2012 servers and to match the NTP servers to another existing server so to be consistent. There is no GUI to do this and alot of the posts on the internet talk about changing registry which personally I am not too comfortable […]

Standard
April 8, 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

In this blog we will look at how we can find the originating country for a given IP address. I do this to quickly check this information for all IP addresses logged in my Apache logs. I will only use the command line but you can put all this in a script and do a lot […]

Standard
February 17, 2015 Uncategorised
Jd

There are multiple ways to backup your systems and data and the one you choose to implement depends on many different factors such as the OS. Today we are looking at rsync utility to backup important data. I am not going to perform a full backup of my system as it is easier for me […]

Standard
February 6, 2015 Uncategorised
Jd

If you are an administrator for a company or just looking after some personal servers, you will soon realise that it is important to properly manage your log files. Log files give you important information about the health and security of your system. If you have not planned for log management then chances are you […]

Standard
February 6, 2015 Uncategorised
Jd

Updating systems is an important part of day to day administration. Normally you plan your updates and check compatibility with a lot of other software running on your server before applying updates so if you are thinking about auto updating a critical server then I would advise against it. Why? There are a lot of reasons. […]

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