LaravelCode

Search

How to Import SQL Files into a MySQL database using Command Line

MySql
3113 views 2 years ago
post-title

In this article, I will share with you how to import multiple SQL files in the database at the same time using a command line. many developers don't know how the import more than one file at the same time using the command line in ubuntu. so, here I will share one trick for this problem.

If you have multiple SQL files in one folder and you want to import that all at the same time so, no need to waste your time. please follow the simple steps.

Merge all file into one file

First, we need to merge that all SQL files into one single file using the below ubuntu command.

cat *.sql  > all_files.sql

then import that file in your selected database using the following command.

Login mySql

sudo mysql -u root -p

then hit the Enter and put your MySQL password.

Select Database

use your_database_name

Import selected SQL file

source path_your_sql_file

i hope you like this article.

Random Articles
  • How to Make a Redirect in PHP
    Use the PHP header() Function You can simply use the PHP header() function to redirect a user to a different page. The PHP code in the following example will redirect the user from the page in w...
  • How to access laravel pagination protected object property?
    Hello, everyone in this tutorials i will share with you something small but very helpful programing tricks, how to acces laravel pagination protected object property. recently i was work one larave...
  • Laravel orderBy on Eloquent Relationships example
    Laravel eloquent relationships provides easy way to get relationships data with main table. But sometimes you need to get relationships data with specific column orderBy. In this article, I will sh...
  • Laravel 8 Eloquent whereNotBetween query example
    Laravel eloquent method whereNotBetween is contrary of whereBetween method. When you may want to get records for a field value not between two values. For example, you want to get users which doe...
  • What is Content Spoofing and how to prevent it
    In this article, we will discuss about what is Content Spoofing, how it will affect your website and business, and how to prevent Content Spoofing. what is Content Spoofing? Content Spoofing or...
Advertise