How to import MySQL dump using cli
Single command to import MySQL dumpMake sure MySQL is available from your terminal. If not add MySQL to the path.
mysql -u root -p the_database_name < the_sql_file_name.sql
This command will import large files into the database without server timeouts. Make sure to clear the database before importing the data.