Created by bansiLinked to 25.1m issues across 76 teams
First, make sure you have the full path of the SQL file
file.sql. It is important to use the full path to ensure the file is imported correctly.
Next, open the command line and type in the following command:
`mysql -u username -p database_name < file.sql`
This command will import the SQL file into the specified database.
If you want to keep the routines and triggers of the original database, use the
--triggers options with
If the database does not exist yet, you may have to create it from MySQL before you can import the SQL file. To do this, make sure the exported SQL does not contain the
CREATE DATABASE command (exported with
Once you have followed these steps, you should be able to successfully import an SQL file using the command line in MySQL.