How to Export MySQL Database Using Command Line in Ubuntu

Manual PhpMyAdmin Interface For Export

MySQL Export Database via Interactive Mode

Export Data From MySQL Specific Table

$ mysqldump -u {username} -p {database_name} {table_name} > {file_path}
$ mysqldump -u root -p db_management tbl_roles > /var/www/html/dbt/roles.sql

Export Compete database From MySQL

$ mysqldump -u {username} -p {database_name} > {file_path}
$ mysqldump -u root -p db_management > /var/www/html/dbt/data.sql

Learn More on MySQL

--

--

--

Online Web Tutor is web development community found by Sanjay Kumar. It provides web development course for free worldwide by professionally trained instructors

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Creating and Managing a 1,000+ User Active Directory Using Oracle VirualBox and PowerShell

CSS Conflict Resolution Rules Explained

Zimbra Account Export / Import

Build array from permutation

Simple approach to unit testing

2017…. The New Hope

Measurement Could Also Use A Proxy

What’s new in Leanback: Part 2

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Online Web Tutor

Online Web Tutor

Online Web Tutor is web development community found by Sanjay Kumar. It provides web development course for free worldwide by professionally trained instructors

More from Medium

How to Create login, register, and logout manually in laravel.

XAMPP — MySQL shutdown unexpectedly

Remove/Hide Columns While Export Data In Datatable

Laravel Secure Rest API with Swagger