MySQL - Scheduled backup doesn't work

  • I create a scheduled backumoption with the MYSQL plugin but the cronjob have an error.


    and the details:


    Whats wrong?
    If you need more information just write it

    omv 6.x | 64 bit | omvextrasorg 6.x |
    used plugins: omv-extras | portainer | rsnapshot | antivirus
    used container: portainer/portainer | nextcloud/all-in-one | linuxserver/swag | paperless-ngx | jellyfin/jellyfin | lmscommunity/logitechmediaserver | adguard/adguardhome |

    • Offizieller Beitrag

    Probably a difference between mysql and mariadb. Which are you using? dpkg -l | grep -E "mysql|mariadb"

    omv 7.0.4-2 sandworm | 64 bit | 6.5 proxmox kernel

    plugins :: omvextrasorg 7.0 | kvm 7.0.10 | compose 7.1.2 | k8s 7.0-6 | cputemp 7.0 | mergerfs 7.0.3


    omv-extras.org plugins source code and issue tracker - github


    Please try ctrl-shift-R and read this before posting a question.

    Please put your OMV system details in your signature.
    Please don't PM for support... Too many PMs!

  • Probably a difference between mysql and mariadb. Which are you using? dpkg -l | grep -E "mysql|mariadb"

    my output:


    Code
    ii  mariadb-client-10.1              10.1.26-0+deb9u1               amd64        MariaDB database client binaries  
    ii  mariadb-client-core-10.1         10.1.26-0+deb9u1               amd64        MariaDB database core client binaries
    ii  mariadb-common                   10.1.26-0+deb9u1               all          MariaDB common metapackage                     
    ii  mariadb-server                   10.1.26-0+deb9u1               all          MariaDB database server (metapackage depending on the latest version)
    ii  mariadb-server-10.1              10.1.26-0+deb9u1               amd64        MariaDB database server binaries                                
    ii  mariadb-server-core-10.1         10.1.26-0+deb9u1               amd64        MariaDB database core server files                              
    ii  mysql-common                     5.8+1.0.2                      all          MySQL database common files, e.g. /etc/mysql/my.cnf             
    ii  openmediavault-mysql             4.1.1                          all          MySQL plugin for OpenMediaVault.                                                  
    ii  php7.0-mysql                     7.0.27-0+deb9u1                amd64        MySQL module for PHP

    omv 6.x | 64 bit | omvextrasorg 6.x |
    used plugins: omv-extras | portainer | rsnapshot | antivirus
    used container: portainer/portainer | nextcloud/all-in-one | linuxserver/swag | paperless-ngx | jellyfin/jellyfin | lmscommunity/logitechmediaserver | adguard/adguardhome |

    • Offizieller Beitrag

    Yep, it has something to do with the difference between mariadb and mysql. Probably the fact that maria configs are read before mysql configs in /etc/. I don't have time to look at this any time soon though.

    omv 7.0.4-2 sandworm | 64 bit | 6.5 proxmox kernel

    plugins :: omvextrasorg 7.0 | kvm 7.0.10 | compose 7.1.2 | k8s 7.0-6 | cputemp 7.0 | mergerfs 7.0.3


    omv-extras.org plugins source code and issue tracker - github


    Please try ctrl-shift-R and read this before posting a question.

    Please put your OMV system details in your signature.
    Please don't PM for support... Too many PMs!

  • okay, thank you @ryecoaaron for the information

    omv 6.x | 64 bit | omvextrasorg 6.x |
    used plugins: omv-extras | portainer | rsnapshot | antivirus
    used container: portainer/portainer | nextcloud/all-in-one | linuxserver/swag | paperless-ngx | jellyfin/jellyfin | lmscommunity/logitechmediaserver | adguard/adguardhome |

Jetzt mitmachen!

Sie haben noch kein Benutzerkonto auf unserer Seite? Registrieren Sie sich kostenlos und nehmen Sie an unserer Community teil!