Error during Backup

[msksharma]

Hi,

I am getting this error while trying to run OTRS backup using the default script

root@otrs:/opt/otrs/scripts# ./backup.pl -d /mnt/synology/OTRS6/ -c gzip -t fullbackup
Backup /mnt/synology/OTRS6//2021-02-16_15-17/Config.tar.gz ... done
Backup /mnt/synology/OTRS6//2021-02-16_15-17/Application.tar.gz ... done
Dump MySQL data to /mnt/synology/OTRS6//2021-02-16_15-17/DatabaseBackup.sql.gz ... mysqldump: [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 2147483648
mysqldump: [Warning] Using a password on the command line interface can be insecure.
mysqldump: Error: 'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces
mysqldump: Error 2020: Got packet bigger than 'max_allowed_packet' bytes when dumping table `article_data_mime_attachment` at row: 21926
failed
Deleting incomplete backup /mnt/synology/OTRS6//2021-02-16_15-17 ... done
[Tue Feb 16 16:13:38 2021] backup.pl: Backup failed

Could u please advise on how to fix this?

Regards,
Krishna M S

[msksharma]

Hi,

I got it resolved by adding --no-tablespaces --max_allowed_packet=512M in the backup script.

The backup ran successfully.

Regards,
Krishna M S

[root]

I got it resolved by adding --no-tablespaces --max_allowed_packet=512M in the backup script.

Hi I recommend fixing this via proper configuration (~/.my.cnf or /etc/my.cnf.d/*) to keep it safe from updates.

- Roy

[ritacc]

Hi,
I have the same error when running backup.pl:
mysqldump: Error: 'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces

According to the previous post, I tried "/opt/otrs/scripts/backup.pl --no-tablespaces -d /home/otrs_backups", but it gave the same error. Should I add option "--no-tablespaces" in somewhere else? And if you can provide what to change in /etc/my.cof.d/ will be even better.

Thanks for your help!
Rita

I got it resolved by adding --no-tablespaces --max_allowed_packet=512M in the backup script.

Hi I recommend fixing this via proper configuration (~/.my.cnf or /etc/my.cnf.d/*) to keep it safe from updates.

- Roy

[skullz]

add --no-tablespace in backup.pl scripts itself (after mysqldump)

should be https://github.com/znuny/Znuny/blob/2fd ... up.pl#L130

[msksharma]

Hi,

I have a Test VM running with data which is older than 6 months back.

I want to restore the latest data without losing the configuration. Please suggest the best way?

Taking backup using --dbonly will only take backup of DB without attachments/articles

Regards,
Krishna M S