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.
  9.  
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How to add a record with the DNS Zone Editor in cPanel?

  How to add a record with the DNS Zone Editor in cPanelThis demo assumes you've already logged...

How to add an MX entry in cPanel?

  How to add an MX entry in cPanelThis demo assumes you've already logged in to cPanel, and are...

How to backup your website in cPanel?

  How to backup your website in cPanelThis demo assumes you've already logged in to cPanel, and...

How to Change PHP Directives Globally from WHM with EasyApache 4?

You can follow below steps to change the values of PHP directives for all the websites running a...

How to change PHP version from cPanel?

The latest version of cPanel/WHM (58.3.x) is shipped with the EasyApache 4.0. It allows you to...