MythTV is the best Open Source media recording application MythTV Wiki This article follows the path I traveled when setting up a new MythTV server running on CentOS 7. The setup I followed in setting up the host is detailed … Continue reading
Category Archives: Database
Want to see what is being run against your MariaDB this is what to do. Firstly you need to enable logging to a file of all queries. You do this by running: SET GLOBAL general_log=1; SET GLOBAL general_log_file=’/var/opt/rh/rh-mariadb102/log/mariadb/maria_general.log’; Problem is … Continue reading
In the post CentOS 7 base VM for WordPress and MythTV I described how to create a base CentOS 7 VM. This post describes follows on from that post and describes the post installation tasks to make the VM a good … Continue reading
I run WordPress on Apache 2.2 on RedHat. A WordPress instance, is just a bunch of PHP files, various image files and uploaded files and a database – that’s pretty much it. So to backup and restore you need to … Continue reading
This mini project is designed to allow you to extract and import data from an Oracle database using simple JDBC. Nothing even remotely startling about that, this is designed as a very simple command line tool that can be called … Continue reading
Recently I upgraded to the latest Postgres version. I had a number of pain points doing this including not being able to start the DBs because the version upgrade was too big – had to export from old version and … Continue reading
This article is about a clean install of Oracle 11g R2 64bit on a Windows 7 64bit laptop. This setup is focused on my typical target install which is a simple DB install that doesn’t require a sophisticated DB but … Continue reading
This article assumes you have installed Oracle 11g as per article Clean install of Oracle 11g 64bit on Windows 7. Note all images in this article can be expanded to full size by clicking on the image! Steps 1. Select … Continue reading