Click Export Data on the Database menu.
The appearance of the Data Export Wizard can differ depending on a product you use.
On the Source page, select a required MySQL server connection, a database, table(s), view(s), which you want to export, and then click Next.
If you opened the wizard from the data grid, the Source tab would allow to specify only a name and a path of the destination file (the one where the exported data will be saved.
There is a filter in the Data Export wizard window.
If you want to filter data, use the required column filter. To do this, firstly write a whole data query using the SELECT * FROM statement. Click the Execute button to implement the query. Then on the required column name, click the filter icon. In the drop-down list, choose the item to filter by. Right click the filtered grid, and select Export Data to call the Data Export wizard.
Another and the most reliable way to export filtered data is to filter it directly in the query. Execute the SELECT * FROM statement with the WHERE condition, where you can specify the required filter. And then implement already filtered data export with the Data Export wizard, calling it from the filtered grid shortcut menu.
Follow the Data Export wizard steps, click the Export button. If the data export is finished successfully, the Data export complete message appears.