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.

  • 1 Users Found This Useful

Was this answer helpful?

Related Articles

How to Restore Home Directory Backup in cPanel?

In this article, we will describe the steps to restore partial home directory backup via cPanel....

How to Disable Directory Browsing in cPanel?

If there is no index file to display your website, it will show the directories and other files....

How to take full backup of your hosting space created in cPanel?

cPanel allows a facility of taking full backup of your web resources in a single module. Visit...

How to Increase Mailbox Quota in cPanel?

We restrict email diskspace to 2 GB in Windows Shared Hosting plans. Linux Shared Hosting...

What is Hotlink Protection?

Hotlink protection prevents other websites from directly linking to your files (typically images)...