I've just read this answer on DBA about moving databases. It contains this sentence:
The only problem is when the database is too big and the pipe collapses.
which is about this pipeline:
mysqldump --all-databases -uuser -ppassword | mysql -hremoteserver -uremoteuser -premoteserver
The collapse is not described there. So my question here is how could a pipe collapse? (In this case and in general.) With Linux in focus, but other Unices are welcome as well.