Import and export MySQL data
Export MySQL and MariaDB tables or query results; use the grid for paste-based input instead of an import assistant.
MySQL and MariaDB have an export workflow for tables and query results. The shared export dialog passes the selected scope, filters, sort order and database relation to the MySQL writer.
Export
- Open the export dialog from a table or result.
- Choose the scope: the full relation, filtered rows, selected rows or a result set.
- Choose CSV, JSON, JSON Lines, SQL, Markdown or XLSX.
- Review the preview and destination before starting the export.
SQL export uses MySQL-compatible statements. It supports INSERT, multi-row INSERT and upsert, while MySQL-specific options differ from PostgreSQL options. The writer can include the table structure when the source is a table; a query result has no source DDL to include.
Input
MySQL and MariaDB use paste into the grid for input: bring the values into the table surface, review the staged cells and save them with Ctrl+S. This is not a dump restore and it does not infer a migration from an arbitrary file.
Review the result
A query result can be exported without executing the query again. The result grid preserves the column labels it received, including repeated names, so the exported file reflects the result that was already displayed.
Use Ctrl+Z and Ctrl+Y for staged grid changes. Schema migration and database dumps remain outside the current MySQL surface.