SQWareProduction:mysql:lib:sqwmys DumpDatabase.lib: Difference between revisions

From Wiki_dbSQWare
Jump to navigation Jump to search
Exploit (talk | contribs)
m Updated by Expdbtools
 
m Updated by BatchUser
 
(5 intermediate revisions by the same user not shown)
Line 1: Line 1:
shell functions librairy $gvsqw_MysBin/../lib/sqwmys_DumpDatabase.lib:<br>
shell functions library $gvsqw_MysBin/../lib/sqwmys_DumpDatabase.lib:<br>
{{SQWareProduction_sqwmys_DumpDatabase.lib_presentation}}
{{SQWareProduction_sqwmys_DumpDatabase.lib_presentation}}
<br>
<br>
Functions explanation:
Functions explanation:
<pre>
<pre>
echo "\nDump file: $lfsqw_DumpFile"
gfsqw_BeginningCom
gfsqw_EndMailError 12 "Failed to mkdir $gvsqw_RootDump !"
lfsqw_CommandFormat
gfsqw_InsertIndicatorsSql
lfsqw_CommandFormat =>  
lfsqw_CommandFormat =>  
lfsqw_DumpFile="$gvsqw_RootDump/${lvsqw_DbName}_${lvsqw_DumpDate}.dump.gz"
lfsqw_DumpDatabase =>
lfsqw_InsertMonitoringDump =>  
lfsqw_InsertMonitoringDump =>  
lfsqw_SqlOpt=""
lfsqw_Pipe =>
lfsqw_SqlOpt="$gvsqw_ConsistentInnoDb"
lfsqw_PurgeHisto
lfsqw_SqlOpt="$gvsqw_ConsistentOthers"
lfsqw_PurgeHisto =>  
ls -al $lfsqw_DumpFile
lvsqw_DumpSize=$du -sk $lfsqw_DumpFile|awk '{print $1}' =>  
</pre>
</pre>
<br>
<br>
{{SQWareProductionSurchargeLib|mysql|Mys|sqwmys_DumpDatabase.lib}}
{{SQWareProductionSurchargeLib|mysql|Mys|sqwmys_DumpDatabase.lib}}
<br>
<br>

Latest revision as of 19:21, 24 January 2023

shell functions library $gvsqw_MysBin/../lib/sqwmys_DumpDatabase.lib:
lib for sqwmys_DumpDatabase.ksh
Functions explanation:

gfsqw_BeginningCom
lfsqw_CommandFormat
lfsqw_CommandFormat => 
lfsqw_DumpDatabase => 
lfsqw_InsertMonitoringDump => 
lfsqw_Pipe => 
lfsqw_PurgeHisto
lfsqw_PurgeHisto => 


Note:
You can overload functions contained in $gvsqw_MysBin/../lib/sqwmys_DumpDatabase.lib

by function with same name in $gvsqw_MysBin/../lib_cust/sqwmys_DumpDatabase.lib for all your environnement
or by $HOME/sqwConfig/sqwmys_DumpDatabase.lib specifically for this user .