Online Documentation for SQL Manager for MySQL

Export filtered data


If you have set a filter in a Data View and want to export only this data then you need to uncheck CheckBox Perform data filtration on client in data view option on the Database Registration Info | Data Options tab. In this case all the changes made by applying filters are performed on the MySQL server with the help of the WHERE clause used in SQL query. Otherwise your changes will just be displayed on your client machine but data will be exported into a file without applied filters.