More than 3 years have passed since last update.

mysqldumpの結果をimportするときに進捗率を知りたい

Linux
command
shell
mysqldump

Posted at 2021-03-01

以下のようにpvコマンドを使うとどれくらいの進捗か分かるので便利。

 pv < dump_result.gz | zcat | mysql -u root database_name -p

 145MiB 0:05:38 [ 776kiB/s] [===========================================>  
                                                     ] 45% ETA 0:06:45 ] 43% ETA 0:07:07                         ] 42% ETA 0:07:09

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up