How do I get % progress for "type db.sql | mysql" I am doing:

type db.sql | mysql


and the console output is nothing. I see the ibdata1 file growing, but I don't know how many GB it will grow to.

I would like to see a % progress indicator of some kind. Any ideas?
Have I got a crazy query for you !!!

This will report on the size of every InnoDB table.

SELECT CONCAT(db,'.',tb) table_name,CONCAT(ROUND(
tbsz/POWER(1024,IF(pw&lt;0,0,IF(pw&gt;4,4,pw))),3),' ',
SUBSTR(' KMGT',IF(pw&lt;0,0,IF(pw&gt;4,4,pw))+1,1)) table_size
FROM (SELECT data_length+index_length tbsz,table_schema db,table_name tb
FROM information_schema.tables WHERE engine='InnoDB') A,
(SELECT 3 pw) B;



(SELECT 0 pw) give Bytes
(SELECT 1 pw) give KB
(SELECT 2 pw) give MB
(SELECT 3 pw) give GB
(SELECT 4 pw) give TB


Just run this periodically during the loading of the SQL script. If the SQL script table locks the table during the load, then you will not see numbers until the table is fully loaded.

Give it a Try !!!