How to monitor the Restore progress in MySQL or MariaDB – MariaDB Tutorial

How to monitor the Restore progress in MySQL or MariaDB

Scenario:
You are working as MySQL/ MariaDB database administrator. You need to restore / import large backup file to database and would like to monitor the progress of restore. Which tools you can use to monitor the restore progress in MySQL / MariaDB?

Solution:
In our backup monitor progress posts, we mentioned that you need to install PV (Pipe Viewer). Check the link here.
Once the PV is installed you can use below command to import / Restore and monitor progress.

link to script used in the video
http://www.techbrothersit.com/2018/10/how-to-monitor-restore-progress-in.html