Log how long a import takes

[Rod Rayner]

Hi,

We need to run a test import before doing things in our live environment but need to know how long the import takes.

The file 10Gb at Max compression, when uncompressed its around 170 Gb. In the past when we have run tests it has taken around 9 hours which is too long to sit in front of a PC and watch :-)

Is there a way to log how long the import takes / when it finished.

I am aware of "show table status;" but we are unsure what the last table is called so this kind of doesn't help.

Thanks in advance.