E
E
ExtraQuality2013-12-23 11:03:27
MySQL
ExtraQuality, 2013-12-23 11:03:27

How to see mysql database dump operation completion percentage on Ubuntu 12.04?

Hello.
Now I'm dumping in this way:

mysqldump -u username-p db | gzip > /bla/bla/bla/db.sql.gz

But the downside is that I don't see the percentage of completion and can't understand what's going on (the size of the database is large, so I would like to see it in order to calculate my actions).
Please tell me if there is an additional parameter or another function that will display this.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
P
pomeo, 2013-12-23
@ExtraQuality

mysqldump -u username-p db | pv | gzip > /bla/bla/bla/db.sql.gz

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question