{"id":2202,"date":"2020-06-09T19:35:23","date_gmt":"2020-06-09T11:35:23","guid":{"rendered":"https:\/\/www.wesbytes.com\/guide\/?post_type=kb&#038;p=2202"},"modified":"2026-03-17T14:30:27","modified_gmt":"2026-03-17T06:30:27","slug":"backup-mysql-database-phpmyadmin","status":"publish","type":"kb","link":"https:\/\/www.servergigabit.com\/guide\/kb\/backup-mysql-database-phpmyadmin","title":{"rendered":"MySQL Database Backup: 7 Easy Steps Using phpMyAdmin"},"content":{"rendered":"<h3 dir=\"ltr\"><strong>Steps to Backup Mysql Database Using PHPMyAdmin<\/strong><\/h3>\n<p dir=\"ltr\">1.\u00a0 Firstly, Log into <a href=\"https:\/\/www.phpmyadmin.net\/\" rel=\"nofollow noopener\" target=\"_blank\">PHPMyAdmin<\/a>. (You can get your PHPMyAdmin URL inside your cPanel \/ HELM \/ Plesk)<br \/>\n2. Select the database which you wish to backup from the drop down database menu at the left.<br \/>\n3. Click on \u201cExport\u201d tab.<br \/>\n4. Next, Select Mysql database table which you wish to export.<br \/>\n5. Select Export Options.<br \/>\n6. Enter a filename and compressions format.<br \/>\n7. Last, Click \u201cGo\u201d.<\/p>\n<p dir=\"ltr\">\u2013 If you select Compressions = None, a query windows will appear and displaying the raw Mysql query of your exported tables.<br \/>\n\u2013 If you select Compressions = \u201cZipped\u201d or \u201cGZipped\u201d, a pop up box will appear asking you to save the .sql file into your local drive.<\/p>\n<p dir=\"ltr\">You&#8217;re sucessful to backup Mysql Database using PHPMyAdmin. If you found this guide useful during the setup of your additional address. Please share it with other users going through the same process.<\/p>\n<p dir=\"ltr\"><em>Please refer to the following article to know more.\u00a0<\/em><br \/>\n<strong>Knowledge Base: <\/strong><a href=\"https:\/\/www.servergigabit.com\/guide\/kb\/changing-collation-in-phpmyadmin\/\">Changing Collation in PhpMyAdmin<\/a><\/p>\n<p dir=\"ltr\">\n","protected":false},"excerpt":{"rendered":"<p>Steps to Backup Mysql Database Using PHPMyAdmin 1.\u00a0 Firstly, Log into PHPMyAdmin. (You can get your PHPMyAdmin URL inside your cPanel \/ HELM \/ Plesk) 2. Select the database which you wish to backup from the drop down database menu at the left. 3. Click on \u201cExport\u201d tab. 4. Next, Select Mysql database table which you wish to export. 5.&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"kbtopic":[53],"kbtag":[1215],"class_list":["post-2202","kb","type-kb","status-publish","hentry","kbtopic-phpmyadmin","kbtag-mysql"],"_links":{"self":[{"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/kb\/2202","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/kb"}],"about":[{"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/types\/kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/comments?post=2202"}],"version-history":[{"count":7,"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/kb\/2202\/revisions"}],"predecessor-version":[{"id":6369,"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/kb\/2202\/revisions\/6369"}],"wp:attachment":[{"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/media?parent=2202"}],"wp:term":[{"taxonomy":"kbtopic","embeddable":true,"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/kbtopic?post=2202"},{"taxonomy":"kbtag","embeddable":true,"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/kbtag?post=2202"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}