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)
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>
Line 5: Line 5:
 
<pre>
 
<pre>
 
echo "\nDump file: $lfsqw_DumpFile"
 
echo "\nDump file: $lfsqw_DumpFile"
gfsqw_EndMailError 12 "Failed to mkdir $gvsqw_RootDump !"
 
 
gfsqw_InsertIndicatorsSql
 
gfsqw_InsertIndicatorsSql
 
lfsqw_CommandFormat =>  
 
lfsqw_CommandFormat =>  

Revision as of 22:30, 24 May 2011

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

echo "\nDump file: $lfsqw_DumpFile"
	gfsqw_InsertIndicatorsSql
lfsqw_CommandFormat => 
lfsqw_DumpFile="$gvsqw_RootDump/${lvsqw_DbName}_${lvsqw_DumpDate}.dump.gz"
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}' => 


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 .