Creating a MySQL table to receive the MyConnection Server parameters

Step 1:

Once you have installed MySQL you need to log in to MySQL from the command prompt in order to create the tables.

Do do this type: mysql -u root -p and hit the enter key. You will then be prompted with an enter password field. You will have set a password when installiny MySQL. That is the password that is being requested.

Once the password has been entered successfully you will get the mysql> command prompt, as shown below.

Step 2:

Once you have logged in to your MySQL from the command prompt you need to create a database, if you have not already done so. To do this type

create database "databasename";

The quotes are for your understanding only, replace databasename with your own database name, in the example below the database name is mcs.

Step 3:

You now have to select the database in order to start creating tables. To do this type:

use "databasename";

The quotes are for your understanding only, replace databasename with your own database name, in the example below the database name is mcs.

Step 4:

You can now begin adding tables to your database.

Do do this you need to use the create table command. The exact syntax is:

create table tablename (columnname inputtype, columnname inputtype, etc etc)

The example below creates a table called speed then adds various column names that will be used to add data to from MyConnection Server.

Below the screenshot are ready made table commands that can be copied and pasted to help create your own tables. They contain every parameter you can have in MyConnection Server so feel free to edit according to what data you want to collect.

You can find help on MySQL commands at http://dev.mysql.com/doc/refman/5.1/en/

Click here for a tutorial on setting up MyConnection Server to deliver data to your MySQL database.

CREATE TABLE speed (recordid bigint, testid int, dspeed bigint, uspeed bigint, qos tinyint, rtt smallint, maxpause mediumint, avgpause mediumint, bandwidth bigint, routespeed bigint, forcedidle tinyint, routeconc float, dtesttype varchar(6), utesttype varchar(6), PRIMARY KEY (recordid));

CREATE TABLE capacity (recordid bigint, testid int, dcapacity bigint, ucapacity bigint, dpackets mediumint, upackets mediumint, packetsize smallint, qos tinyint, PRIMARY KEY (recordid));

CREATE TABLE iptv (recordid bigint, testid int, jitter1 float, loss1 float, order1 float, jitter2 float, loss2 float, order2 float, jitter3 float, loss3 float, order3 float, PRIMARY KEY (recordid));

CREATE TABLE route (recordid bigint, testid int, ipto varchar(64), hops tinyint, endms smallint, maxms smallint, endloss smallint, maxloss smallint, ipfrom varchar(64), nameto varchar(128), PRIMARY KEY (recordid));

CREATE TABLE video (recordid bigint, testid int, ajitter float, vjitter float, aloss tinyint, vloss tinyint, adiscards tinyint, vdiscards tinyint, PRIMARY KEY (recordid));

CREATE TABLE voip (recordid bigint, testid int, jitter float, djitter float, loss float, dloss float, uorder float, dorder float, discards float, mos float, PRIMARY KEY (recordid));

CREATE TABLE act (recordid bigint, testid int, dspeed bigint, uspeed bigint, qos tinyint, rtt smallint, maxpause mediumint, maxroutespeed int, maxlinespeed int, concurrenttcp float, tcpforcedidle float, tcprxpooo mediumint, tcprxbooo mediumint, tcprxpow mediumint, tcprxbow mediumint, tcprxdop mediumint, tcprxdob mediumint, tcprxpdp mediumint, tcprxpdb mediumint, tcprxcrcerr mediumint, tcprxboff mediumint, tcprxts mediumint, tcpbyteslost mediumint, uqos tinyint, umaxpause mediumint, umaxlinespeed int, uconcurrenttcp float, utcpforcedidle float, ethrxftl mediumint, ethrxnoal mediumint, ethrxsf mediumint, ethrxcrcerr mediumint, ethrxovr mediumint, ethrxtrunc mediumint, dtesttype varchar(6), version varchar(128), runtime bigint, freeq mediumint, PRIMARY KEY (recordid));

CREATE TABLE tests (recordid bigint, testid int, time varchar(40), timeint bigint, detaillink varchar(128), sid varchar(255), ip varchar(64), dnsname varchar(64), cc varchar(2), isp varchar(64), PRIMARY KEY (recordid));

Step 5:

You can view the tables you have created by using the show tables; command as shown below:

Step 6:

Click here for help on setting MyConnection Server to deliver results to a MySQL database
Visualware Home | Contact Us | About Us