In MySql Workbench version 8.0 you can just follow the next steps
- Go to Server tab
- Go to Database Export
This opens up something like this
- Select the schema to export in the Tables to export
- Click on Export to Self-Contained file
- Check if Advanced Options… are exactly as you want the export
- Click the button Start Export