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

Please Disable Your Browser Adblock Extension for our site and Refresh This Page!

our ads are user friendly, we do not serve popup ads. We serve responsible ads!

Web tips, snippets & code sharing

On November 11, 2020 . By CodimTh

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

Comments

Add new comment

Riadh Rahmi

Senior Web Developer (Drupal & Laravel)

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

Recent comments

Recent content

Disable cache for a block in Drupal 8

Create and Apply Patches using GIT DIFF and APPLY

How To Use Batch API in Drupal 8 & 9

How to change canonical URL programmatically in drupal 8 & 9

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

Dependent select dropdowns using #ajax in node add/edit form 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

How to create custom contextual links programmatically in drupal 8 & 9

How to add a html field to a form in drupal 8 & 9

How to redirect an anonymous user to the login form after a 403 error in Drupal 8 & 9

How to redirect anonymous user in Drupal 8 & 9

How to get all vocabularies in drupal 8 & 9