I really like pv especially for large database imports, e.g.: pv /tmp/database.sql | mysql -uuser -p db (in screen or tmux of course :) ) Kevin On 2026-08-21 11:47, William Park via Talk wrote:
- man pv - https://www.youtube.com/watch?v=gwQH-db60WU&t=576s ------------------------------------ Description: GTALUG Talk Unsubscribe via Talk-unsubscribe@lists.gtalug.org Start a new thread: talk@lists.gtalug.org This message archived at https://lists.gtalug.org/archives/list/ talk@lists.gtalug.org/message/F25EDOXWPUEOUUWCAUSKHGSRZRFGFZJJ/
On Fri, 21 Aug 2026 at 11:49, William Park via Talk <talk@lists.gtalug.org> wrote:
- man pv - https://www.youtube.com/watch?v=gwQH-db60WU&t=576s
I don't use it often (because it's awkward to insert, awkward to remember the syntax, etc.) but if you're working with a huge chunk of data and you know it's going to take a long time, `pv` is a huge help in telling you just how far that process has got. Part of the pain of using it is you have to tell it in advance how much data it's transferring if you want to see a percentage indicator instead of just a byte count: time dd if=/dev/sde | pv -s 30G | dd of=/home/giles/pi.img bs=4M Re-reading the man page, `-s` (note - lower case "s", upper case "S" does something more terminal) takes an "@" parameter to grab the file size from the named file ... read up about it. Not sure it would work on a device as in the above example. -- Giles https://www.gilesorr.com/ gilesorr@gmail.com
participants (3)
-
Giles Orr -
Kevin Glendenning -
William Park