Progression bar with mysqldump

Hello, guys! Maybe somebody here would be able to answer my question.
I would like to know whether it's possible to couple mysqldump with a
progression bar in my application. The goal is to enable users of my
application to monitor the dump process while it is running - the
usual intention of a progression bar.

I didn't find anything about it in the internet and the manual of
MySQL, so I ask myself whether this is possible at all...

Best regards
Ewgenij

On 13 May, 10:15, Ewgenij Sokolovski <ewgenij...@compuserve.de> wrote:
> Hello, guys! Maybe somebody here would be able to answer my question.
> I would like to know whether it's possible to couple mysqldump with a
> progression bar in my application. The goal is to enable users of my
> application to monitor the dump process while it is running - the
> usual intention of a progression bar.
>
> I didn't find anything about it in the internet and the manual of
> MySQL, so I ask myself whether this is possible at all...
>
> Best regards
> Ewgenij

I guess it should be, up to a point. First of all you will have to run
some queries to estimate the size of the tables you are going to dump.
Then you will need to monitor the size of the file being written to
disk, updating the bar as you go.

> First of all you will have to run
> some queries to estimate the size of the tables you are going to dump.
> Then you will need to monitor the size of the file being written to
> disk, updating the bar as you go.

Hmm, that would be a straightforward solution:) But I thought that
maybe mysqldump provides a feedback functionality about processed
bytes... Some applications do.

On 13 May, 10:26, Ewgenij Sokolovski <ewgenij...@compuserve.de> wrote:
> > First of all you will have to run
> > some queries to estimate the size of the tables you are going to dump.
> > Then you will need to monitor the size of the file being written to
> > disk, updating the bar as you go.
>
> Hmm, that would be a straightforward solution:) But I thought that
> maybe mysqldump provides a feedback functionality about processed
> bytes... Some applications do.

Does the manual say it does?

> Does the manual say it does?

No, I didn't find anything about it:) But I thought, maybe there is
some trick to get it done... But, apparently, there is not.