pantheon-tools icon indicating copy to clipboard operation
pantheon-tools copied to clipboard

Pipe Viewer causes write error when dumping a database if not installed.

Open cbfannin opened this issue 8 months ago • 0 comments

If a user of pantheon-tools does not have pipe viewer installed when running the pantheon-db-dump command (may need to check other commands) you receive the error: mysqldump: Got errno 0 on write

This is because pipe viewer information is passed to the $PV variable to the dump command: mysqldump --no-autocommit --single-transaction -B --opt --quote-names --user=$mysql_username --host=127.0.0.1 --port=$mysql_port --password=$mysql_password $mysql_database | $PV

Possible solutions:

  • Check to see if pipe viewer is installed and don't pass pipe viewer data to the command. (maybe prompt the user that if pipe viewer is installed that they would see this data).
  • Check to see if pipe viewer is installed and fail early with a prompt to install pipe viewer.

Pipe viewer info: https://www.ivarch.com/programs/pv.shtml

cbfannin avatar Oct 27 '23 15:10 cbfannin