In this Post, we will see how to export MySQL database using MySQLDump through command line.
Steps to export MySQL database using MySQLDump
- Before performing below steps please make sure you have put entry of your MySQL in your System path variable. If you have configured MySQLPath then you can directly call mysqldump command, otherwise you have to go to location of your installed MySQL.
- Open command line interpreter with “Run as administrator“. Make sure you open cmd as administrator, otherwise mysqldump will throw Access Denied error.
- You can type below MySQLDump command to take the backup of your database.
mysqldump -u username -p db_name > your_choice_dbname.sql
here
mysqldump
is keyword.username
is the username of the mysqldb_name
is the name of the database you want to export.your_choice_dbname
is any name of your choice.
- In our case, username is root. db_name is employee. your_choice_dbname is exportEmp, so we will execute following command
mysqldump -u root -p employee > exportEmp.sql
After executing this command, MySQL will ask for password. put the password and your database will be exported to in your MySQL bin folder
- If you want to export MySQL database at specific location then you can also do that.
mysqldump -u root -p employee > C:\demo\ExportEmp.sql
Now ExportEmp.sql will be exported to the location c:\demo\
So finally we have exported the MySQL database using mysqldump.