Topic: Backup and restoring of mysql databases

[SchulzStefan]

Stefano,

thank you for your reply.

I assume it's the dump on the affa-box.  No other dump to find...

# ls -l
insgesamt 1216556
-rw-r--r-- 1 root root     124940 17. Jan 2015  horde.dump

The date is irritating... As I mentioned, the last backup was today, starting around 12:00 p.m.

Regards,
stefan

[SchulzStefan]

Well, seems there's an issue with affa:

less horde.dump, shows at the last line:

-- Dump completed on 2015-01-17  3:00:09

If this is the last (and only) dump, I have either a misconfiguration of affa, or affa is not working/reporting proper.

This is my conf in /etc/affa for the prod-box:

[servername]
remoteHostName=x.x.x.x
TimeSchedule=1215
SMEServer=yes
Watchdog=yes
ConnectionCheckTimeout=120
Debug=no
Description=xxx
DiskSpaceWarn=strict
RootDir=/var/affa
localNice=15
remoteNice=15
rsync--inplace=yes
rsyncCompress=no
rsyncTimeout=900
sshPort=22
Include=/root
Include=/opt
Include=/usr/local/mailarchiva
Include=/home/httpd
Include=/usr/lib/mailman
Include=/var/lib/mailman
Include=/var/spool/hylafax
scheduledKeep=1
dailyKeep=2
weeklyKeep=1
monthlyKeep=0
yearlyKeep=0
chattyOnSuccess=9024
status=enabled

affa reports every time it runs success.

I assume, the dump should be up-to-date?

Regards,
stefan

[Stefano]

Please, 1 question 1 topic
And anything that doesn't work out of the box is likely a bug, then bugzilla, thank you

[SchulzStefan]

Stefano,

excuse me, you're right.

I'll file a bug regarding affa and the dump.

regards,
stefan

[SchulzStefan]

Bug opened.

https://bugs.contribs.org/show_bug.cgi?id=10369

[janet]

SchulzStefan

IIRC the standard backup creates the database dump file before the backup begins & deletes it after the backup completes, so you will not find a dump file on your "live" server after the backup completes ie it has been copied to the backup location.

During a restore the dump file is used to repopulate the database(s).

Affa works a bit differently so I am not sure if it makes use of a database dump file.
You can monitor your server from another iteration of the command line console & watch for creation of a dump file.