# How to Import and Export Minecraft MySQL Databases with phpMyAdmin (/docs/minecraft/import-export-mysql)



phpMyAdmin lets you manage your MySQL databases through a web interface. You can export databases as backups and import them to restore data.

Exporting a Database (Backup) [#exporting-a-database-backup]

<div className="fd-steps">
  <div className="fd-step">
    Open phpMyAdmin [#1-open-phpmyadmin]

    Access the [XGamingServer panel](https://panel.xgamingserver.com), go to `Databases`, and click the phpMyAdmin link for your database.
  </div>

  <div className="fd-step">
    Select your database [#2-select-your-database]

    Click on your database name in the left sidebar.
  </div>

  <div className="fd-step">
    Export [#3-export]

    Click the **Export** tab, select **SQL** format, and click **Go**. Save the `.sql` file to your computer.
  </div>
</div>

Importing a Database (Restore) [#importing-a-database-restore]

<div className="fd-steps">
  <div className="fd-step">
    Open phpMyAdmin [#1-open-phpmyadmin-1]

    Go to `Databases` and open phpMyAdmin.
  </div>

  <div className="fd-step">
    Select your database [#2-select-your-database-1]

    Click your database name in the left sidebar.
  </div>

  <div className="fd-step">
    Import [#3-import]

    Click the **Import** tab, choose your `.sql` file, and click **Go**.

    > ⚠️ **Warning:** Importing overwrites existing data in the tables. Export a fresh backup before importing if you want to keep current data.

    > 💡 **Tip:** Export your database regularly as a backup, especially before major server updates or plugin changes.

    See also: [Use MySQL Database](/docs/minecraft/use-mysql-database)

    If you need help, join our [Discord](https://discord.xgamingserver.com/).
  </div>
</div>