https://bugs.contribs.org/show_bug.cgi?id=10369
--- Comment #7 from Stefan Schulz <[email protected]> ---
>From the server log:
Jul 5 12:15:04 saturn esmith::event[18919]: Processing event: pre-backup
desktop
Jul 5 12:15:05 saturn esmith::event[18919]:
generic_template_expand=action|Event|pre-backup|Action|generic_template_expand|Start|1499249704
719812|End|1499249705 543795|Elapsed|0.823983
Jul 5 12:15:05 saturn esmith::event[18919]: Running event handler:
/etc/e-smith/events/pre-backup/S10mysql-delete-dumped-tables
Jul 5 12:15:05 saturn esmith::event[18919]:
S10mysql-delete-dumped-tables=action|Event|pre-backup|Action|S10mysql-delete-dumped-tables|Start|1499249705
544093|End|1499249705 546732|Elapsed|0.002639
Jul 5 12:15:05 saturn esmith::event[18919]: Running event handler:
/etc/e-smith/events/pre-backup/S20mysql-dump-tables
Jul 5 12:15:07 saturn esmith::event[18919]:
S20mysql-dump-tables=action|Event|pre-backup|Action|S20mysql-dump-tables|Start|1499249705
547042|End|1499249707 661797|Elapsed|2.114755
Jul 5 12:15:07 saturn esmith::event[18919]: Running event handler:
/etc/e-smith/events/pre-backup/S30ldap-dump
Jul 5 12:15:08 saturn esmith::event[18919]:
S30ldap-dump=action|Event|pre-backup|Action|S30ldap-dump|Start|1499249707
662131|End|1499249708 352665|Elapsed|0.690534
Jul 5 12:15:08 saturn esmith::event[18919]: Running event handler:
/etc/e-smith/events/pre-backup/S50rewind-tape
Jul 5 12:15:08 saturn esmith::event[18919]:
S50rewind-tape=action|Event|pre-backup|Action|S50rewind-tape|Start|1499249708
352953|End|1499249708 415463|Elapsed|0.06251
Jul 5 12:15:10 saturn esmith::event[19044]: Processing event: pre-backup
desktop
Jul 5 12:15:10 saturn esmith::event[19044]:
generic_template_expand=action|Event|pre-backup|Action|generic_template_expand|Start|1499249710
779407|End|1499249710 946016|Elapsed|0.166609
Jul 5 12:15:10 saturn esmith::event[19044]: Running event handler:
/etc/e-smith/events/pre-backup/S10mysql-delete-dumped-tables
Jul 5 12:15:10 saturn esmith::event[19044]:
S10mysql-delete-dumped-tables=action|Event|pre-backup|Action|S10mysql-delete-dumped-tables|Start|1499249710
946310|End|1499249710 948923|Elapsed|0.002613
Jul 5 12:15:10 saturn esmith::event[19044]: Running event handler:
/etc/e-smith/events/pre-backup/S20mysql-dump-tables
Jul 5 12:15:12 saturn esmith::event[19044]:
S20mysql-dump-tables=action|Event|pre-backup|Action|S20mysql-dump-tables|Start|1499249710
949227|End|1499249712 313210|Elapsed|1.363983
Jul 5 12:15:12 saturn esmith::event[19044]: Running event handler:
/etc/e-smith/events/pre-backup/S30ldap-dump
Jul 5 12:15:12 saturn esmith::event[19044]:
S30ldap-dump=action|Event|pre-backup|Action|S30ldap-dump|Start|1499249712
313543|End|1499249712 412708|Elapsed|0.099165
Jul 5 12:15:12 saturn esmith::event[19044]: Running event handler:
/etc/e-smith/events/pre-backup/S50rewind-tape
Jul 5 12:15:12 saturn esmith::event[19044]:
S50rewind-tape=action|Event|pre-backup|Action|S50rewind-tape|Start|1499249712
412997|End|1499249712 475638|Elapsed|0.062641
I could not find Information to pre-backup *desktop*?
S20mysql-dump-tables seems to run. But where is the dump?
# less S20mysql-dump-tables
#!/bin/sh
status=$(/sbin/e-smith/config getprop mysqld status)
if [ "$status" = "disabled" ]
then
echo "mysqld is disabled - no tables dumped" >&2
exit 0
fi
for db in $(mysql -BNre "show databases;")
do
mysqldump --ignore-table=mysql.event --single-transaction --add-drop-table
-QB "$db" -r /home/e-smith/db/mysql/"$db".dump || exit 1
done
It should be in /home/e-smith/db/mysql/
I did a test:
1.) I deleted every file in /home/e-smith/db/mysql/ on the prod-box
2.) I invoked affa on the affa-box manually by affa --run prod-box
3.) While the job is running, I checked the prod-box in /home/e-smith/db/mysql/
# ls -l /home/e-smith/db/mysql/
insgesamt 7796
-rw-r--r-- 1 root root 7252906 6. Jul 00:56 horde.dump
-rw-r--r-- 1 root root 439413 6. Jul 00:56 information_schema.dump
-rw-r--r-- 1 root root 8525 6. Jul 00:56 mailstats.dump
-rw-r--r-- 1 root root 249586 6. Jul 00:56 mysql.dump
-rw-r--r-- 1 root root 13515 6. Jul 00:56 phpmyadmin.dump
-rw-r--r-- 1 root root 3733 6. Jul 00:56 smeoptimizer.dump
-rw-r--r-- 1 root root 1393 6. Jul 00:56 test.dump
This seems to be good!
OMG! I' too stupid. For the dump from the prod-box I was looking in
/home/e-smith/db/mysql instead in /var/affa/scheduled.0/home/e-smith/db/mysql
I'm really sorry for bothering anyone who follows. Please close as not a bug.
regards,
stefan
--
You are receiving this mail because:
You are the QA Contact for the bug._______________________________________________
Mail for each SME Contribs bug report
To unsubscribe, e-mail [email protected]
Searchable archive at https://lists.contribs.org/mailman/public/contribteam/
