How to import large sql files into MySQL using the command line

Every time I need to import a large sql file inside my local database I get this error “You probably tried to upload a file that is too large. Please refer to documentation for a workaround for this limit.”.

PHPMyAdmin error: “You probably tried to upload a file that is too large. Please refer to documentation for a workaround for this limit.

One solution is to use the command line but, as usual, I forget the right command to execute. Here is why I’m publishing this, here, now…

mysql -h yourhostname -u username -p databasename < yoursqlfile.sql

To remember.