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
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}' => 


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 .