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