How do I import an SQL file using the command line in MySQL | CodimTh

Web tips, snippets & code sharing

Category:

How do I import an SQL file using the command line in MySQL

To import a single database, use the following command.

mysql -u username -p password dbname < dump.sql

To import multiple database dumps, use the following command.

mysql -u username -p password < dump.sql

Tags :

MySQL Database API

Riadh Rahmi

Senior Web Developer PHP/Drupal & Laravel

I am a senior web developer, I have experience in planning and developing large scale dynamic web solutions especially in Drupal & Laravel.

Recent comments

Recent content

Create paragraphs and attach to node programmatically in drupal 10

Dependent select dropdowns using #ajax in node add/edit form drupal 8 & 9

Provide token for media entities in Drupal 8 & 9

Create custom image token in drupal 8 & 9

How To Create A Custom Token In Drupal 8 & 9

How To Use Batch API in Drupal 8 & 9

How to use Batch API to do heavy processing in Drupal 8 & 9

Disable cache for a block in Drupal 8

Create and Apply Patches using GIT DIFF and APPLY

How to change canonical URL programmatically in drupal 8 & 9

How to Create a Custom Field Formatter in Drupal 8 & 9

Programmatically update an entity reference field in Drupal 8 & 9

How To pass parameter from node to webform with custom token In Drupal 8 & 9

How to create media entities and attach them to paragraphs in Drupal 8 & 9

How to attach paragraphs to node programmatically in drupal 8 & 9