Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.w22.dev/llms.txt

Use this file to discover all available pages before exploring further.

MySQL UI lets you export any table or your entire database as a standard SQL dump file. The exported file is compatible with MySQL and can be used to back up your data, migrate to another server, or share your schema with a teammate.

​
Opening the export dialog

There are two ways to start an export, depending on how much you want to include: Entire database — In the sidebar toolbar, click the Download (↓) icon. This opens the export dialog with all tables in the current database pre-selected. Single table — Open a table, then click the ⋮ menu in the table toolbar and select Export table. The export dialog opens with only that table selected.

​
Export options

​
Tables

When exporting the whole database, you can check or uncheck individual tables to include or exclude them from the dump.

​
Mode

Choose what the dump file will contain:
ModeWhat’s included
Structure onlyCREATE TABLE statements — no row data
Data onlyINSERT INTO statements — no table definitions
Structure & data (default)Both CREATE TABLE and INSERT INTO statements

​
What the output file contains

The downloaded .sql file is structured as follows:
  • A header comment with the export mode and timestamp
  • SET FOREIGN_KEY_CHECKS = 0 at the top to allow tables to be created in any order
  • For each exported table:
    • DROP TABLE IF EXISTS to safely overwrite the table on import
    • CREATE TABLE (if structure is included)
    • INSERT INTO statements with rows batched 100 per statement for efficiency (if data is included)
  • SET FOREIGN_KEY_CHECKS = 1 at the end to re-enable constraint checking
Use Structure only to copy your schema to a new server without transferring any rows. Once the schema is in place, run a separate Data only export to move the data — this is especially useful for large tables where you want more control over the migration.
The file is downloaded immediately to your browser’s default downloads folder as a .sql file. The filename includes a timestamp and the database or table name, for example 2026-05-05-1430 mydb-both.sql.