I have a new Ubuntu Server 26.x install running PHP 8.5 and MySQL 8.4.10 (ubuntu 26) with no issues (XF 2.3.11). I'm using Claude AI to help with creating a backup script and we keep iterating as one particular forum of 5 typically fails with an 'Error 1412: Table definition has changed, please retry transaction when dumping table...' so we're reacting to each different table (such as xf_attachment_view and other _view's) that comes up as changed. Here is my script if someone can please provide an update on a better backup script that works better with XenForo please? Thank you.
BACKUP_FILE="$BACKUP_PATH/$DATE-$db.gz" log "Backing up: $db (gzip compressed)" mysqldump -u "$DB_USER" -p"$DB_PASSWORD" \ --single-transaction \ --no-tablespaces \ --skip-lock-tables \ --ignore-table="$db.xf_mg_album_view" \ --ignore-table="$db.xf_rm_resource_view" \ --routines \ --triggers \ --default-character-set=utf8mb4 \ "$db" 2>>"$LOG" | gzip -c > "$BACKUP_FILE" DUMP_STATUS=${PIPESTATUS[0]}