By: Adrian Ambroziak

Adrian Ambroziak — Fri, 16 Feb 2024 12:26:57 +0000

Correct the script:

#!/bin/bash
while true; do
if [ -f /proc/14547/io ]; then
  bytes_progress=$(awk '/^rchar/ {print $2}' /proc/14547/io)
  bytes_total=$(wc -c < /home/zabbix/backup/2024-02-15/zabbix-db-backup.sql)
  progress=$(awk -v bp="$bytes_progress" -v bt="$bytes_total" 'BEGIN {printf "%.2f", ((100 * bp)/bt)}')
  echo "Progress: $progress%"
  sleep 5
else
  break
fi
done

#!/bin/bash

while true; do

if [ -f /proc/14547/io ]; then

bytes_progress=$(awk '/^rchar/ {print $2}' /proc/14547/io)

bytes_total=$(wc -c < /home/zabbix/backup/2024-02-15/zabbix-db-backup.sql)

progress=$(awk -v bp="$bytes_progress" -v bt="$bytes_total" 'BEGIN {printf "%.2f", ((100 * bp)/bt)}')

echo "Progress: $progress%"

sleep 5

else

break

done

Why? Because yours returns error:

awk: cmd. line:1: BEGIN {printf %.2f, ((100 * 6298411098)/8887256730)}
awk: cmd. line:1:               ^ syntax error

1 2	awk: cmd. line:1: BEGIN {printf %.2f, ((100 * 6298411098)/8887256730)} awk: cmd. line:1: ^ syntax error

By: Jignesh Chauhan

Jignesh Chauhan — Mon, 07 Aug 2023 10:10:46 +0000

Thanks for sharing this information! Really helpful.

By: Vishal Saxena

Vishal Saxena — Thu, 03 Aug 2023 14:54:04 +0000

Little optimization on statement bytes_total=$(cat <BACKUP_FILE> | wc -c) is slower than bytes_total=$(wc -c <BACKUP_FILE>|awk '{print $1}')

Comments on: How to Monitor Your MySQL Database Restore Progress

By: Adrian Ambroziak

By: Jignesh Chauhan

By: Vishal Saxena