Database – Zoyinc

MythTV on CentOS 7

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 firstly in CentOS 7 base VM for WordPress and MythTV then in CentOS 7 VM for WordPress… read more…
Monitor all queries to MariaDB

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 you need special permissions and in practical terms the easiest way is to run it… read more…
CentOS 7 VM for WordPress and MythTV – Post install setup

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 solid base for me to run WordPress or MythTV. When setting up a Linux server… read more…
Backup and restore WordPress

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 back up one directory tree and a DB. This post details what I did to… read more…
YankIt – Extract from Oracle using JDBC including blobs

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 from Ant. From what I can see there really isn’t anything out there that works… read more…
Resetting a PostgreSQL root password

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 import to new. But one of the problems was that for some reason my password… read more…
Clean install of Oracle 11g 64bit on Windows 7

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 does require me to have an ability to create multiple DB instances – so “Express”… read more…
Creating an Oracle 11g database

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 “Database Configuration Assistant” from the Start menu under Oracle 2. On the “Welcome” page click… read more…