How to load large size sql file into MySQL or MariaDB without opening it by using Heidi SQL

How to load large size sql file into MySQL or MariaDB without opening it by using Heidi SQL
demo explains
What are the issues to open large .sql files with Heidi SQL Tool
How you can run the large .sql files without opening in Heidi SQL Editor
How to monitor the progress of execution of large .sql files with Heidi SQL

Check out below link to follow step by step tutorial for MariaDB for beginner to Advance
http://www.techbrothersit.com/2018/06/mariadb-admin-dev-tutorial.html

This video can be used by people who want to get training as
MySQL Developer Tutorial
MySQL DBA Tutorial
MariaDB Tutorial / MariaDB Training free
MariaDB DBA Training step by step
Real time MySQL / MariaDB training