AutoXchange 2026 Technical Documentation

MySQL Parameters

The following parameters define the methods for storing data in MySQL databases. Other databases can be supported, but the default is MySQL.

MYSQL Parameters
MSPORT	MySQL Port
MSUSER	MySQL User
MSPWD	MySQL Password for the user
MSUSERN[AME]	Name to use as ID in Users Table
MSEMAIL	Email address to use in Users Table
MSORG[ANIZATION]	Organization to use in Users Table
MSDATA[BASE]	MySQL database name
MSUSERT[ABLE]	Name of MySQL Users Table
MSDRAW[ING]	Name of MySQL Drawing Table
MSLAYER[S]	Name of MySQL Layers Table
MSLAYO[UTS]	Name of MySQL Layouts Table
MSTEXT	Name of MySQL Text Items Table
MSBLOCK[S]	Name of MySQL Blocks Table
MSATTRIB[UTES]	Name of MySQL Attributes Table

MySQL Port

PARAMETER	MSPORT
Purpose	This parameter specifies the port to be used for the MySQL connection. It is a string value that normally contains a URL and Port Number, separated by a colon. This parameter can also be defined by the $MYSQL_PORT Environment Variable on both Windows and Linux.
Example	-MSPORT=“127.168.1.1:3306”
JSON	{“MSPORT”:“127.168.1.1:3306}
Use	With SVG Only

MySQL User

PARAMETER	MyUser
Purpose	This parameter specifies MySQL User to be used. This parameter can also be defined by the $MYSQL_USER Environment Variable on both Windows and Linux.
Example	-MSUSER=scott
JSON	{“MSUSER”: “scott”}
Use	With SVG Only

MySQL Password

PARAMETER	MSPWD
Purpose	This parameter specifies MySQL Password for the User defined above. This parameter can also be defined by the $MYSQL_PWD Environment Variable on both Windows and Linux.
Example	-MSPWD=ABC123
JSON	{“MSPWD”: “ABC123”}
Use	With SVG Only

MySQL User Name

PARAMETER	MSUSERNAME
Purpose	This parameter specifies User Name to be used as part of the ID in the Users Table. It combines with MSEMAIL and MSORG to identify a unique user. It can be blank, in which case the default User will be used.
Example	-MSUSERNAME=“Harry Tomlinson”
JSON	{“MSUSERN”: “Harry Tomlinson”}
Use	With SVG Only

MySQL User Email

PARAMETER	MSEMAIL
Purpose	This parameter specifies Email Address to be used as part of the ID in the Users Table. It combines with MSUSERNAME and MSORG to identify a unique user. It can be blank, in which case the default User will be used.
Example	-MSEMAIL=“harry@somewhere.com”
JSON	{“MSEMAIL”: “harry@somewhere.com”}
Use	With SVG Only

MySQL User Organization

PARAMETER	MSORGANIZATION
Purpose	This parameter specifies User Organization to be used as part of the ID in the Users Table. It combines with MSUSERNAME and MSEMAIL to identify a unique user. It can be blank, in which case the default User will be used.
Example	-MSORGANIZATION=“Logistics”
JSON	{“MSORG”: “Accounting”}
Use	With SVG Only

MySQL Database

PARAMETER	MSDATABASE
Purpose	This parameter specifies MySQL Database (Source) to be used.
Example	-MSDATA=Drawing
JSON	{“MSDATA”: “Drawing”}
Use	With SVG Only

MySQL User Table

PARAMETER	MSUSERTABLE
Purpose	This parameter specifies the name of the MySQL Users Table to be used.
Example	-MSUSERTABLE=Users
JSON	{“MSUSERT”: “Users”}
Default	users
Use	With SVG Only

MySQL Drawing

PARAMETER	MSDRAWING
Purpose	This parameter specifies the name of the MySQL Drawing Table to be used.
Example	-MSDRAWING=Drawings
JSON	{“MSDRAW”: “Drawings”}
Default	drawings
Use	With SVG Only

MySQL Layers

PARAMETER	MSLAYERS
Purpose	This parameter specifies the name of the MySQL Layers Table to be used.
Example	-MSLAYERS=MyLayers
JSON	{“MSLAYERS”: “MyLayers”}
Default	layers
Use	With SVG Only

MySQL Layouts

PARAMETER	MSLAYERS
Purpose	This parameter specifies the name of the MySQL Layouts Table to be used.
Example	-MSLAYO=MyLayouts
JSON	{“MSLAYOUTS”: “MyLayouts”}
Default	layouts
Use	With SVG Only

MySQL Text Items

PARAMETER	MSTEXT
Purpose	This parameter specifies the name of the MySQL Text Items Table to be used.
Example	-MSTEXT=MyText
JSON	{“MSTEXT”: “MyText”}
Default	textitems
Use	With SVG Only

MySQL Blocks

PARAMETER	MSBLOCKS
Purpose	This parameter specifies the name of the MySQL Blocks Table to be used.
Example	-MSBLOCKS=Lego
JSON	{“MSBLOCKS”: “MyBlocks”}
Default	blocks
Use	With SVG Only

MySQL Attributes

PARAMETER	MSATTRIBUTES
Purpose	This parameter specifies the name of the MySQL Attributes Table to be used.
Example	-MSATTRIB=MyAttributes
JSON	{“MSATTRIBUTES”: “MyAttributes”}
Default	attributes
Use	With SVG Only

Last updated on 30 Jul 2022
Published on 10 Jul 2022