sixhop / AutoMySQLBackup

A fork and further development of AutoMySQLBackup from sourceforge. http://sourceforge.net/projects/automysqlbackup/
GNU General Public License v2.0
341 stars 103 forks source link

Fix encrypted backup copy to latest #19

Closed chriswillow closed 5 years ago

chriswillow commented 6 years ago

Fix issue where script wasn't able to copy latest encrypted backup.

BigAndini commented 6 years ago

Can you please send over your configuration so I'm able to test it and see the error myself? I wondering because there is the

if (( $flags & $flags_files_postprocessing_success_encrypt )); then

right above your change in the file which would change the two versions of the if statement to the exact same code. It doesn't make sense to do an if statement to execute the exact same code afterwards.

chriswillow commented 6 years ago

Here's the minimum conf to replicate:

CONFIG_mysql_dump_encrypted_login='yes'
CONFIG_mysql_dump_login_path='automysqldump'
CONFIG_backup_dir='/home/test'
CONFIG_db_names=('mysql')
CONFIG_table_exclude=(mysql.event)
CONFIG_mysql_dump_single_transaction='yes'
CONFIG_mysql_dump_full_schema='no'
CONFIG_mysql_dump_use_separate_dirs='yes'
CONFIG_mysql_dump_compression='gzip'
CONFIG_mysql_dump_latest='yes'
CONFIG_encrypt='yes'
CONFIG_encrypt_password='password'

The error I get is

###### WARNING ######
Errors reported during AutoMySQLBackup execution.. Backup failed
Error log below..
cp: cannot stat '/home/test/daily/mysql/daily_mysql_2018-05-17_07h57m_Thursday.sql.gz.gz.enc': No such file or directory

Note the .sql.gz.gz.enc extension. The fix worked for me but it could be a sign of a different problem.