How to Export a MySQL Database Using phpMyAdmin

Byadmin

Exporting your MySQL database is an important part of creating a website backup. Using phpMyAdmin in cPanel, you can download a copy of your database to your computer as an SQL file.

Database backups are useful before website migrations, WordPress updates, plugin changes, or other major modifications.

What Do You Need?

Before starting, make sure you have:

  • Access to your cPanel account
  • An existing MySQL database
  • Access to phpMyAdmin
  • Enough storage space on your computer for the database backup

Step 1: Login to cPanel

  1. Enter your cPanel Username and Password, then click Log in.

Step 2: Open phpMyAdmin

  1. After logging in to cPanel, locate the Databases section.
  2. Click: phpMyAdmin
  3. phpMyAdmin will open in a new page or browser tab.

Step 3: Select Your Database

  1. Inside phpMyAdmin, you will see the available databases on the left side.
  2. Click the database you want to export.
  3. For example: cpanel_username
  4. After selecting the database, its tables should appear.
  5. Make sure you select the correct database before creating your backup.

Step 4: Click the Export Tab

  1. After selecting the database, look at the navigation menu at the top of phpMyAdmin.
  2. Click: Export
  3. The database export options will appear.

Step 5: Click Export

  1. After selecting Quick and SQL, click: Export
  2. Depending on your phpMyAdmin version, the button may instead appear as Go.
  3. Your browser should begin downloading the database backup.
  4. The downloaded file will usually have a name similar to:
  5. cpanel_user

Similar Posts