---
title: Export Or Import A MySQL Database With phpMyAdmin
description: "## Export Here's how you can export your MySQL database(s) for your sites with phpMyAdmin. - Login to your panel - Click on the phpMyAdmin option - You'll see something like this: ![](https://know.cynderhost.com/wp-content/uploads/2020/08/image-19.png) - Click the \"Export\" button at the…"
url: "https://know.cynderhost.com/docs/export-or-import-a-mysql-database-with-phpmyadmin/"
updated: "2021-11-14"
category: cPanel
---

# Export Or Import A MySQL Database With phpMyAdmin

## Export

Here's how you can export your MySQL database(s) for your sites with phpMyAdmin.

- Login to your panel
- Click on the phpMyAdmin option
- You'll see something like this:

![](https://know.cynderhost.com/wp-content/uploads/2020/08/image-19.png)

- Click the "Export" button at the top. This will export all your databases
- To just export one database, select it from the sidebar. Then, click the Export button and make sure the format is SQL
- Save the SQL file that is exported when you click "Go"

This is a dump of your database(s).

## Import

You can also import dumps in phpMyAdmin on the same or a new server.

- Open up phpMyAdmin
- Click on the "Import" button

![](https://know.cynderhost.com/wp-content/uploads/2020/08/image-20.png)

- Upload the .SQL dump you made
- Click "Go" -- you can leave the settings as is

Your database(s) will be imported.