search

sukria / Backup-Manager

Versatile yet easy to use command line backup tool for GNU/Linux. Suitable for desktop and servers.
http://www.backup-manager.org/
GNU General Public License v2.0
277 stars 88 forks source link

mysql archives are not uploaded #110

Closed loranger closed 6 years ago

loranger commented 6 years ago

Hello,

For a reason I can't figure out, my mysql backup are not uploaded on the remote server. File are created locally, one sql.bz2 per database. All my tar.gz files are uploaded using the scp method, index-* too, but the mysql archives remains locally. If I use a gzip compression format, the result is the same.

What did I miss ?

loranger commented 6 years ago

In fact, it seems files are uploaded and then purged, but that's not the behaviour I would expect :

...
Utilisation de la méthode « mysql ».
Utilisanton du fichier de configuration existant du client MySQL: /root/.backup-manager_my.cnf
/var/archives/myserver.com-mysql-mysql.20180118.sql.bz2 : OK (1 Mo, 1d53243148cac0d6a3cf8d3c67422a60)
/var/archives/myserver.com-mysql-nextcloud.20180118.sql.bz2 : OK (5 Mo, d47c55c433aaf5fcb5459f47b313f1f4)
Utilisation de la méthode de téléchargement « ssh ».
Trying to upload files with scp
File /var/archives/myserver.com-etc.20180118.tar.gz uploaded successfully.
File /var/archives/myserver.com-mysql-mysql.20180118.sql.bz2 uploaded successfully.
File /var/archives/myserver.com-mysql-nextcloud.20180118.sql.bz2 uploaded successfully.
File /var/archives/myserver.com-var-www-nextcloud.20180118.tar.gz uploaded successfully.
File /var/archives/index-20180118-1 uploaded successfully.
Cleaning remote directory through SSH
Purging /home/backups/myserver.com/myserver.com-mysql-mysql.20180118.sql.bz2
Purging /home/backups/myserver.com/myserver.com-mysql-nextcloud.20180118.sql.bz2
File /var/archives/myserver.com-etc.20180118.tar.gz uploaded successfully.
File /var/archives/myserver.com-mysql-mysql.20180118.sql.bz2 uploaded successfully.
File /var/archives/myserver.com-mysql-nextcloud.20180118.sql.bz2 uploaded successfully.
File /var/archives/myserver.com-var-www-nextcloud.20180118.tar.gz uploaded successfully.
File /var/archives/index-20180118-1 uploaded successfully.
Cleaning remote directory through SSH
Purging /home/backups/myserver.com/myserver.com-mysql-mysql.20180118.sql.bz2
Purging /home/backups/myserver.com/myserver.com-mysql-nextcloud.20180118.sql.bz2
Process finished at 2018-01-18  15:59:40
sukria commented 6 years ago

It's probably your upload TTL, can you paste here your configuration file, and the output of backup-manager -d?

Le 18 janv. 2018 16:02, "Laurent Goussard" notifications@github.com a écrit :

In fact, it seems files are uploaded and then purged, but that's not the behaviour I would expect :

... Utilisation de la méthode « mysql ». Utilisanton du fichier de configuration existant du client MySQL: /root/.backup-manager_my.cnf /var/archives/myserver.com-mysql-mysql.20180118.sql.bz2 : OK (1 Mo, 1d53243148cac0d6a3cf8d3c67422a60) /var/archives/myserver.com-mysql-nextcloud.20180118.sql.bz2 : OK (5 Mo, d47c55c433aaf5fcb5459f47b313f1f4) Utilisation de la méthode de téléchargement « ssh ». Trying to upload files with scp File /var/archives/myserver.com-etc.20180118.tar.gz uploaded successfully. File /var/archives/myserver.com-mysql-mysql.20180118.sql.bz2 uploaded successfully. File /var/archives/myserver.com-mysql-nextcloud.20180118.sql.bz2 uploaded successfully. File /var/archives/myserver.com-var-www-nextcloud.20180118.tar.gz uploaded successfully. File /var/archives/index-20180118-1 uploaded successfully. Cleaning remote directory through SSH Purging /home/backups/myserver.com/myserver.com-mysql-mysql.20180118.sql.bz2 Purging /home/backups/myserver.com/myserver.com-mysql-nextcloud.20180118.sql.bz2 File /var/archives/myserver.com-etc.20180118.tar.gz uploaded successfully. File /var/archives/myserver.com-mysql-mysql.20180118.sql.bz2 uploaded successfully. File /var/archives/myserver.com-mysql-nextcloud.20180118.sql.bz2 uploaded successfully. File /var/archives/myserver.com-var-www-nextcloud.20180118.tar.gz uploaded successfully. File /var/archives/index-20180118-1 uploaded successfully. Cleaning remote directory through SSH Purging /home/backups/myserver.com/myserver.com-mysql-mysql.20180118.sql.bz2 Purging /home/backups/myserver.com/myserver.com-mysql-nextcloud.20180118.sql.bz2 Process finished at 2018-01-18 15:59:40

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/sukria/Backup-Manager/issues/110#issuecomment-358673082, or mute the thread https://github.com/notifications/unsubscribe-auth/AAGbCXo5kH1CojK-4P7JfnZhMHyREemLks5tL10JgaJpZM4Ri_j8 .

loranger commented 6 years ago

You were right, the TTL was set to 0. It's weird the tar.gz files remained whereas the other files were removed as soon as the were uploaded.

Thank you for your support @sukria !