问题原文
原帖链接 · Mcload · CC BY-SA 4.0
I have a database whose size is roughly 3.1 Gb according to PhpMyAdmin. I would like to dump and compress it with gzip.
This is a very similar answer to what I'm trying to do: https://serverfault.com/a/804273/326635
Here is my command:
mysqldump -u myuser -p mydb | gzip -9 -c > db.gz
It works, I got the gz file. But it is over 3 Gb so the compression doesn't seem to be working. What do I wrong, how can I get a smaller file with gzip?
已采纳解答
原帖链接 · Bert · CC BY-SA 4.0
The size of your mysqldump file is not going to be the same as your database size as reported by PHPMyAdmin.
First, create the dump file with the command:
mysqldump -u myuser -p mydb > dumpfile.sql
Record how large the file is. Then, compress the dump file with the command:
gzip -9 dumpfile.sql
Then compare the size of that new file.
摘自公开归档,保留原文语言,版式经整理,外部媒体与邮箱地址已移除。
