Table of Contents
In development, some times import and export to mysql database table is seems to be easier when you are a system admin. But in most of the cases we always prefer the UI tool of PhpMyAdmin to import and export data.
Just think at some situation when we don’t have any browser to open PhpMyAdmin or any softwares available to open MySQL, How we do import & export data to MySQL ?
In this case, we will use the concept of MySQL interactive Mode i.e MySQL Command Line Interface. Inside this article we will cover the complete understanding over commands of MySQL Import And Export Data via Interactive Mode.
Let’s get started.
Import & Export Using PhpMyAdmin Manual Interface
As we have two options available to import and export data in MySQL. Options are –
- Manual Interface of PhpMyAdmin
- Using Command Line of MySQL
Import Data To MySQL

As in the image we can see, we are going to import data to a database named as “cloud”. So when we scroll down this page, we will see we have several different different formats available to upload data.
Export Data From MySQL

This is all about using Manual Tool of PhpMyAdmin Interface to interact with MySQL. Let’s see by using Command Line.
MySQL Import And Export Data via Interactive Mode
Inside this case we are going to use terminal and few commands of mysql to use MySQL interactive mode.
Also here as well we have multiple options to choose file formats for import and export as well. We will use .sql to understand.
Import data to MySQL Table
Syntax: mysql -u {username} -p {database_name} < {file_path}
Example: mysql -u root -p db_management < /var/www/html/dbt/data.sql
When you press enter you need to pass password and then data will be automatically import to your selected database.
Export Data From MySQL Specific Table
Syntax: mysqldump -u {username} -p {database_name} {table_name} > {file_path}
Example: mysqldump -u root -p db_management tbl_roles > /var/www/html/dbt/roles.sql
Table data will be exported to roles.sql file and saved to the specified path.
Export Compete database From MySQL
Syntax: mysqldump -u {username} -p {database_name} > {file_path}
Example: mysqldump -u root -p db_management > /var/www/html/dbt/data.sql
We hope this article helped you to learn about Import & Export data From MySQL Using Command Line in a very detailed way.
If you liked this article, then please subscribe to our YouTube Channel for PHP & it’s framework, WordPress, Node Js video tutorials. You can also find us on Twitter and Facebook.
Hi, I am Sanjay the founder of ONLINE WEB TUTOR. I welcome you all guys here to join us. Here you can find the web development blog articles. You can add more skills in web development courses here.
I am a Web Developer, Motivator, Author & Blogger. Total experience of 7+ years in web development. I also used to take online classes including tech seminars over web development courses. We also handle our premium clients and delivered up to 50+ projects.