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

Recent comments

Recent content

How to make cloning of Models in Laravel 8

How to make modification of a revision log field in drupal 8 & 9

How to test if a form is an entityForm in Drupal 9

How do I define checkboxes in a form in Drupal 9

How to get image field with image style in Drupal 8 & 9

How to get view mode of node in Drupal 8 & 9

Use configuration as cacheable dependencies in drupal 8 & 9

How to change the user password reset link timeout in Drupal 8 & 9

How to count query results of entityQuery in drupal 8 & 9

Add number field to form in drupal 8 & 9

Get the node ID value after submit a Webform attached to that node

How to change entity before it is created or updated.

How to check and change default front page programmatically in Drupal 8 & 9

Stay in same page after validation form in Drupal 8

Laravel - Validate the password reset token before showing the reset form

If you need some help or you search a Drupal freelancer don't hesitate to contact us.

All the content is FREE but I still need your help