大网数据广告活动
服务器运维问答

How to compress SQL file correctly on CentOS?

· 52CE 我爱测

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 co…

问题原文

原帖链接 · 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.

摘自公开归档,保留原文语言,版式经整理,外部媒体与邮箱地址已移除。

资料来源与适用范围

资料来源
Server Fault
适用范围
以原帖系统、软件版本与发布日期为准(2019-12-10)
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY-SA 4.0

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。