Importing database in MySQL using command line
Importing a database in MySQL is quick & easy using the command line.
Published on August 30, 2022 · 1 minute read
Importing a MySQL database can be done in several ways, using a desktop app or even using the legendary phpMyAdmin!
But the most effective and fast way to import a (large) SQL file remains - as always - using the command line interface (CLI).
Using the command line
Using the command below you can import large SQL files in the least amount of time:
mysql -u [username] -p [database] < import.sql
import.sql with the correct values in your setup.
Subscribe to our newsletter
Do you want to receive regular updates with fresh and exclusive content to learn more about web development, hosting, security and performance? Subscribe now!