> For the complete documentation index, see [llms.txt](https://docs.otherplanet.dev/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.otherplanet.dev/troubleshooting/database-export.md).

# Database export

### 📦 How to export your database (HeidiSQL / phpMyAdmin)

Database export is required when:

* we ask you to **send a database dump** for debugging
* you are **moving your server**
* you want to **create a backup before changes**

Below are two supported methods.

***

### ✅ Method 1: Export using phpMyAdmin

#### Steps

1. Open **phpMyAdmin**
2. Select your **database** from the left sidebar
3. Click the **Export** tab
4. Choose **Quick** export method
5. Format: **SQL**
6. Click **Export** and download the `.sql` file

📺 Video tutorial:

{% embed url="<https://www.youtube.com/watch?v=KmlyhiqoUtk>" %}

***

### ✅ Method 2: Export using HeidiSQL (recommended)

#### Steps

1. Open **HeidiSQL** and connect to your database
2. Right-click your **database name**
3. Click **Export database as SQL**
4. Select:
   * Output: **SQL file**
   * Structure + Data
5. Start the export and save the `.sql` file

📺 Video tutorial:

{% embed url="<https://www.youtube.com/watch?v=P_DwadCOUno>" %}

***

### ⚠️ Important notes

* **Do not modify** the exported `.sql` file
* **Do not send screenshots** — always send the `.sql` file
* If the database is large, **compress it to `.zip`** before uploading
* Never share database files publicly — send them **only in tickets**

***

### 📩 Sending the file to support

Upload the exported `.sql` (or `.zip`) file **directly in your ticket** so we can analyze the issue properly.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.otherplanet.dev/troubleshooting/database-export.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.