Difference between revisions of "Template:SQWareProduction sqwmys CopyDumpAllDatabases.ksh help"
m (Updated by BatchUser) |
m (Updated by BatchUser) |
||
Line 1: | Line 1: | ||
<pre> | <pre> | ||
− | Sourcing sqwmys_Global.lib v4.0. | + | Sourcing sqwmys_Global.lib v4.0.06 SQWareProduction for MySQL (dbSQWare) ... |
Usage: sqwmys_CopyDumpAllDatabases.ksh [-h] -I instance -IS <SourceInstance> -US <SourceHostname> [+ options] | Usage: sqwmys_CopyDumpAllDatabases.ksh [-h] -I instance -IS <SourceInstance> -US <SourceHostname> [+ options] |
Revision as of 19:53, 17 June 2018
Sourcing sqwmys_Global.lib v4.0.06 SQWareProduction for MySQL (dbSQWare) ... Usage: sqwmys_CopyDumpAllDatabases.ksh [-h] -I instance -IS <SourceInstance> -US <SourceHostname> [+ options] DESCRIPTION sqwmys_CopyDumpAllDatabases.ksh copy of dump all databases in // SUPPORT MySql supported versions: 5.0 <= v <= 5.7 PARAMETERS -I instance : Target instance for copy. -IS instance : Source instance. -US hostname : Source hostname. OPTIONS -P Nb threads : Number of threads in parallel (by default 2). -ID listdb : Databases list for running copy (by default all). -ED listdb : Databases list to exclude. -IL likeclause : Like clause to generate databases list (example: 'db%'). -EL likeclause : Like clause to exclude databases (example: 'nodb%'). -HI Nb : Nb of generations to keep (by default 1). -RD directory : Directory to find dump file (default $HOME/mys_dump/$MYSQL_SID). -RDS directory : Directory to find source dump file (default $HOME/mys_dump/$lvsqw_InstanceSource). -UUS username : User unix source(by default, same of target). -WCD whereclause : Where clause to generate databases list. -AGR Nb sec : Nb of seconds between two run (by default 1s). -AGE Nb sec : Nb of seconds between two check of end (by default 10s). -FRT return_code : Force return code value on error. -NoMail : Desactivate sendmail on error pmexpdba@gmail.com (by default, send on error). -AddMail email : Email Address to add at 'pmexpdba@gmail.com'. -SendReport : Send execution log report. -h help : Display the full usage. -s : Display samples of usage. -Exec : Execute commands (default, display generated commands)