How to import large data on MySQL

If you have a large data, and you want to import that data to let's say an empty database, you will have a hard time doing it with phpmyadmin or mysql workbench.