Technology

How to import MySQL dump using cli

Single command to import MySQL dump

Make 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.