How to secure MySQL database backup from phpMyAdmin in cPanel?

This article will provide you the step by step guidance on how to secure a backup of your MySQL database on your local system through phpMyAdmin..

  1. Login to the phpMyAdmin from your hosting control panel.

  2. Select your database by clicking on database name e.g. demoword_demoDB.

  3. Click on 'Export'.

    Select Your Database and Click on Export

  4. Verify the database name and select 'Custom - display all possible option'. After that select all or required tables that you want to export.

    Select Custom Option and Tables that You Want to Export

  5. Make sure that 'SQL'is slected in Format dropdown menu.

  6. Select 'Add DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT Statement'.

    Select Database Export Format Options

  7. Click on 'Go'.

  8. Once you click on 'Go', database backup will be generated and browser will start downloading backup file on your local machine.

Related Articles

How to Enable/Disable PHP Extensions From cPanel?

Following article will assist you to enable/disable php extensions from cPanel. Login to...

How to change MySQL user password from cPanel?

Steps to change MySQL user password from cPanel: Login to cPanel with provided credentials....

How to change cPanel username in WHM?

We do not allow to change cPanel username for Shared Hosting accounts. VPS or Dedicated server...

What is Leech Protection?

Leech Protect is one of the Security protection provided by cPanel. If users are publically...

How to Show Hidden Files at cPanel File Manager?

More often, you would need to edit the .htaccess file (most common file for WordPress), and you...

  • 1 Users Found This Useful

Was this answer helpful?