I always forget this so I'm going to save it here. This way I can import the SQL files directly in the terminal.
The following command will import the database:
<pre><code>mysql -u username -p database_name &lt; /file_path/file_name.sql
</code></pre>The above command does not import the triggers and procedures by default.
Use <code>-R</code> and <code>--triggers</code> flags to import the routines and triggers.
Export MySQL database with the below command:
<pre><code>mysqldump -u username -p database_name &gt; /file_path/file_name.sql
</code></pre>Thank you for reading!

I always forget this so I'm going to save it here. This way I can import the SQL files directly in the terminal.

The following command will import the database:

```
mysql -u username -p database_name < /file_path/file_name.sql
```

The above command does not import the triggers and procedures by default.

Use `-R` and `--triggers` flags to import the routines and triggers.

Export MySQL database with the below command:

```
mysqldump -u username -p database_name > /file_path/file_name.sql
```

Thank you for reading!

Import Export SQL file using the command line

Learn Javascript, Nest, Nextjs, React on Slashism.