show progress on MySQL DB Import

You can use Pipe Viewer to monitor mysql dump. If you don’t already have pv, you can install it with:

yum install pv

# pv db1.sql.gz | gunzip | mysql -u root -p db1
  693MiB 1:00:33 [ 325kiB/s] [====================>              ] 68% ETA 0:16:20




 

 

Leave a Reply