Man page

Official DMK manual page

NAME

DMK Database Management Kit for MariaDB

SYNOPSIS

dmk.sh [OPTION | none]

dmk-run.sh [OPTION | none]

mariadb.sh [OPTION | none]

mcreate.sh [OPTION]

mremove.sh [OPTION]

mbackup.sh [OPTION]

mdump.sh [OPTION]

housekeeping.sh [OPTION]

fsdisc.sh [OPTION | none]

version.sh

DESCRIPTION

dmk The DMK (Database Management Kit) offers to database administrators an efficient way to manage databases. It's a platform independent and standardized collection of scripts for Linux/Unix.

PARAMETER

[instance]

It can be instance id, number, or name: [1..9] | mysqld[1..9] | [instance name]

e.g.: 4 | mysqld4 | master-prod

Instance name are defined in $DMK_HOME/etc/instance.conf

OPTIONS

dmk.sh

[instance | none] Launch the instance | Re-source DMK

dmk-run.sh

Show instance status

-s|--sid [instance]

-a|--all

mariadb.sh

[start | stop | restart] [instance** | none]** Start/stop/restart instance | all

mcreate.sh

Performs standardized MySQL server creation

-s|--sid [instance] Instance id, number, or custom name [1..9] | mysqld[1..9] | [instance name]

-r|--release [MariaDB_release] MariaDB release 10.X e.g.: mcreate.sh -s mysqld4 -r 10.8

-c|--config [Config_mcreate.cfg_path] mcreate.cfg path

mremove.sh

Performs standardized MySQL server removal

-s|--sid [instance] Instance id, number, or name

mbackup.sh

Performs standardized MySQL Enterprise Backup operations

-s|--sid [instance] target database MYSQL_SERVER [MANDATORY]

-c|--configfile location of the mbackup.cfg [MANDATORY]if file not stored at the standard location $DMK_MYSQL_ADMIN/etc/mbackup.cfg

--nosuccessmail Mails will only be sent in case of errors, default specified within mbackup.cfg

mdump.sh

Performs standardized MySQL dump operations

-s|--sid [instance] target database MYSQL_SERVER [MANDATORY]

-c|--configfile location of the mdump.cfg [MANDATORY] if file not stored at the standard location $DMK_MYSQL_ADMIN/etc/mdump.cfg

-z|--compress compressed backup, using O.S gzip utility

--nosuccessmail Mails will only be sent in case of errors, default specified within mdump.cfg

-d|--databasename Optional parameter if you want to backup only one specific database

-a|--alldatabasessinglefiles Optional parameter if you want to have a separated backup file per database

housekeeping.sh

Performs houskeeping tasks

-c|--configfile [config_file] MANDATORY if configfile not stored under default location $DMK_HOME\tcousekeeping.cfg

fdisk.sh

List the different filesystems in a readable format. Default parameter: fsdisc.sh -s4

-r sort reverse

-s1 sort column 1 "file system name"

-s2 sort column 2 "Mb total"

-s3 sort column 3 "Mb Free"

-s4 sort column 4 "file system Usage"

version.sh

Show new files

ALIASES

See all aliases by running command: dmkhelp. Or cat $DMK_HOME/doc/dmkhelp.lst

EXIT STATUS

TABLE

DEBUG

To switch the DEBUG mode, use the following command:

enable: export DEBUG=1

disable: export DEBUG=0

SEE ALSO

files:

$DMK_HOME/doc/dmkhelp.lst

$DMK_HOME/doc/debughelp.lst

$DMK_HOME/doc/Readme.md

$DMK_HOME/doc/DMK-MariaDB-manual.pdf

$DMK_HOME/doc/D-MariaDB-OFA-E20200204-001-DBI.pdf

AUTHOR

dbi services