Minimalist backup routine

Use this forum if you have installed hMailServer and want to ask a question related to a production release of hMailServer. Before posting, please read the troubleshooting guide. A large part of all reported issues are already described in detail here.
Post Reply
User avatar
ras07
Normal user
Normal user
Posts: 184
Joined: 2010-03-11 08:51

Minimalist backup routine

Post by ras07 » 2015-03-31 06:03

Since upgrading to 5.6.2 I've been having sporadic trouble with the built-in backup system. It appears to fail when a .eml file gets moved/deleted between the backup of the account files and the data backup (which can be 10 or 15 minutes on my system with ~2 GB of data). I'm nearly certain this is new behavior; I never had a problem before 5.6.2. I've read through the forum threads and it looks like others are having similar trouble. The suggestion was made there to just create an external backup routine, and this made sense to me. I'd like to solicit comments on my minimalist batch file:

Code: Select all

@echo off
set hMSvrDir=C:\hmailserver
set BackFileName=H:\Backups\hMailServer\hMailServer-%date:~10,4%-%date:~4,2%-%date:~7,2%-%time:~0,2%%time:~3,2%%time:~6,2%
REM The above only works for US region, due to date format differences.

net stop hmailserver
sleep 3
REM Sleep is an aftermarket utility that does what is says on the tin. 
REM Sleep probably isn't necessary since I don't think NET STOP returns until the service is stopped anyway.

mysqldump -u"root" -p"my password" -q -A -l --add-drop-table -P3306 >"%hMSvrDir%\MYSQLDump.mysql"
net start hmailserver
7za a -mx1 %BackFileName% %hMSvrDir%\*
My goal is to perform a "safe" backup with a minimum of server downtime. For that reason I'm only stopping hms for the mysqldump, not for the data backup. I realize that this could result in some inconsistencies. What I'm not sure about is what this would mean after a restore. I'm willing to risk the occasional lost email. What are the ramifications here? What's the worst case scenario?

Is there anything I'm missing here?

ras

User avatar
mattg
Moderator
Moderator
Posts: 19810
Joined: 2007-06-14 05:12
Location: 'The Outback' Australia

Re: Minimalist backup routine

Post by mattg » 2015-03-31 06:37

you start the hmailserver service before you copy the hmailserver directory

I normally only copy the /data directory plus the hMailserver.ini rather than copy the entire hMailserver directory.

