Number of rows in SQL dump Is there any way to check how many rows are in an SQL dump file? I have a large 32GB dump, and wanted to check how many rows are in the file.

I am using a windows machine with a MySQL server,

Thanks!
You should be safely calculate using wc -l filename.sql
On windows you may use following in command prompt: findstr /R /N "^" filename.sql | find /C ":"


As such not a part of question but out of intereset, you can also list content of the 32G dump using mysqldumpsplitter:
mysqldumpsplitter.sh --source filename --desc [More how-tos]