Here are the steps to take backup of your MySQL database through PHPMyAdmin:
1. First login to your cPanel.
2. Click on phpMyAdmin, under databases panel.
3. In the phpMyAdmin, click on the desired database name you need to take a backup. Click on it from the left side.
4. When all your tables are loaded, now click on “export” option which is located above all the tables.
5. Now a screen appeared in front of you where you can select desired tables from the list and the format of the file you wish to save it.
Note: If you wish to select all the tables they choose “Quick - display only the minimal options” and from this option “custom - display all possible options” you can select the desired tables you wish to take backup.
6. Now under the format option open the dropdown list and choose “SQL” option, so that you can download the database in SQL format.
7. After selecting both the option, click on “GO” icon to start the export. Now your download will start automatically.
That's it !!
Most Popular Articles
SQL Server Service Is Not Starting - Reasons and Fixes
Here is the common error which you would receive when we try to start SQL Services from various...
Fully automated SQL Server Restore Script
Restoring the latest backups of Production databases on a various test servers is one of the...
MySQL Error 1064
What is MySQL Error 1064?This is exactly syntax error and appears because of few specific...
What is unknown collation ‘utf8mb4_unicode-520-ci’ and how to solve it?
An error message describes a problem that stops a user or system from completing a task.1273 -...
How to create Ms Access Database DSN for Plesk Control Panel?
How to upload the database?Step 1: Login to control panel of Plesk and select File Manager.Step...