How to export MySQL database using Command Line

Taking the backup of the database is necessary whether it small or large project. You can easily revert the database if something went wrong.

Using phpMyAdmin you can easily export your MySQL database.

You can also Command Line to export selected MySQL database.

In this tutorial, I am using XAMPP in windows.

How to export MySQL database using Command Line


Contents

  1. Export Database
  2. Conclusion

1. Export Database

  • I am exporting tutorial database using Command Line.

How to export MySQL database using Command Line

  • For this open Command Prompt.
  • Navigate to xampp/mysql/bin directory.

How to export MySQL database using Command Line

  • Execute following command –

Syntax – 

mysqldump -u username -p database-name > export-file-name.sql

username – MySQL username.

database-name – Database name which you want to export.

export-file-name.sql – Specify you export file name.

Example –

mysqldump -u root -p tutorial > tutorial.sql

Here, I am exporting tutorial database and set export file name – tutorial.sql.

It will ask for a password.

Enter the user password if you have defined otherwise press enter.

A new SQL file will create in the xampp/mysql/bin/ directory.

How to export MySQL database using Command Line


2. Conclusion

You can either export your MySQL database using phpMyAdmin or Command Line.

The SQL file stored in xampp/mysql/bin/ directory if you have used the command line.

With Command Line you can also import SQL file in your MySQL database.

If you found this tutorial helpful then don't forget to share.

Spread the love
  • 8
  •  
  •  
  •  
  •  

Be First to Comment

Leave a Reply

Your email address will not be published. Required fields are marked *