In a previous article I described how to restore your website files from a backup using the LINUX command line, this time I’ll explain how to restore a database from backup using MySQL from the LINUX command line. The process is really quite simple and is achieved in just 2 main steps. Locate the backup […]
See how to output MySQL results to a file. I wanted to create a file listing table fields as output by Desc and found a number of methods.
MySQL Group Size Counts
This article describes how to output data group size counts in MySQL. I was required to carry this out when I needed to see how many items belonged to each group within a large set of data. The data I was looking at was UK company registration data and I wanted to see the number […]
If you’ve ever needed to move a website from one folder to another, within the same server and perhaps across sub-domains, then it is very likely that you’ve had to migrate the database as part of the process. Most tutorials on the web will tell you that to migrate a database from a to b, […]
This article describes step by step everything you need to know in order to set up a shiny new web site. For this example I make the following assumptions… Assumptions domain name = mysite.com domain name purchased from firm A (fxdomains) hosting with firm B (bluehost)