Knowledge Base

How to Export a Database via phpMyAdmin

How to Export Your MySQL Database

Exporting a database is essential for keeping a manual backup or migrating your site. At Thamara , we recommend exporting your database before making major changes to your website.

Steps to Export:

  1. Log in to your cPanel.

  2. In the Databases section, click phpMyAdmin.

  3. From the left-hand sidebar, click on the name of the database you wish to export.

  4. Click the Export tab in the top menu.

  5. Choose the Export Method:

    • Quick: Display only the minimal options (Recommended for most users).

    • Custom: Allows you to select specific tables or compression options.

  6. Ensure the format is set to SQL.

  7. Click the Go (or Export) button.

  8. The database file will be downloaded to your computer as a .sql file.

Please rate this article to help us improve our Knowledge Base.

0 0