Mysqldump don't run

Discussion in 'Installation/Configuration' started by Marcio Urakawa, May 28, 2022.

  1. I noticed that through the Ispconfig interface, the backup gives an error when executing to backup the database.

    Running server.sh
    Code:
    mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = 'dbsite01'': Cannot load from mysql.proc. The table is probably corrupted (1728)
    28.05.2022-08:35 - ERROR - Failed to make backup of database dbsite01, because mysqldump failed
    When I do mysqldump manually, the .sql is generated normally.

    MariaDB 10.5.15
    Debian 11
    ISPConfig 3.2.8p1
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    Check that the mysql root password in /usr/local/ispconfig/server/lib/mysql_clientdb.conf is correct and in case it contains some fancy special chars that might cause issues in shell scripts, try using a different password.
     
    Marcio Urakawa likes this.
  3. Yes, the root password in that file is correct. Invlusive manually I can perform mysqldump

    Passwords contais: & @ # numbers and alphabets
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    That should be fine.

    And neither the ispconfig cron.sh nor server.sh cronjobs are commented out in root crontab?
     
    Marcio Urakawa likes this.
  5. No, only when I run server.sh
     
  6. I Solved.

    Code:
    mysql_upgrade -u root -p
     
    Jesse Norell likes this.

Share This Page