Bug #44071 Progress should be shown in mysqldump
Submitted: 3 Apr 2009 8:37 Modified: 4 Jan 2013 5:06
Reporter: Andrew Hutchings Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: mysqldump Command-line Client Severity:S4 (Feature request)
Version: OS:Any
Assigned to: Assigned Account CPU Architecture:Any
Tags: Contribution

[3 Apr 2009 8:37] Andrew Hutchings 
Description:
mysqldump should show its progress so that on large tables people have a good idea of how long the dump will take.

How to repeat:
normal usage of mysqldump

Suggested fix:
This new patch has an extra parameter --show-progress-size which by default is set to 10,000.  So when --verbose is used, every 10,000 lines you will get a status output of the number of rows for a particular table dumped.  So what you should see is something along these lines:

shell> mysqldump -A --verbose >out.sql
-- Connecting to localhost...
-- Retrieving table structure for table testing...
-- Sending SELECT query...
-- Retrieving rows...
-- 10000 of ~94347 rows dumped for table `testing`
-- 20000 of ~94347 rows dumped for table `testing`
-- 30000 of ~94347 rows dumped for table `testing`
-- 40000 of ~94347 rows dumped for table `testing`
...

shell> mysqldump -A --show-progress-size=1500 --verbose >out.sql
-- Connecting to localhost...
-- Retrieving table structure for table testing...
-- Sending SELECT query...
-- Retrieving rows...
-- 1500 of ~94347 rows dumped for table `testing`
-- 3000 of ~94347 rows dumped for table `testing`
-- 4500 of ~94347 rows dumped for table `testing`
-- 6000 of ~94347 rows dumped for table `testing`
[3 Apr 2009 8:38] Andrew Hutchings 
Patch to apply feature to 5.1.30

Attachment: MySQL-5.1.30-dump-progress-2.0.diff (application/octet-stream, text), 3.80 KiB.
[27 Mar 2010 1:18] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/104496

3128 Andrew Hutchings	2010-03-27
      Bug #44071	Progress should be shown in mysqldump
      
      This new patch has an extra parameter --show-progress-size which by default is set to
      10,000.  So when --verbose is used, every 10,000 lines you will get a regular status 
      output of the number of rows for a particular table dumped.