Help center

Working with your databases in phpMyAdmin

Updated November 5, 2026

phpMyAdmin lets you view and manage MySQL databases, export backup copies, import saved copies, and run SQL queries. Most websites—including WordPress sites—never need to use it. Be careful: database changes can affect your website, so export a backup copy before changing anything.

Open phpMyAdmin

  1. Sign in to cPanel.
  2. Open phpMyAdmin.
  3. Select the database you want to work with from the left-hand panel.

To create a database or database user, use Manage My Databases or Database Wizard instead. Do not create them in phpMyAdmin.

Export a database

  1. Select the database in phpMyAdmin.
  2. Choose Export.
  3. Choose the export options you need, then start the export.
  4. Save the downloaded file somewhere safe. This file is a backup copy you can use for an import.

Import a database

  1. Select the database that should receive the saved data.
  2. Choose Import.
  3. Select the saved database file from your computer.
  4. Start the import and wait for the confirmation.

Importing can add or replace data, depending on the file and its contents. Export the current database first.

Run a query

  1. Select the database.
  2. Open the SQL tab.
  3. Enter or paste the SQL query.
  4. Run the query and review the result carefully.

Only run queries when you understand what they do. Queries that change or delete data cannot always be undone.

If something doesn't work

Stop before repeating an import or query, especially if it changes data. Keep your export file and the message shown by phpMyAdmin, then contact us or open a ticket.

Still stuck?

Sign in and open a ticket, and we'll help.

Sign in and open a ticket