Man page
Official DMK manual page
NAME
DMK Database Management Kit for MySQL
SYNOPSIS
dmk.sh [OPTION | none]
dmk-run.sh [OPTION | none]
mysql.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
mysql.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 [MySQL_release] MySQL 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
AUTHOR
dbi services
Last updated