How to Export Mysql Database using Command Line in Ubuntu?

Now, let’s see post of how to export mysql database using command line in ubuntu. i explained simply about how to export mysql database using command line. you can see importing mysql database using command line. you can understand a concept of mysql export database via command line.

When you have large size of database then you can not easily export 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 export large size database using command in ubuntu.

Syntax:

mysqldump -u username -p database_name > data-dump.sql

Example:

mysqldump -u root -p laravel > laravel_dump.sql

i hope it can help you….

Leave a Comment