dbTalk Databases Forums  

Progression bar with mysqldump

comp.databases.mysql comp.databases.mysql


Discuss Progression bar with mysqldump in the comp.databases.mysql forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Ewgenij Sokolovski
 
Posts: n/a

Default Progression bar with mysqldump - 05-13-2008 , 04:15 AM






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

Reply With Quote
  #2  
Old   
Captain Paralytic
 
Posts: n/a

Default Re: Progression bar with mysqldump - 05-13-2008 , 04:22 AM






On 13 May, 10:15, Ewgenij Sokolovski <ewgenij... (AT) compuserve (DOT) de> wrote:
Quote:
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.


Reply With Quote
  #3  
Old   
Ewgenij Sokolovski
 
Posts: n/a

Default Re: Progression bar with mysqldump - 05-13-2008 , 04:26 AM



Quote:
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.



Reply With Quote
  #4  
Old   
Captain Paralytic
 
Posts: n/a

Default Re: Progression bar with mysqldump - 05-13-2008 , 06:41 AM



On 13 May, 10:26, Ewgenij Sokolovski <ewgenij... (AT) compuserve (DOT) de> wrote:
Quote:
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?


Reply With Quote
  #5  
Old   
Ewgenij Sokolovski
 
Posts: n/a

Default Re: Progression bar with mysqldump - 05-14-2008 , 08:00 AM



Quote:
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.



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.