Knowledgebase

Exporting a Database Using phpMyAdmin (Firstserv Guide)

This guide explains how to export a database using phpMyAdmin in cPanel. Exporting your database allows you to:

• ✅ Create a backup
• ✅ Move your website to another server
• ✅ Save a copy for development or testing

Step 1: Access phpMyAdmin

1. Log in to cPanel
2. Navigate to:

   Databases → phpMyAdmin
   

Step 2: Select Your Database

• In the left-hand panel, click the database name you want to export
• The tables inside the database will be displayed

✅ You should also see the selected database name at the top of the page

Step 3: Start the Export

1. Click the Export tab at the top

2. Leave the default settings:

   • Export method: Quick
   • Format: SQL

3. Click Go

Step 4: Save the File

• Your browser will prompt you to:
  • Save the file (recommended), or
  • Open it

✅ The .sql file will usually be saved to your Downloads folder

Optional: Custom Export Settings

If you need more control:

• Select Custom instead of Quick
• This allows you to:
  • Include additional options (e.g. CREATE DATABASE)
  • Choose a different export format
  • Select specific tables

👉 The default (Quick + SQL) is sufficient for most use cases

Summary

• Access phpMyAdmin via cPanel
• Select your database
• Use the Export tab
• Choose Quick → SQL
• Download the exported file

Need Help?

If you’re unsure which export options to use or need help backing up your database, the Firstserv support team is always happy to assist.