Создание и восстановление заархивированного дампа SQL

MySQL

mysqldump -u USER -p DATABASE | gzip > /path/to/outputfile.sql.gz
gunzip < /path/to/outputfile.sql.gz | mysql -h localhost -u USER -p DATABASE

1 2	mysqldump -u USER -p DATABASE \| gzip > /path/to/outputfile.sql.gz gunzip < /path/to/outputfile.sql.gz \| mysql -h localhost -u USER -p DATABASE

PostgreSQL

pg_dump DATABASE | gzip >/path/to/outputfile.sql.gz
gunzip < /path/to/outputfile.sql.gz | psql -h localhost DATABASE

1 2	pg_dump DATABASE \| gzip >/path/to/outputfile.sql.gz gunzip < /path/to/outputfile.sql.gz \| psql -h localhost DATABASE