How do I get % progress for "type db.sql | mysql"
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 !!!