Template:SQWareProduction sqwmys DumpDatabase.ksh help

From Wiki_dbSQWare
Revision as of 17:02, 6 November 2023 by BatchUser (talk | contribs) (Updated by BatchUser)
Jump to navigation Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
Sourcing sqwmys_Global.lib v2023.08 SQWareProduction for MySQL (dbSQWare) ... 

Usage: sqwmys_DumpDatabase.ksh [-h] -I instance -D databasename [+ options]

DESCRIPTION
   sqwmys_DumpDatabase.ksh mysqldump of database
SUPPORT
   MySql   supported versions: 5.0 <= v <= 8.1
   MariaDB supported versions: 5.5 <= v <= 11.1

PARAMETERS
     -I  instance       : Target instance to mysqldump.
     -D  databasename   : Database for mysqldump.
OPTIONS
     -h    help         : Display the full usage.
     -s                 : Display samples of usage.
     -RD directory      : Directory to write dump file (default $HOME/mys_dump/$MYSQL_SID).
     -HI   nb_gen       : Number of generations to keep (default: 2).
     -Opt  option       : Additional options for mysqldump.
     -ZIP extension     : Compressor extension gz,bz2,Z,none (default: gz).
     -FRT  return_code  : Force return code value on error.
     -Dist              : For distant connection to database (change $gvsqw_ConnectString to $gvsqw_DistConnectString ).
     -AddMail email     : Email address to add at 'pmexpdba@gmail.com'.
     -SendReport        : Send execution log report.
     -NoMail            : Deactivate sendmail on error pmexpdba@gmail.com (by default, send on error).
     -Locale   locale   : Force Locale for help display (fr,en).
     -Consistent        : Lock for consistent mode (by default, no lock).
     -Exec              : Execute commands (default, display generated commands)