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

From Wiki_dbSQWare
Jump to: navigation, search
m (Updated by BatchUser)
m (Updated by BatchUser)
Line 4: Line 4:
 
Functions explanation:
 
Functions explanation:
 
<pre>
 
<pre>
−
echo "\nDump file: $lfsqw_DumpFile"
 
−
gfsqw_InsertIndicatorsSql
 
 
lfsqw_CommandFormat =>  
 
lfsqw_CommandFormat =>  
 
lfsqw_DumpFile="$gvsqw_RootDump/${lvsqw_DbName}_${lvsqw_DumpDate}.dump.gz"
 
lfsqw_DumpFile="$gvsqw_RootDump/${lvsqw_DbName}_${lvsqw_DumpDate}.dump.gz"
 
lfsqw_InsertMonitoringDump =>  
 
lfsqw_InsertMonitoringDump =>  
−
lfsqw_SqlOpt=""
 
−
lfsqw_SqlOpt="$gvsqw_ConsistentInnoDb"
 
−
lfsqw_SqlOpt="$gvsqw_ConsistentOthers"
 
−
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>

Revision as of 22:43, 12 November 2011

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

lfsqw_CommandFormat => 
lfsqw_DumpFile="$gvsqw_RootDump/${lvsqw_DbName}_${lvsqw_DumpDate}.dump.gz"
lfsqw_InsertMonitoringDump =>


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=2375"