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 get image field with style in preprocess node in Drupal 8 & 9

How to redirect anonymous users to login page in drupal 8 & 9

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

How to render a button in drupal 8 & 9

How to get site name programmatically in drupal 8 & 9

How to fix "non-existent config entity name" in Drupal 8 & 9

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

How to create dynamic layouts using derivatives in Drupal 8 & 9

How To Use Batch API in Drupal 8 & 9

How to register custom layout with annotations in Drupal 8 & 9

How to create custom layouts in Drupal 8 & 9

How to add custom settings to layouts in Drupal 8 & 9

Select only the columns you need in Laravel

Laravel Job Property of Non Object

How to display the size of a file in Drupal 8 & 9

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