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

Posts to Review:

MYSQL Partitioning : What is and HOW To ? mysql concat function How MySQL Optimizes WHERE Clauses General Security Guidelines – MySQL Security