Setting up a MySQL Database

V6 is designed to work with MySQL to capture session details

Getting Started

MySQL is an industry standard database with strong support and wide usage. It is relatively easy to setup and work with – and may already be in use at your production or post-production facilty

This article assumes that you do not have a MySQL instance available and that you have not setup a database previously

To begin, download MySQL Installer from https://dev.mysql.com/downloads/windows/installer/5.7.html – which contains all you need to get going. I do recommend taking some time and reading through the MySQL pages and documentation – at least to gain a familiarity with database basics and best practices.

Install MySQL Server

Once downloaded, double-click the installer file and follow along

For most normal installations select “Custom”

Next – select MySQL Server and MySQL Workbench products for installation

MySQL server is required – MySQL Workbench provides a graphical interface to MySQL operations

Clck “Execute” to begin installation

Once installation is complete it is time to configure the database instance

Click “Next” to continue…

…then “Next” again…

From this point on it is best to accept the defaults – click “Next” to advance through the configuration steps

Next – setup your root user password and setup a user account to access the database

It is best to make the user a DB-Admin for initializing the database schema and for creating tables

Let the installer finish and configure the server and additional tools. Once installed and the database is running, open a new MySQL Command Line Utility window and enter the root password you setup earlier to login. Once at the MySQL prompt you can setup a new database by entering

create database V6;

exactly as written then hit Enter.  You should see  “Query OK, 1 row affected” when completed

Next, setup the tables. Copy and paste the following text into your MySQL Command Line window

CREATE TABLE xcodes(
sessiondate VARCHAR(64) NULL,
clipname VARCHAR(1024) NULL,
vcodec VARCHAR(64) NULL,
acodec VARCHAR(64) NULL,
vprofile VARCHAR(64) NULL,
vquality VARCHAR(10) NULL,
vburn VARCHAR(255) NULL,
3dlut VARCHAR(1024) NULL,
pscurve VARCHAR(1024) NULL,
tcmode VARCHAR(64) NULL,

timecode VARCHAR(64) NULL,
aspect VARCHAR(32) NULL,
crop VARCHAR(32) NULL,
deinterlace VARCHAR(32) NULL,
rescale VARCHAR(32) NULL,
copyright VARCHAR(1024) NULL,
reelname VARCHAR(1024) NULL,
outputdir VARCHAR(1024) NULL,
logfile VARCHAR(1024) NULL,
logdir VARCHAR(1024) NULL
);

…which creates the table for conversions data. Next create the Exif Data table by copy and paste the following text into the MySQL Command Line window

CREATE TABLE exifdata(
sessiondate VARCHAR(64) NULL,
outputdir VARCHAR(1024) NULL,
clipname VARCHAR(1024) NULL,
shotdate VARCHAR(32) NULL,
resformat VARCHAR(10) NULL,
resolution VARCHAR(10) NULL,
aspectratio VARCHAR(10) NULL,
framerate VARCHAR(10) NULL,
numframes VARCHAR(255) NULL,
duration VARCHAR(16) NULL,
timecode VARCHAR(12) NULL,
shutter VARCHAR(12) NULL,
angle VARCHAR(10) NULL,
fstop VARCHAR(10) NULL,
iso VARCHAR(10) NULL,
audiochannels VARCHAR(10) NULL,
lumarange VARCHAR(10) NULL,
filesize VARCHAR(255) NULL,
avgbitrate VARCHAR(255) NULL,
bitdepth VARCHAR(15) NULL,
vidformat VARCHAR(12) NULL,
whitebalance VARCHAR(12) NULL,
make VARCHAR(255) NULL,
model VARCHAR(512) NULL,
logdir VARCHAR(1024) NULL
);

If all went well your database should be ready-to-use. Use the MySQL button in the Exif Report Tool or Media Command Builder interfaces to login to your database and begin recording data.

Your login session should look something like this (with your user name instead):