How to Import Database in Mysql using Command Line in 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....