Backup failed due to mysql dump

eris · February 1, 2022, 11:16am

Check contents of /usr/local/data/users/user.conf

fatih · February 1, 2022, 11:29am

I just checked /usr/local/hestia/data/users/fatih/user.conf
It looks fine to me. What should I check specifically?
I believe the problem is in the last line in log: Error: Connection to localhost failed
I didn’t change database password lately, by the way.

fatih · February 1, 2022, 11:43am

Oops, my apologies.
I just remembered I changed the database charset lately, from utf8 to utf8mb4.

eris · February 1, 2022, 12:51pm

And it now works?

We do a check for the current database size in:

github.com

hestiacp/hestiacp/blob/83cfa9804d3346b42fa879ed6f40f7366767b904/bin/v-backup-user#L109-L122

    
      
          for database in $databases; do
              exclusion=$(echo "$db_exclusions" |tr ',' '\n' |grep "^$database$")
              if [ -z "$exclusion" ]; then
                  # Get database values
                  get_database_values
          
          
        # Switching on db type
                  case $DB_SYSTEM in
                      mysql) get_mysql_disk_usage ;;
                      pgsql) get_pgsql_disk_usage ;;
                  esac
                  u_usage=$((u_usage + usage))
              fi
          done

And for some reasons it fails to connect.

fatih · February 1, 2022, 5:15pm

@eris You are right. I deleted the exclusion, it works perfect now. Nothing wrong with utf8mb4.
Something weird is happening in the backup exclusion.

eris · February 1, 2022, 5:23pm

You had an backup exclusion active?

fatih · February 1, 2022, 5:27pm

Yes. I had backup exclusion: [files.********.com:public_html]
It was working fine before. Backup file is 1.2GB without exclusion. When I use the exclusion it is only 250MB.

system · March 3, 2022, 5:27pm

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.