Pipe viewer command-line progress report
I’m sitting here waiting for a two and a half gigabyte MySQL dump file to make its way to the Amazon Cloud and basically the only way I have to monitor its progress is opening up a Sequel Pro window and wait for new databases to show up.
I thought I’d do a search on MySQL dump progress reports, and I found a neat little utility called pipe viewer that really ought to be standard on Mac OS X and Linux.
- pv Y2013M11D06.sql | wc
- 2.47GiB 0:00:11 [ 212MiB/s] [========================================================================>] 100%
- 98159 122143517 2648450403
It took about 11 seconds to complete, and as it completed the progress bar made its way across the window.
Note that I don’t have MacPorts or HomeBrew installed; a simple ./configure and make worked fine.
File this under: Why did I not already know about this!
- Pipe Viewer
- “Pipe Viewer is a terminal-based tool for monitoring the progress of data through a pipeline. It can be inserted into any normal pipeline between two processes to give a visual indication of how quickly data is passing through, how long it has taken, how near to completion it is, and an estimate of how long it will be until completion.”
- Sequel Pro
- “MySQL database management app for Mac OS X.” This is the easiest-to-use MySQL front-end I’ve seen. It includes features both for browsing your databases and limited features for managing the server.
More command line
- Caption this! Add captions to image files
- Need a quick caption for an image? This command-line script uses Swift to tack a caption above, below, or right on top of, any image macOS understands.
Remember: Trump reassures crowd after assassination attempt fails. (read more…)