The RaspberryPi is something that I’ve always been interested in but never really got around to actually ordering one… until this week! In February the RaspberryPi Foundation released the RaspberryPi 2, this models sports a quad core, 900Mhz ARM7 processor with 1GB of RAM, this is a massive improvement on the previous models so I […]
Tag: mysql
I’ve recently been developing a C# desktop application for Microsoft Windows that integrates with Microsoft Flight Simulator and Lockheed Martin’s Prepar3d – The software is designed to monitor the landing rate of a user’s aircraft upon landing and then displays this information to the user to aid them perfect their landings whilst flying in the simulated […]
I thought I’d quickly post up this quick MySQL snippet to help others who are trying to quickly view the size of a MySQL database from the MySQL CLI. The following query displays the size of all your current MySQL databases on your server in megabytes:- SELECT table_schema “Data Base Name”, sum( data_length + index_length […]
Ok so this is aimed at being a very quick guide to installing a PHP (specifically PHP 5.4, but you can install PHP 5.3 or.PHP 5.5 if you wish!) development environment and MySQL server to enable you to develop (using the built in PHP development server) and MySQL on an MacOSX based machine, so to […]
I started using MAMP PRO recently as I wanted to develop using the latest (PHP 5.4) on MacOSX and I didn’t want all the hassle of building Apache and PHP on my development machine each time…. I only found that MAMP PRO catered for PHP 5.4 much to my disappointment! However today, I decided to give […]
Although I don’t really use Adobe Dreamweaver for web development (although if i’m doing interface design where I need a quick way to alter and view CSS changes fast I do) a friend of mine the other day (who uses Dreamweaver heavily) wanted to know how to re-enable the old JSP (Java Server Page) support […]
In this easy to follow tutorial I will show you how to install Apache, PHP and MySQL on FreeBSD, I have used FreeBSD 8.2 in this tutorial but should work for at least a couple of release’s later. I will be installing the software using FreeBSD ‘Ports’ you can also install software on FreeBSD using […]
This tutorial describes how to set up database replication in MySQL using an SSL connection for encryption (to make it impossible for hackers to sniff out passwords and data transferred between the master and slave). MySQL replication allows you to have an exact copy of a database from a master server on another server (slave), […]
I had a little hunt around online this evening for a graphical user interface for MySQL on my Linux workstation which is running Ubuntu 10.04 – In the past I’ve always just used the terminal and raw MySQL commands but to be honest this can be some what time consuming so I thought I’d share […]
Now a few of my projects are getting much bigger and the need for having dedicated Database servers are now more appealing than ever. With MySQL when setting it up I noticed that when trying to access a remote database from an application server, it would takes ages to respond/connect to it. After searching around […]