Contents [hide]
We will learn how to export database dump file from MySQL database using MySQL Workbench.
Note: Prerequisite MySQL database and MySQL Workbench already installed in your system.
Need to follow below steps for export database dump from MySQL database using MySQL workbench.
Step 1: Open MySQL Workbench. Create new MySQL Connections. If it is not available.
Step 2: Open MySQL Connections.
Step 3: Select Administration. Click Data Export. Select Schema. Select any one below options:
a: Dump Structure and Data (If you want Structure and data both)
b: Dump Structure only (If you want Structure only)
c: Dump Data only (If you want Data only)
Select Export to Self-Contained File.
Click on Start Export Button.
Step 4: Now you can see the dump file exported successfully.