ALSO, I use robocopy to copy the data directory (it's faster and only copies changes)

And, you must use MySQL and have 7Zip installed for that to work

(And, yes the 'sleep' is redundant)
Just 'cause I link to a page and say little else doesn't mean I am not being nice.
https://www.hmailserver.com/documentation

User avatar
ras07
Normal user
Normal user
Posts: 184
Joined: 2010-03-11 08:51

Re: Minimalist backup routine

Post by ras07 » 2015-03-31 06:52

I'm restarting hMailServer before copying the data directory on purpose. I just don't want the server down that long. I'm trying to understand how dangerous that is.

I tried a bunch of copy options including Robocopy, and basically nothing was faster than 7za - even when there was nothing to update (no file changes), Robocopy still takes longer to scan the directory structure than 7Zip takes to archive the whole thing.

User avatar
jimimaseye
Moderator
Moderator
Posts: 7949
Joined: 2011-09-08 17:48

Re: Minimalist backup routine

Post by jimimaseye » 2015-03-31 10:51

You dont test for errors in your service stop/starting, copying or the zipping. And I KNOW that it is important because I have seen rare occasions where errors have occurred (despite it working normally day after day).

Here is a script that does pretty much the same as you are suggesting but with notable additions:

1, Use robocopy mirroring to a temporary 'copy' directory of the data directory. It is this temporary directory that is then Zipped.
2, ERROR CHECKING and response after each action
3, added spamassassin definition update (you can REMove if not applicable)
4, This 7zip command is slightly different from your original (amend as you wish)
5, My date/timestamp is UK formatted, not US.

I have 9.5GB data directory and with this method my Mailservice is offline for 30 seconds (is that too much?) whilst ensuring FULL integrity of mail files+database

Note this is a HEAVILY cutdown version without any whistles or bells. The full version does trash email cleardowns, offsite storage uploading and does nice little emailing bits and bobs with colours and twinkles reporting on the results (but I have removed this functionality as you wanted BASIC. So I may have left in the script some things that seemingly dont have any purpose - I was rushing).

Anyway, FWIW:

Code: Select all

rem ---  SET LOCATIONS (without trailing '\')  ----
Set BACKUPdir=D:\Backups
Set BACKUPTEMPdir=D:\BackupTemp
set DATABASEEXEdir=C:\Program Files\MySQL\MySQL Server 5.5\bin
set MAILDATAdir=C:\Program Files (x86)\hMailServer\Data
set SPAMASSASSINdir=C:\Program Files (x86)\JAM Software\SpamAssassin for Windows
set 7ZIPdir=C:\Program Files\7-Zip

rem  ****  FILL OUT VARIABLES ABOVE  **** -----------------------------


set str=%time:~0,8%&rem
set str=%str: =0%
set str=%str::=%
set inDate=%date:~6,4%-%date:~3,2%-%date:~0,2%-%str%
REM The above set for UK region, due to date format differences.

set Failed=false
set FailedScript=Not performed
set FailedZip=Not performed
set FailedSAUpdate=Not performed
set FailedSAService=Not performed
set FailedDNSService=Not performed
set FailedHmailservice=Not performed

set section=1st

:1st
:maildata
net stop hmailserver 
set FailedHmailservice=Ok
if errorlevel 1 set Failed=true& set FailedHmailservice=Failed to stop

:2nd
net stop spamassassin 
set FailedSAService=Ok
if errorlevel 1 set Failed=true& set FailedSAService=Failed to stop

:3rd
set section=3rd
if "%FailedHmailservice%" == "Failed to stop" goto 5th
robocopy "%MAILDATAdir%" %BACKUPTEMPdir%\hMailData /mir /ndl /r:43200 /np /w:1 
goto ROBOerrorcheck

:4th
cd %DATABASEEXEdir%
mysqldump -u"root" -p"itsasecret" -q -A -l --add-drop-table -P3306 >"%BACKUPTEMPdir%\hMailData\MYSQLDump_%inDate%.mysql"

:5th
@rem Update Spamassassin before restarting service
set FailedSAUpdate=Ok
%SPAMASSASSINdir%\
sa-update.exe -v --nogpg --channelfile UpdateChannels.txt 
if errorlevel 1 set Failed=true& set FailedSAUpdate=Failed

:6th
@rem Restart Spamassassin and Hmailserver services
if "%FailedSAService%" NEQ "Ok" goto 7th
net start spamassassin 
if errorlevel 1 set Failed=true& set FailedSAService=Failed to restart

:7th
if "%FailedHmailservice%" NEQ "Ok" goto 8th
net start hmailserver 
if errorlevel 1 set Failed=true& set FailedHmailservice=Failed to restart

:8th

REM :: Zip temporary directory
cd %7ZIPdir% 
set FailedZip=Ok
7z a -tzip "%BACKUPdir%\Serverdata_%inDate%" %BACKUPTEMPdir%\*
if errorlevel 1 set Failed=true& set FailedZip=Failed

:test
set result=%date% %time% Backup procedure FAILED!!! Zip: %FailedZip%, SA Update: %FailedSAUpdate%, SA Service: %FailedSAService%.
set resulttext="!!! Backup completed WITH ERRORS.  CHECK LOG FILE FOR DETAILS!!!"
if not %Failed%==false goto Testend
:success
set result=%date% %time% Backup 7Zip Archive created - no errors encountered.
set resulttext="Backup completed. See attachment log file."
goto Testend

:ROBOerrorcheck
if errorlevel 16 echo ***FATAL ERROR***  & goto end
if errorlevel 15 echo OKCOPY + FAIL + MISMATCHES + XTRA  & goto end
if errorlevel 14 echo FAIL + MISMATCHES + XTRA  & goto end
if errorlevel 13 echo OKCOPY + FAIL + MISMATCHES  & goto end
if errorlevel 12 echo FAIL + MISMATCHES & goto end
if errorlevel 11 echo OKCOPY + FAIL + XTRA  & goto end
if errorlevel 10 echo FAIL + XTRA  & goto end
if errorlevel 9 echo OKCOPY + FAIL  & goto end
if errorlevel 8 echo FAIL  & goto end
if errorlevel 7 echo OKCOPY + MISMATCHES + XTRA  & goto end
if errorlevel 6 echo MISMATCHES + XTRA  & goto end
if errorlevel 5 echo OKCOPY + MISMATCHES  & goto end
if errorlevel 4 echo MISMATCHES  & goto end
if errorlevel 3 echo OKCOPY + XTRA  & goto end
if errorlevel 2 echo XTRA  & goto end
if errorlevel 1 echo OKCOPY   & goto end
if errorlevel 0 echo No Change  & goto end
:end
if errorlevel 8 set Failed=true
if %section%==9th set section=10th
if %section%==8th set section=9th
if %section%==7th set section=8th
if %section%==6th set section=7th
if %section%==5th set section=6th
if %section%==4th set section=5th
if %section%==3rd set section=4th
if %section%==2nd set section=3rd
if %section%==1st set section=2nd
goto %section%

:Testend
echo %result% 
echo %resulttext% 

:GoEmail
Rem !! DO EMAIL OF RESULTS HERE  with'result' and 'resulttext' variables   !!
HMS 5.6.6 B2383 on Win Server 2008 R2 Foundation, + 5.6.7-B2415 on test.
SpamassassinForWindows 3.4.0 spamd service
AV: Clamwin + Clamd service + sanesecurity defs : https://www.hmailserver.com/forum/viewtopic.php?f=21&t=26829

User avatar
ras07
Normal user
Normal user
Posts: 184
Joined: 2010-03-11 08:51

Re: Minimalist backup routine

Post by ras07 » 2015-03-31 20:30

Thanks - I agree there should be some error checking. I'll definitely add that.

I've played pretty extensively with Robocopy and I just can't get it to perform. I don't know why but scanning the directory structure takes forever. Here's an output example:

Code: Select all

                Total    Copied   Skipped  Mismatch    FAILED    Extras
     Dirs :      3460         0      3460         0         0         0
    Files :     42990         7     42983         0         0         0
    Bytes :   1.959 g    7.08 m   1.952 g         0         0         0
    Times :   0:03:33   0:00:00                       0:00:00   0:03:32

    Speed :            16336474 Bytes/sec.
    Speed :             934.780 MegaBytes/min.
I ran that with the exact switches you use. As you can see, that's with only needing to actually copy a handful of files; with a normal days' worth of changes, it's over 5 minutes. This is with under 2 GB of data in a couple dozen accounts. My source drive is on an SSD. (hMailServer runs in a virtual machine; perhaps that has something to do with it.)

Conversely, 7Zip will archive everything in under 4 minutes - more like 2 minutes when using the -mx0 (no compression) flag.

Robocopy seems like it should be a great solution; for some reason though, it just won't perform in my situation.

User avatar
SorenR
Senior user
Senior user
Posts: 3133
Joined: 2006-08-21 15:38
Location: Denmark

Re: Minimalist backup routine

Post by SorenR » 2015-03-31 20:40

Mmmm... My server got to be real slow somehow... I'm off the 'net for 1 minute...

Got inspired by your BATCH file and brewed up a VBscript. Major difference is that I don't STOP hMailServer, I PAUSE the server :wink:

Code: Select all

C:\hMailServer\Events>start-stop.vbs
Microsoft (R) Windows Script Host Version 5.6
Copyright (C) Microsoft Corporation 1996-2001. All rights reserved.

31-03-2015 19:50:20 SUSPENDING SERVER !
31-03-2015 19:50:20 Doing stuff like RoboCopy and Database backup
31-03-2015 19:51:22 RoboCopy: No files were copied. No failure was encountered.
31-03-2015 19:51:22 No files were mismatched. The files already exist in the
31-03-2015 19:51:22 destination directory; therefore, the copy operation was skipped.
31-03-2015 19:51:23 MySQLDump performed successfully...
31-03-2015 19:51:23 RESUMING SERVER !
31-03-2015 20:07:28 7-Zip performed successfully...

C:\hMailServer\Events>
This has passed ALPHA testing ONLY... Notice, there are only 2 (two) variables in use and one is for returncodes :mrgreen:

The script does this:

- Pause server
- Robocopy to backup directory
- Dump hmailserver database
- Resume server
- 7-Zip backup directory incl. database dump
- Delete database dump (otherwise Robocopy will give wrong answer next time)

ToDo:

- include hmailserver.ini
- include eventhandler script(s)
- Pathnames to executeables...
- ERRORHANDLING :!:

Code: Select all

Option Explicit

   Const hm_Administrator = "Administrator"
   Const hm_Password      = "VERY SECRET!"
   Const hm_Database      = "hmailserver"
   Const hm_DataDir       = "c:\hmailserver\data"

   Const wsh_Robocopy     = "robocopy"
   Const wsh_MySQLdump    = "mysqldump"
   Const wsh_7Zip         = "7z"

   Const sql_User         = "NOT root ;-)"
   Const sql_Password     = "ALSO VERY SECRET!"
   Const sql_Server       = "localhost"
   Const sql_Dumpfile     = "hmailserver.dump"

   Const dir_Backup       = "c:\backup\hmailserver\data"
   Const dir_Archive      = "c:\backup\hmailserver"

   With CreateObject("hMailServer.Application")
      .Authenticate hm_Administrator, hm_Password

      ' ServerState
      Const Stopped  = 1
      Const Starting = 2
      Const Running  = 3
      Const Stopping = 4

      Dim ERRORLEVEL, strParam

      Do
         Select Case .ServerState
            Case Running
               Wscript.Echo Now() & " SUSPENDING SERVER !"
               .Stop
            Case Stopped
               Wscript.Echo Now() & " Doing stuff like RoboCopy and Database backup"
               With CreateObject("WScript.Shell")

                  strParam = hm_DataDir & " " & dir_Backup & " /mir /ndl /np /r:43200 /w:1"
                  ERRORLEVEL = .Run(wsh_Robocopy & " " & strParam, 0, True)
                  Select Case ERRORLEVEL
                     Case 0
                        Wscript.Echo Now() & " RoboCopy: No files were copied. No failure was encountered."
                        Wscript.Echo Now() & " No files were mismatched. The files already exist in the"
                        Wscript.Echo Now() & " destination directory; therefore, the copy operation was"
                        Wscript.Echo Now() & " skipped."
                     Case 1
                        Wscript.Echo Now() & " RoboCopy: All files were copied successfully."
                     Case 2
                        Wscript.Echo Now() & " RoboCopy: There are some additional files in the"
                        Wscript.Echo Now() & " destination directory that are not present in the source"
                        Wscript.Echo Now() & " directory. No files were copied."
                     Case 3
                        Wscript.Echo Now() & " RoboCopy: Some files were copied. Additional files were"
                        Wscript.Echo Now() & " present. No failure was encountered."
                     Case 5
                        Wscript.Echo Now() & " RoboCopy: Some files were copied. Some files were mismatched."
                        Wscript.Echo Now() & " No failure was encountered."
                     Case 6
                        Wscript.Echo Now() & " RoboCopy: Additional files and mismatched files exist. No"
                        Wscript.Echo Now() & " files were copied and no failures were encountered. This"
                        Wscript.Echo Now() & " means that the files already exist in the destination"
                        Wscript.Echo Now() & " directory."
                     Case 7
                        Wscript.Echo Now() & " RoboCopy: Files were copied, a file mismatch was present,"
                        Wscript.Echo Now() & " and additional files were present."
                     Case 8
                        Wscript.Echo Now() & " RoboCopy: Several files did not copy."
                  End Select

                  strParam = "--routines=true --triggers=true --events=true --host=" & sql_Server &_
                             " --user=" & sql_User & " --password=" & sql_Password &_
                             " --result-file=" & dir_Backup & "\" & sql_DumpFile & " " & hm_Database
                  ERRORLEVEL = .Run(wsh_MySQLdump & " " & strParam, 0, True)
                  If ERRORLEVEL = 0 Then
                     Wscript.Echo Now() & " MySQLDump performed successfully..."
                  End If

               End With

               .Start
               Wscript.Echo Now() & " RESUMING SERVER !"

               With CreateObject("WScript.Shell")

                  strParam = "a -t7z " & dir_Archive & "\" &_
                             DatePart("yyyy",Date) & Right("0" & DatePart("m",Date), 2) & Right("0" & DatePart("d",Date), 2) & "-" &_
                             Right("0" & Hour(Now), 2) & Right("0" & Minute(Now), 2) & Right("0" & Second(Now), 2) &_
                             ".7z " & dir_Backup
                  ERRORLEVEL = .Run(wsh_7Zip & " " & strParam, 0, True)
                  If ERRORLEVEL = 0 Then
                     Wscript.Echo Now() & " 7-Zip performed successfully..."
                  End If

               End With

               With CreateObject("Scripting.FileSystemObject")
                  .DeleteFile "C:\backup\hmailserver\data\hmailserver.dump"
               End With

         End Select

      Loop Until .ServerState = Running

   End With
Last edited by SorenR on 2015-03-31 20:44, edited 1 time in total.
SørenR.

The quantum rule of insecurity which states that the act of observing how vulnerable a host or service is changes the insecurity level of the service.

User avatar
jimimaseye
Moderator
Moderator
Posts: 7949
Joined: 2011-09-08 17:48

Re: Minimalist backup routine

Post by jimimaseye » 2015-03-31 20:43

ras07 wrote:Here's an output example:

Code: Select all

                Total    Copied   Skipped  Mismatch    FAILED    Extras
     Dirs :      3460         0      3460         0         0         0
    Files :     42990         7     42983         0         0         0
    Bytes :   1.959 g    7.08 m   1.952 g         0         0         0
    Times :   0:03:33   0:00:00                       0:00:00   0:03:32

    Speed :            16336474 Bytes/sec.
    Speed :             934.780 MegaBytes/min.
Robocopy seems like it should be a great solution; for some reason though, it just won't perform in my situation.
Hmmm... I see it is rather slow.

Example of mine for comparison:

Code: Select all

               Total    Copied   Skipped  Mismatch    FAILED    Extras
    Dirs :      1498         0      1498         0         0         0
   Files :     27996        70     27926         0         0        36
   Bytes :   7.509 g   31.52 m   7.479 g         0         0    7.83 m
   Times :   0:00:28   0:00:03                       0:00:00   0:00:25


   Speed :            10644056 Bytes/sec.
   Speed :             609.057 MegaBytes/min.
28 seconds for 7.5GB opposed to your 3minutes for your 2.

My guess is it is something to do with being SSD and/or other hardware/configuration. But what, I dont know. One thing I do have is my Maildata directory in the windows Indexing. Try adding that and see if it helps? (cant see why though)
HMS 5.6.6 B2383 on Win Server 2008 R2 Foundation, + 5.6.7-B2415 on test.
SpamassassinForWindows 3.4.0 spamd service
AV: Clamwin + Clamd service + sanesecurity defs : https://www.hmailserver.com/forum/viewtopic.php?f=21&t=26829

User avatar
jimimaseye
Moderator
Moderator
Posts: 7949
Joined: 2011-09-08 17:48

Re: Minimalist backup routine

Post by jimimaseye » 2015-03-31 21:04

SorenR wrote: Got inspired by your BATCH file and brewed up a VBscript....
Mr Soren loves his VBScripting. :D He da' MAN!

(you not including the email cleardown script too, Soren? After all the work you did a month ago :o )
HMS 5.6.6 B2383 on Win Server 2008 R2 Foundation, + 5.6.7-B2415 on test.
SpamassassinForWindows 3.4.0 spamd service
AV: Clamwin + Clamd service + sanesecurity defs : https://www.hmailserver.com/forum/viewtopic.php?f=21&t=26829

User avatar
SorenR
Senior user
Senior user
Posts: 3133
Joined: 2006-08-21 15:38
Location: Denmark

Re: Minimalist backup routine

Post by SorenR » 2015-03-31 21:52

jimimaseye wrote:
SorenR wrote: Got inspired by your BATCH file and brewed up a VBscript....
Mr Soren loves his VBScripting. :D He da' MAN!

(you not including the email cleardown script too, Soren? After all the work you did a month ago :o )
Didn't you post that script ?
SørenR.

The quantum rule of insecurity which states that the act of observing how vulnerable a host or service is changes the insecurity level of the service.

User avatar
jimimaseye
Moderator
Moderator
Posts: 7949
Joined: 2011-09-08 17:48

Re: Minimalist backup routine

Post by jimimaseye » 2015-03-31 22:12

Which one? The cleardown script?
HMS 5.6.6 B2383 on Win Server 2008 R2 Foundation, + 5.6.7-B2415 on test.
SpamassassinForWindows 3.4.0 spamd service
AV: Clamwin + Clamd service + sanesecurity defs : https://www.hmailserver.com/forum/viewtopic.php?f=21&t=26829

User avatar
SorenR
Senior user
Senior user
Posts: 3133
Joined: 2006-08-21 15:38
Location: Denmark

Re: Minimalist backup routine

Post by SorenR » 2015-03-31 23:18

jimimaseye wrote:Which one? The cleardown script?
This one ??

viewtopic.php?p=173427#p173427
SørenR.

The quantum rule of insecurity which states that the act of observing how vulnerable a host or service is changes the insecurity level of the service.

User avatar
jimimaseye
Moderator
Moderator
Posts: 7949
Joined: 2011-09-08 17:48

Re: Minimalist backup routine

Post by jimimaseye » 2015-03-31 23:27

Yes indeed I did. So are you going to use it yourself in your earlier 'inspired' housekeeping/backup routine?

(Ah, I think I now get the confusion: when I asked "are you not going to include....the script?" I meant are you not going to use it yourself with your new backup routine. (I wasnt asking if you are not going to post it here.))
HMS 5.6.6 B2383 on Win Server 2008 R2 Foundation, + 5.6.7-B2415 on test.
SpamassassinForWindows 3.4.0 spamd service
AV: Clamwin + Clamd service + sanesecurity defs : https://www.hmailserver.com/forum/viewtopic.php?f=21&t=26829

User avatar
SorenR
Senior user
Senior user
Posts: 3133
Joined: 2006-08-21 15:38
Location: Denmark

Re: Minimalist backup routine

Post by SorenR » 2015-04-01 00:30

jimimaseye wrote:Yes indeed I did. So are you going to use it yourself in your earlier 'inspired' housekeeping/backup routine?

(Ah, I think I now get the confusion: when I asked "are you not going to include....the script?" I meant are you not going to use it yourself with your new backup routine. (I wasnt asking if you are not going to post it here.))
Oh... Well, I run a very small operation here so any automation is totally overkill :mrgreen:

I do "stuff" to learn... Like changing the timing belt, waterpump and thermostat on my old Audi S4 2.7T... I do all service/maintenance/repair on our cars myself. Had the S4 for 7 years, sold it 2 years ago - Still missing it... :(

Anyways... Eventually I will incorporate some form of automation. It starts out as one thing and slowly evolves. Like when I initially worked on a subroutine to make my custom logging more flexible - It ended up being a "toolbox" Class definition that can be used inside and outside of the EventHandler over COM or DCOM without modifications and it supports file locking for multithreaded use and will do automatic splitting on day or month. 8)
SørenR.

The quantum rule of insecurity which states that the act of observing how vulnerable a host or service is changes the insecurity level of the service.

User avatar
mattg
Moderator
Moderator
Posts: 19810
Joined: 2007-06-14 05:12
Location: 'The Outback' Australia

Re: Minimalist backup routine

Post by mattg » 2015-04-01 01:53

just checked my backup routine

I don't do Net start or Net stop or pause, the backup is started by scheduled task

robocopy to NAS temp directory
copy .ini to NAS temp directory
Mysql dump to NAS temp directory (This is all MySQL databases, including the websites that I host, dump size is just over a 100 MB)

7Zip to compress and move to another folder on NAS


Scheduled task fires at 2:20 am
MySQL dump written at 2:47 am

15.8 GB Zip created at 5:08 am

My NAS temp directory has
225,894 files
14,313 folders
and is 26.4 Gb in size

and most of these are my emails - gee I keep some garbage :shock:
Just 'cause I link to a page and say little else doesn't mean I am not being nice.
https://www.hmailserver.com/documentation

User avatar
jimimaseye
Moderator
Moderator
Posts: 7949
Joined: 2011-09-08 17:48

Re: Minimalist backup routine

Post by jimimaseye » 2015-04-01 10:20

mattg wrote:I don't do Net start or Net stop or pause, the backup is started by scheduled task
Are you saying that because its Task Scheduler then you do it, or are these separate comments?

Mine is also done by Task Scheduler all in the bat file. If you dont pause or stop the service at time of robocopy is there is a risk that the SQL dump and copy of emails may not match (if processing of an email happens to take place at that exact time). Im sure you know this so out of interest why do you not do it?
HMS 5.6.6 B2383 on Win Server 2008 R2 Foundation, + 5.6.7-B2415 on test.
SpamassassinForWindows 3.4.0 spamd service
AV: Clamwin + Clamd service + sanesecurity defs : https://www.hmailserver.com/forum/viewtopic.php?f=21&t=26829

User avatar
mattg
Moderator
Moderator
Posts: 19810
Joined: 2007-06-14 05:12
Location: 'The Outback' Australia

Re: Minimalist backup routine

Post by mattg » 2015-04-01 16:44

they are separate comments...

Yes that is a risk, but it's never been an issue for me
Just 'cause I link to a page and say little else doesn't mean I am not being nice.
https://www.hmailserver.com/documentation

User avatar
jimimaseye
Moderator
Moderator
Posts: 7949
Joined: 2011-09-08 17:48

Re: Minimalist backup routine

Post by jimimaseye » 2015-04-01 16:49

mattg wrote: Yes that is a risk, but it's never been an issue for me
In fact, what are the chances that
a, you need to call upon a backup AND
b, that backup JUST SO HAPPENED to have an email processed at the moment that it had finished copying with robocopy but before the MySQL dump was completed?

Mind you, you have a 27 minute window for it to happen (correct?), so it could do.
HMS 5.6.6 B2383 on Win Server 2008 R2 Foundation, + 5.6.7-B2415 on test.
SpamassassinForWindows 3.4.0 spamd service
AV: Clamwin + Clamd service + sanesecurity defs : https://www.hmailserver.com/forum/viewtopic.php?f=21&t=26829

User avatar
mattg
Moderator
Moderator
Posts: 19810
Joined: 2007-06-14 05:12
Location: 'The Outback' Australia

Re: Minimalist backup routine

Post by mattg » 2015-04-01 17:19

And
C: that a message that is received at 2:20 am is real (and not SPAM), and
D: the message is deleted by accident before the following night, when the next backup fires


Pretty slim I reckon
Just 'cause I link to a page and say little else doesn't mean I am not being nice.
https://www.hmailserver.com/documentation

User avatar
jimimaseye
Moderator
Moderator
Posts: 7949
Joined: 2011-09-08 17:48

Re: Minimalist backup routine

Post by jimimaseye » 2015-04-01 17:29

yeah, I agree. Slim to say the least.
HMS 5.6.6 B2383 on Win Server 2008 R2 Foundation, + 5.6.7-B2415 on test.
SpamassassinForWindows 3.4.0 spamd service
AV: Clamwin + Clamd service + sanesecurity defs : https://www.hmailserver.com/forum/viewtopic.php?f=21&t=26829

Post Reply