Whenever I'm in the middle of a "big" transformation, at some (random) moment the connection between Pentaho and MySQL is reset and I need to start all over again.
Is there any way to prevent this error or at least continue the transformation where it left off?
I tried running the transformation again trying to get it to the end.
The answer for the Pentaho Community Edition is No. However, for the Pentaho Enterprise edition, you have the ability to restart the job where it was last run using Checkpoints. The details of which are available in the below links: