我如何gzip mysqldump的结果文件? [英] how can i gzip the result file of mysqldump?

问题描述

我希望将mysqldump的结果压缩成gzip，就像从phpMyAdmin中将其提取为gz文件一样.

我使用了以下命令:
mysqldump --add-drop-database = true -u用户名-ppassword -hlocalhost-数据库myDB | gzip> mysql.gz

但它不起作用.无法提取导致错误的结果文件:

---------------------------
错误
---------------------------
C:\ mysql.gz
档案格式不明或已损坏
---------------------------
OK
---------------------------

i want the result of mysqldump to be gzipped like extracting it as gz file from phpMyAdmin.

i used the following command:
mysqldump --add-drop-database=true -uusername -ppassword -hlocalhost --databases myDB | gzip > mysql.gz

but it does not work. the resulted file can not be extracted for the error:

---------------------------
Error
---------------------------
C:\mysql.gz
The archive is either in unknown format or damaged
---------------------------
OK
---------------------------

推荐答案

在之间插入-" gzip和重定向:

Insert a "-" between gzip and the redirect:

mysqldump --add-drop-database=true -uusername -ppassword -hlocalhost --databases myDB | gzip - > mysql.gz

-"告诉gzip从stdin中读取.

The "-" tells gzip to read from stdin.

这篇关于我如何gzip mysqldump的结果文件?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！