Dev License: This installation of WHMCS is running under a Development License and is not authorized to be used for production use. Please report any cases of abuse to abuse@whmcs.com
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.
Get Windows VPS
Was this answer helpful? 1 Users Found This Useful (1 Votes)

Most Popular Articles

How to reset FTP user password in cPanel?

You can change FTP password from cPanel using following steps: Login to cPanel. Go to the 'FTP...
How to download MySQL database backup from cPanel?

You can download compressed MySQL database backup from cPanel. You will need to perform the...
How to set index page from cPanel via .htaccess?

You can set the custom index page to your website by modifying the .htaccess file. This article...
How to create user and/or account level filtering from cPanel?

When you receive any Email on the server, you may need to discard some emails (i.e. spam mails),...
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...

Powered by WHMCompleteSolution