How to Export Mysql database to .sql file?

Install the mysql workbench 8.0 and follow the below steps after connecting to your database

Step1 : Below is the screen which you will get after connecting to your database instance. Highlighted is the schema which needs to be exported into a file (.sql file)


Step2 : Click on left tab “Administration” and then select the “Data Export”



Step3 : Select the database and files which you would like to export. Now select the file name and location and click Start Export

Leave a Reply

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