Large tables in mysql can be very slow to truncate, but this process can be easily made quicker.

How to see the size of all tables in the database.

SQL queries you can run to get the Size of MySQl Databases

How to remove lines from a file which match a search parameter

VirtualHost template for directing all traffic on HTTP (Port 80) to HTTPS (443)

How to quickly generate a wildcard SSL Cert on a Debian System

A bash script to allow monitoring of downloads speeds.

A peice of javascript to allow easy searching of content on the current page

How to only allow one IP to access a port on a linux server using iptables

How to add a swapfile to linux based system or vps.

Using the find command to find directories and delete them over a certain age.

How to check if a datbase exists from the command line.

How to actually run scripts in a plesk server with the correct PHP Version.

How to copy a file over sftp in one line

How to delete all local branches in a git repository except current

How to view the size of each table within a database.

How to put the results of a select query into a seperate table.

How to locate and kill a process which is hogging a port on the server.

How to pipe all traffing from one domain to another one whilst not changing the visible domain

Instructions on unbanning an IP which has been blocked by Fail2Ban.

Using Bash to bulk rename file extentions

How to add a file to a zipped archive protected with a password

Transferring data between tables using an SQL query rather.

Snippet for using the GBP symbol in areas where its not supported

How to enable a specific user to use the sudo command without entering their password

One line command to download public keys from GitHub and Append them to the authorized_keys file for simple server access

Fix for when the Apache2 service repeatedly crashes due to not being able to find the Mutex.

Listing out the size of all the tables in a mysql database.

A simple command to extract the sql file from an sql.gz extention

Redirecting a website from http to https or https to http.

How to Get the Date and Time of when a commit was made in git.

How to disable Safe Mode in MySQL Workbench

Release Announcement for the Input Class

Several commands for adding and modifying users in a mysql database.

Code snippet to convert a date using the DateTime class in PHP.

Code snippet to find what tables contain a specific column within a mysql database.

In this article we are looking at how we can use a custom domain for our email addresses whilst using the popular webmail GMail without having to pay for the benefit.

Amazon has Broken Alexa, or at least the App. With recent updates, Alexa has managed to cripple the Alexa Experience for many of its loyal customers.

Article, is a class which interacts with files in the disk and returning them in a simple to use format.

How to get the Postman application (and others with similar issue) back on the screen in windows 10.

Releasing a small update to the portfolio in the form of a search.

DataStore is a class which uses the directory and file structure of a filesystem to store and manipulate information. It does so using unique indentifiers for folder names and .dat files to hold the content of fields.

How to install Ubuntu 18.04 (Bionic Beaver) to a USB.

As the WebPi UI is going to be a lighweight base for future projects, a small but important change has been made to the core code.

How to import and export large MYSQL Databses with Progress Bar.

How to create a bootable USB drive from an iso file on linux.

A minor changes has been added to the WebPi UI to allow future expandability.

How to create a bootable USB drive from an iso file on windows.

Using SCP you can transfer files easily between one computer and another where ssh is available. This article is reference notes on how to use scp.

How to redirect all not existing content requests to a specific file in a directory.

A small upgrade to https://webpi.chris-shaw.com with the addition of a blog.

Introducing Web Pi, the Web User Interface for interacting with your raspberry Pi.

Sometimes you make commits locally in error and sometimes they can be a pain to get rid of, here are a few ways to do so.

When diagnosing internet and network connectivity, having a way to monitor issues over time is important. Here we will look at how to periodically log up and down speeds of the network.

Boot Raspberry Pi from USB The standard way of using a Raspberry Pi is to run the OS from a micro sd card. The problem with this is that the SD Card has limited read and writes, which will cause the SD to fail in a short period of time, especially if you write to files frequently.

How to tidy up a branch with multiple nonsence commits into one commit

Previously I wrote an article on how to install PHP 7.2 on Debian 8, since 7.2 is now available here is how to install 7.2

Virtual hosts in apache take incoming requests and point them to the correct directory. Here we will look into using wildcards to automate sub domains.

When backing up or transferring directories between computers its best to do so by compressing them in an archive to reduce space / bandwidth.

Procedure snippet for connecting to a database through an SSH Tunnel. Used for local development requiring live data.

Recently changed to having self hosted SSL Certificates thanks to LetsEncrypt. This is how easy it can be.

When using Windows Subsystem for Linux, you might need to access one operating systems files within another. Lets work out both ways.

I have had linux as my primary OS for about a decade now, and primarily use Ubuntu. But with the latest release I have decided to migrate back to an OS I generally dislike, Windows 10.

Quick fix for the bad signature , index file corrupt error in Git.

Ubuntu comes with a program called Apport, which is designed to inform the user where the system has detected a problem, or if a program has crashed. Although it is a well intended program, it gets in the way and is rather annoying, especially when it does not give you much information about the problem, or the problem which triggered it is of no real concern.

Over the years I have found my way around many minor hurdles when using Ubuntu, the most recent being Using the **DELL ULTRAHD 4K USB 3.0 DOCKING STATION (D3100)**.

I recently wrote a similar article for Ubuntu, but here is how to install on Debian 8.

Vagrant is a powerful tool when it comes to virtual machines, here we will look at how to setup and use Vagrant with Virtualbox on Ubuntu to provision reproducible virtual machines.

Ubuntu always lags behind with the software available in its repo's for security reasons, but if you need the latest version of PHP you need to look at other reputable repositories.

Here we look at how to generate SSH Keys and Copy them to servers to enable secure but pass-wordless login.

In this article we are going to cover how to install a linux distro to a USB Drive that allows you to use the usb drive as you would normally use the devices hard disk.

Why i rebuilt my website. As part of its life-cycle, this website has undergone a rebuild on top of a new framework and the addition of some new features.