# 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: 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.