ItSolutionStuff.com

How to Import Database in Mysql using Command Line in Ubuntu?

By Hardik Savani • May 1, 2024
MySql Ubuntu

Hi,

This article will provide some of the most important example how to import database in mysql using command line in ubuntu. this example will help you how to import database in mysql command line in ubuntu. you can see import mysql database command line ubuntu. step by step explain import mysql database using command line ubuntu. You just need to some step to done how to import database in mysql using command line in ubuntu.

When you have large size of database then you can not easily import from phpmyadmin or any other software. so you must have to use mysql commands for it. so here i will give you simple command to import large size database using command in ubuntu.

Syntax:

mysql -u username -p new_database < data-dump.sql

Example:

mysql -u root -p laravel < laravel_dump.sql

i hope it can help you....

Hardik Savani

Hardik Savani

I'm a full-stack developer, entrepreneur, and founder of ItSolutionStuff.com. Passionate about PHP, Laravel, JavaScript, and helping developers grow.

📺 Subscribe on YouTube

We Are Recommending You

How to Install Yarn npm in Ubuntu?

Read Now →

How to Upgrade PHP Version from 7.3 to 7.4 in Ubuntu?

Read Now →

How to Enable Apache mod_rewrite Module in Ubuntu?

Read Now →

Laravel Join Query with Comma Separated Column Example

Read Now →

How to create quick apache virtual host in Ubuntu?

Read Now →

PHP Import Excel File into MySQL Database Tutorial

Read Now →

MySQL Calculate Age from Date of Birth Example

Read Now →

How to fetch this week records in MySql ?

Read Now →

How to count unique domains from email address field in MySQL ?

Read Now →

How to Get Query Log in Laravel Eloquent?

Read Now →

Which MySQL Datatype use for Store an IP Address?

Read Now →