https://bugs.koozali.org/show_bug.cgi?id=11970
--- Comment #22 from Terry Fage <[email protected]> ---
/etc/e-smith/events/actions/mysql-dump-tables
[root@sme10 ~]# cat /etc/e-smith/events/actions/mysql-dump-tables
#!/bin/sh
---snip----
for db in $(mysql -BNre "show databases;"|egrep -vi
"^information_schema$|^performance_schema$")
do
mysqldump --skip-opt --ignore-table=mysql.event --single-transaction
--add-drop-table -QB "$db" -r /home/e-smith/db/mysql/"$db".dump || onfailure
$db
done
****Note - added the --skip-opt to the line as shown at line 40
Set to run at 8:30am my time, did so NO error message, following is email
checking directory "/root/backup/db_mymaria/daily" ... exists.
checking directory "/root/backup/db_mymaria/weekly" ... exists.
checking directory "/root/backup/db_mymaria/monthly" ... exists.
checking directory "/root/backup/db_mymaria/latest" ... exists.
checking directory "/root/backup/db_mymaria/tmp" ... exists.
checking directory "/root/backup/db_mymaria/status" ... exists.
# Testing for installed programs
pigz ... found.
mysql ... found.
mysqldump ... found.
mail ... found.
# Parsing databases ... done.
======================================================================
AutoMySQLBackup version 3.0
http://sourceforge.net/projects/automysqlbackup/
Backup of Database Server - sme10
Databases - horde,mysql,test
Databases (monthly) - horde,mysql,test
======================================================================
======================================================================
Dump status.
Rotating 4 month backups for
======================================================================
Backup Start Time Thu Aug 11 08:30:02 AEST 2022
======================================================================
Daily Backup ...
Daily Backup of Database ( horde )
Rotating 6 day backups for horde
----------------------------------------------------------------------
Daily Backup of Database ( mysql )
Rotating 6 day backups for mysql
----------------------------------------------------------------------
Daily Backup of Database ( test )
Rotating 6 day backups for test
----------------------------------------------------------------------
Backup End Time Thu Aug 11 08:30:04 AEST 2022
======================================================================
Total disk space used for backup storage...
Size - Location
1.4M /root/backup/db_mymaria
======================================================================
--
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/
