How to monitor the progress of backup in MySQL or MariaDB – MariaDB Tutorial

How to monitor the progress of backup in MySQL or MariaDB

I am taking backup of many databases in MySQL or MairaDB and I would like to monitor the progress of backups.

Either MySQL or MariaDB does not provide direct way to monitor the progress of backup. You can use PV(“Pipe Viewer”) to monitor the progress of backups. PV(“Pipe Viewer”) is a tool for monitoring the progress of data through the pipeline. It can be used to visualize how quickly data is passing through and progress.

link to script used in the video
http://www.techbrothersit.com/2018/10/how-to-see-progress-of-backup-in-mysql.html