Difference between revisions of "SQWareProduction:mssql:lib:sqwmsq BackupDatabase.lib"

From Wiki_dbSQWare
Jump to: navigation, search
m (Updated by BatchUser)
m (Updated by BatchUser)
 
(8 intermediate revisions by the same user not shown)
Line 1: Line 1:
−
shell functions library $gvsqw_MssBin/../lib/sqwmsq_BackupDatabase.lib:<br>
+
shell functions library $gvsqw_MsqBin/../lib/sqwmsq_BackupDatabase.lib:<br>
 
{{SQWareProduction_sqwmsq_BackupDatabase.lib_presentation}}
 
{{SQWareProduction_sqwmsq_BackupDatabase.lib_presentation}}
 
<br>
 
<br>
 
Functions explanation:
 
Functions explanation:
 
<pre>
 
<pre>
−
gfsqw_ConvertBackslashToSlash $lvsqw_BackupPath|read lvsqw_BackupPath
+
gfsqw_BeginningCom
−
gfsqw_ConvertSlashToBackslash ${gvsqw_TmpFile}_$lvsqw_DbName.sql
+
gfsqw_ConvertSlashToBackslash $gvsqw_TmpFile.purge
 
gfsqw_ConvertSlashToBackslash $gvsqw_TmpFile.sql
 
gfsqw_ConvertSlashToBackslash $gvsqw_TmpFile.sql
−
gfsqw_EndMailError 34 "Fail to retrieve BackupDirectory !"
+
gfsqw_ConvertSlashToBackslash $gvsqw_TmpFile.trace
−
gfsqw_ExecSql $gvsqw_TmpFile.sql >$gvsqw_TmpFile
+
gfsqw_ExecSql $gvsqw_TmpFile.sql >$gvsqw_TmpFile
−
gfsqw_ExecXpCmdShell "dir /-C $lvsqw_BackupPathBackslash\\${lvsqw_DbName}_${lvsqw_BckDate}_?stripe*_c*.dump" > $gvsqw_TmpFile
+
gfsqw_ExecXpCmdShell $gvsqw_TmpFile.purge| sed 's,  *$,,' | tee $gvsqw_TmpFile.fic
−
gfsqw_ExecXpCmdShell "dir $lvsqw_BackupPathBackslash\\${lvsqw_DbName}*.dump" > $gvsqw_TmpFile.fic
+
gfsqw_ExecXpCmdShell $gvsqw_TmpFile.trace| sed 's,  *$,,' | tee $gvsqw_TmpFile
−
gfsqw_ExecXpCmdShell ${gvsqw_TmpFile}_$lvsqw_DbName.sql |tee $gvsqw_TmpFile
+
gfsqw_IsXpCmdShellEnabledGlobal "sqwmsq_BackupDatabase.ksh $gvsqw_InputParameters"
−
gfsqw_FormatHtmlMessages $gvsqw_TmpFile >> $gvsqw_TmpFile.mail
+
gfsqw_XpCmdShellGlobalDisable
 +
lfsqw_BackupDatabase =>  
 
lfsqw_BackupPath =>  
 
lfsqw_BackupPath =>  
 +
lfsqw_CheckIfFullExists =>
 +
lfsqw_CommandFormat
 
lfsqw_CommandFormat =>  
 
lfsqw_CommandFormat =>  
 
lfsqw_InsertMonitoringBackup =>  
 
lfsqw_InsertMonitoringBackup =>  
 +
lfsqw_PurgeDiff =>
 
lfsqw_PurgeHistory =>  
 
lfsqw_PurgeHistory =>  
−
lvsqw_BackupPathBackslash=$gfsqw_ConvertSlashToBackslash $lvsqw_BackupPath =>
 
 
</pre>
 
</pre>
 
<br>
 
<br>
−
{{SQWareProductionSurchargeLib|mssql|Mss|sqwmsq_BackupDatabase.lib}}
+
{{SQWareProductionSurchargeLib|mssql|Msq|sqwmsq_BackupDatabase.lib}}
 
<br>
 
<br>

Latest revision as of 18:20, 24 January 2023

shell functions library $gvsqw_MsqBin/../lib/sqwmsq_BackupDatabase.lib:
lib for sqwmsq_BackupDatabase.ksh
Functions explanation: 

gfsqw_BeginningCom
gfsqw_ConvertSlashToBackslash $gvsqw_TmpFile.purge
gfsqw_ConvertSlashToBackslash $gvsqw_TmpFile.sql
gfsqw_ConvertSlashToBackslash $gvsqw_TmpFile.trace
gfsqw_ExecSql $gvsqw_TmpFile.sql >$gvsqw_TmpFile
gfsqw_ExecXpCmdShell $gvsqw_TmpFile.purge| sed 's,  *$,,' | tee $gvsqw_TmpFile.fic
gfsqw_ExecXpCmdShell $gvsqw_TmpFile.trace| sed 's,  *$,,' | tee $gvsqw_TmpFile
gfsqw_IsXpCmdShellEnabledGlobal "sqwmsq_BackupDatabase.ksh $gvsqw_InputParameters"
gfsqw_XpCmdShellGlobalDisable
lfsqw_BackupDatabase => 
lfsqw_BackupPath => 
lfsqw_CheckIfFullExists => 
lfsqw_CommandFormat
lfsqw_CommandFormat => 
lfsqw_InsertMonitoringBackup => 
lfsqw_PurgeDiff => 
lfsqw_PurgeHistory =>


Nuvola apps information.png
Note:
You can overload functions contained in $gvsqw_MsqBin/../lib/sqwmsq_BackupDatabase.lib

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


Retrieved from "https://wiki.dbsqware.com/index.php?title=SQWareProduction:mssql:lib:sqwmsq_BackupDatabase.lib&oldid=22332"