How To Secure MySQL Database Backup From PhpMyAdmin In cPanel?

It is always a good idea to have a backup of your database on your local machine. It can be used to restore and recover the data after a failure or can also be used to restore a copy of the database to a new location. In this article we will discuss on how to secure MySQL database backup from phpMyAdmin in cPanel.

Steps to secure MySQL database backup from phpMyAdmin in cPanel

  1. Login to your cPanel account.
  2. Under the Databases section, click on phpMyAdmin.
    cpanel phpmyadmin
  3. In the new tab, click on the database name for which you want to create a backup. Example demo_demotest.
    cpanel phpmyadmin database
  4. Click on the Export tab at the top of the page.
    cpanel phpmyadmin database export
  5. Verify the database name is correct and select Custom – display all possible options. After that select all or required tables that you want to export.
    cpanel phpmyadmin display option
  6. In the Format section, select SQL from the drop-down list.
    cpanel phpmyadmin format sql
  7. Under the Object creation option, enable Add DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT TRIGGER Statement.
    cpanel phpmyadmin add drop
  8. Scroll to the end of the page and click on the Export button.
    cpanel phpmyadmin export table
  9. Once you click on the Export button, a database backup will be generated and the browser will start downloading the backup file on your local machine.

Note: Always check the backup file by loading it into your local phpMyAdmin.

That’s It! You have secured MySQL database backup from phpMyAdmin.

If you enjoyed this tutorial, then you would love our support! All Kemuhost hosting plans include 24/7 support from our amazing support team. Check out our web hosting plans and have your website migrated for free today!

Add a Comment

Your email address will not be published. Required fields are marked *