# Export and import

> For the complete documentation index, see [llms.txt](https://www.jetbrains.com/help/idea/2026.3/llms.txt).

Export and import

Learn how to import and export database objects, database data in various formats using data extractors, and how to work with dump files

- [Export](export-data.html): See how to generate DDL for objects and export data in different formats
- [Import](import-data.html): Import CSV, TSV, or any other text files that contain delimiter-separated values

## Full dumps

- [Create a full data dump for MySQL and PostgreSQL](export-data.html#create-a-full-data-dump-for-mysql-and-postgresql): Learn how to create a full dump
- [Restore a full data dump for MySQL and PostgreSQL](import-data.html#restore-a-full-dump-for-mysql-and-postgresql): Learn how to restore a full dump

## Format of exported and imported data

- [Data extractors](data-extractors.html): Learn about built-in extractors and how to create custom extractors

## Dialog reference

- [Import dialog](import-data.html#import_dialogs): Import dialogs