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

From Wiki_dbSQWare
Jump to: navigation, search
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 18: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 =>


Nuvola apps information.png
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 .


Retrieved from "https://wiki.dbsqware.com/index.php?title=SQWareProduction:mysql:lib:sqwmys_DumpDatabase.lib&oldid=22362"