Database backups and restoration

This article explains how to backup and restore MySQL databases of accounts under your reseller plan, using WHM, cPanel (accessed from WHM), and phpMyAdmin.

Why backup databases?

  • Before updating WordPress, plugins, or themes.
  • Before migrations or massive changes.
  • After security incidents or human errors.
  • Periodic client backup routine.

Method 1: phpMyAdmin (export / import)

  1. WHM → List Accounts → cPanel of the account.
  2. Databases → phpMyAdmin.
  3. Select the database in the left panel.
  4. Export tab → Quick or Custom method → Go (download the .sql file).

Restore:

  1. phpMyAdmin → select the database (or create it beforehand in MySQL Databases).
  2. Import tab → choose the .sql file → Go.

Importing large files: If the .sql exceeds the PHP upload limit, split the file, use command line (if you have SSH), or ask support for help.

Method 2: Backup Wizard in cPanel

  1. Account cPanel → Files → Backup or Backup Wizard.
  2. Download a MySQL Database Backup — choose the database.
  3. To restore: Restore a MySQL Database Backup (if available).

Includes only the chosen database; it is useful for the client without manually exporting in phpMyAdmin.

Method 3: full account backups

From cPanel → Backup you can download a full backup (files + databases). Useful for total account migration.

At the WHM level, tools like Backup » Backup User Account or full server backups are usually limited to the administrator in reseller plans.

Best practices

  • Backup before major changes.
  • Save copies outside the same server (PC, cloud, another disk).
  • Test restoring in a test environment when it is critical.
  • Include MySQL user/password in a secure manager, not just the .sql.
  • Schedule regular backups if the client uses WordPress or an online store.

Selective restoration (only some tables)

  1. Export only the necessary tables from phpMyAdmin (Custom export).
  2. Or edit the .sql to import specific tables.
  3. Import into the target database carefully not to unintentionally overwrite new data.

Before terminating an account

If you are going to use Terminate an Account, export all databases beforehand in phpMyAdmin or Backup. Termination deletes everything permanently.

If the backup fails due to size, timeout, or import error, open a ticket from the client portal with domain, database name, and approximate file size. You can also ask via the site's online chat.

  • respaldar base de datos, phpmyadmin
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Managing MySQL databases from WHM

This article explains how to manage MySQL databases for your clients' accounts from WHM: limits...

Configure Remote MySQL Access

This article explains how to enable Remote MySQL access so that an application or another server...