{"id":1294,"date":"2019-12-27T09:47:46","date_gmt":"2019-12-27T09:47:46","guid":{"rendered":"https:\/\/sectigostore.com\/page\/?p=1294"},"modified":"2019-12-27T09:47:46","modified_gmt":"2019-12-27T09:47:46","slug":"backup-your-mysql-database-in-phpmyadmin","status":"publish","type":"post","link":"https:\/\/sectigostore.com\/page\/backup-your-mysql-database-in-phpmyadmin\/","title":{"rendered":"How to Back Up Your MySQL Database in phpMyAdmin"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Using phpMyAdmin can be confusing when you need to create a backup of your database. No worries \u2014 we\u2019ve got you covered! In this article, we\u2019ll look at how to create a backup of your MySQL database using phpMyAdmin. We\u2019ll also discuss an alternative solution that automates the entire backup process. <\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Manual MySQL Backup: phpMyAdmin Backup Database<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Follow the steps mentioned below to manually back up you MySQL database with phpMyAdmin:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li> Log in to your web hosting control panel (such as cPanel) and enter your credentials.<\/li><li> Open the phpMyAdmin console from your control panel. <\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"485\" src=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/mysql-backup-cpanel-1024x485.png\" alt=\"PhpMyAdmin option\" class=\"wp-image-1295\" srcset=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/mysql-backup-cpanel-1024x485.png 1024w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/mysql-backup-cpanel-300x142.png 300w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/mysql-backup-cpanel-768x364.png 768w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/mysql-backup-cpanel.png 1429w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n\n<ul class=\"wp-block-list\"><li>From the sidebar navigation pane on the phpMyAdmin interface, select the database you want to backup.<\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"460\" src=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/php-myadmin-1024x460.png\" alt=\"phpmyadmin general settings\" class=\"wp-image-1296\" srcset=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/php-myadmin-1024x460.png 1024w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/php-myadmin-300x135.png 300w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/php-myadmin-768x345.png 768w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/php-myadmin-1536x690.png 1536w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/php-myadmin-604x270.png 604w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/php-myadmin.png 1750w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n\n<ul class=\"wp-block-list\"><li>Click on the Export tab from the top of the navigation bar.<\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"575\" src=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/php-myadmin-export-1024x575.png\" alt=\"phpmyadmin database wizard\" class=\"wp-image-1297\" srcset=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/php-myadmin-export-1024x575.png 1024w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/php-myadmin-export-300x169.png 300w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/php-myadmin-export-768x431.png 768w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/php-myadmin-export-1536x863.png 1536w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/php-myadmin-export.png 1613w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n\n<ul class=\"wp-block-list\"><li>You will find two options under the Export tab \u2014 <strong>Quick<\/strong> and<strong> Custom<\/strong>. If you choose the quick export method, click on the <strong>Go<\/strong> button to download the export of your database to your local machine\u2019s default download location. <\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">If you choose the custom option, you will get an option to select specific tables you wish to back up. <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"515\" src=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/phpmyadmin-1024x515.png\" alt=\"phpmyadmin exporting table\" class=\"wp-image-1298\" srcset=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/phpmyadmin-1024x515.png 1024w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/phpmyadmin-300x151.png 300w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/phpmyadmin-768x386.png 768w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/phpmyadmin-1536x772.png 1536w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/phpmyadmin.png 1643w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>Select the <strong>Compression<\/strong> option you want to choose. We have selected gzipped and kept the rest of the options unchanged. <\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"574\" src=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/php-myadmin-compression-1024x574.png\" alt=\"phpmyadmin output compression option\" class=\"wp-image-1299\" srcset=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/php-myadmin-compression-1024x574.png 1024w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/php-myadmin-compression-300x168.png 300w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/php-myadmin-compression-768x430.png 768w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/php-myadmin-compression-1536x861.png 1536w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/php-myadmin-compression.png 1620w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>Your backup file will be downloaded on your local system once you click on the <strong>Go<\/strong> button. <\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"549\" src=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/phpmyadmin-downloaded-1024x549.png\" alt=\"phpmyadmin database creation\" class=\"wp-image-1300\" srcset=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/phpmyadmin-downloaded-1024x549.png 1024w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/phpmyadmin-downloaded-300x161.png 300w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/phpmyadmin-downloaded-768x412.png 768w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/phpmyadmin-downloaded-1536x823.png 1536w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/phpmyadmin-downloaded.png 1608w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Why Do We Need to Automate Our Backups?<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">An automatic website backup solution serves as a reliable alternative mechanism that, once set up, can run on its own \u2014 all without the need for human intervention. It takes a snapshot of your website so you can restore it with a single click in case the website breaks or you get attacked by hackers or malware. Automation makes the process convenient and hassle-free while ensuring that you aren\u2019t left with an outdated backup. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Your hosting provider is not responsible or liable if your website gets hacked. If your backups are on the same server that hosts your website, what happens if the server crashes? Quite simply, you lose all your data, and you\u2019re left with no backups at all. As a website owner, you need to take responsibility for your website security. <\/p>\n\n\n\n<div class=\"graysection\">\n<h2>Get CodeGuard for Only $1.63\/Month!<\/h2>\n<p>Its More than Just a Backup Tool! Get Free Malware Removal, Free AWS Storage Space, One-Click Restoration and Strong 256-bit AES encryption of Backup Files with CodeGuard!  <\/p>\n<a class=\"greenbutton\" style=\"text-decoration: none;\" href=\"https:\/\/sectigostore.com\/codeguard\/backup\">Shop Now<\/a>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>CodeGuard Website Backup &amp; Restore<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">As an automated backup solution that keeps copies of your website data securely on the cloud, CodeGuard safeguards you from experiencing massive downtime for issues related to data loss. This Sectigo product acts like an undo button or an autosave checkpoint in a game, except it works for your website and you can revert the site to the last clean version with a single click. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Codeguard comes in five different plans with all features available across the board \u2014 the only difference being the storage space and the number of websites the user can backup. If you require more storage space, you can ask for a customized backup plan to be designed according to your needs. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Let\u2019s look at how to back up your MySQL Database using CodeGuard:<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>How to Automatically Schedule Your Backups with CodeGuard<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">CodeGuard accesses your site either through FTP\/SFTP or using a WordPress plugin. Based upon how you choose to set it up, it can back up a few files, copy the entire website, or only make a copy of the specific data that has changed.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">To schedule an automatic backup using CodeGuard, log in to your CodeGuard Dashboard and follow the steps below:<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 1: Choose Your Backup Option<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">You can add a website to back up using a WordPress plugin or via FTP. You can use either, but it is recommended to use the FTP\/SFTP option.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"379\" src=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/add-a-website-in-codegaurd-backup-1-1024x379.png\" alt=\"add a website in codeguard\" class=\"wp-image-1301\" srcset=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/add-a-website-in-codegaurd-backup-1-1024x379.png 1024w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/add-a-website-in-codegaurd-backup-1-300x111.png 300w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/add-a-website-in-codegaurd-backup-1-768x284.png 768w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/add-a-website-in-codegaurd-backup-1.png 1121w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 2: Obtain the Required Information to Add Your Website<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">For adding a website via FTP or SFTP, you will need some information from your hosting provider such as: <\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>the URL of the website you want\nto add, <\/li><li>the FTP or SFTP server, <\/li><li>user credentials, and <\/li><li>port number. <\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">You can find this information under settings in your hosting account. It\u2019s always recommended to use SFTP instead of FTP whenever possible as it\u2019s more secure.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"742\" height=\"871\" src=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/add-your-website-with-sftp-credentials-1.png\" alt=\"add a website with SFTP credentials\" class=\"wp-image-1302\" srcset=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/add-your-website-with-sftp-credentials-1.png 742w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/add-your-website-with-sftp-credentials-1-256x300.png 256w\" sizes=\"auto, (max-width: 742px) 100vw, 742px\" \/><\/figure><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 3: Select Your Root Directory<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">If the connection is successful, the next step takes you to the Capture Your Code window where you must select or manually specify your root directory. Next, press <strong>Select Root Directory<\/strong>.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"767\" height=\"572\" src=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/capture-your-code-1.png\" alt=\"capture path in codeguard\" class=\"wp-image-1303\" srcset=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/capture-your-code-1.png 767w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/capture-your-code-1-300x224.png 300w\" sizes=\"auto, (max-width: 767px) 100vw, 767px\" \/><\/figure><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 4: Select the Contents to Backup<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Once that\u2019s done, select the website content (specific files and folders) that you would like to back up and click <strong>Begin First Backup<\/strong>. <\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"747\" height=\"472\" src=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/codeguard-root.png\" alt=\"choose backup option\" class=\"wp-image-1304\" srcset=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/codeguard-root.png 747w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/codeguard-root-300x190.png 300w\" sizes=\"auto, (max-width: 747px) 100vw, 747px\" \/><\/figure><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 5: Add a Database from the Completion Window<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Once your first backup is complete, you will be taken to the\ncompletion window. From here, you can add a database to back it up or you can\nalso do it from your website dashboard. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Note: You cannot add a database without adding a website first.<\/em><\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"545\" src=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/add-database-1024x545.png\" alt=\"codeguard website setup\" class=\"wp-image-1305\" srcset=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/add-database-1024x545.png 1024w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/add-database-300x160.png 300w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/add-database-768x408.png 768w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/add-database.png 1416w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 6: Get Database Details<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">To add a database, you will need: <\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>a database name, <\/li><li>MySQL hostname or IP, <\/li><li>your username, <\/li><li>your password and <\/li><li>the port number. <\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">If you are unable to find this information in your hosting account, please contact the CodeGuard support team to help you with the details. The default port number for MySQL is 3306.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 7: Enter Database Credentials and Test Connection<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Access your CodeGuard dashboard and select the website for which you wish to add a database. This step will take you to the website\u2019s dashboard. <\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"985\" height=\"905\" src=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/add-database-credentials-2.png\" alt=\"codeguard dashboard\" class=\"wp-image-1306\" srcset=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/add-database-credentials-2.png 985w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/add-database-credentials-2-300x276.png 300w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/add-database-credentials-2-768x706.png 768w\" sizes=\"auto, (max-width: 985px) 100vw, 985px\" \/><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">On the website dashboard, you will find an option to add your database. Once you click on it, you will be taken to the test database connection page where you need to enter your database\u2019s IP or hostname.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"941\" height=\"740\" src=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/file-backup-summary-1.png\" alt=\"codeguard file backup summery\" class=\"wp-image-1307\" srcset=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/file-backup-summary-1.png 941w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/file-backup-summary-1-300x236.png 300w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/file-backup-summary-1-768x604.png 768w\" sizes=\"auto, (max-width: 941px) 100vw, 941px\" \/><\/figure><\/div>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"708\" height=\"600\" src=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/test-connection-1.png\" alt=\"test connection in codeguard\" class=\"wp-image-1308\" srcset=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/test-connection-1.png 708w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/test-connection-1-300x254.png 300w\" sizes=\"auto, (max-width: 708px) 100vw, 708px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Enter the credentials to access your database.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"608\" src=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/add-credentials-1024x608.png\" alt=\"add credentials in codeguard\" class=\"wp-image-1309\" srcset=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/add-credentials-1024x608.png 1024w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/add-credentials-300x178.png 300w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/add-credentials-768x456.png 768w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/add-credentials.png 1090w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">In the next section, select the databases you want to add, click on <strong>Add Databases<\/strong>, and you\u2019re done! <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"995\" height=\"761\" src=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/add-database-name.png\" alt=\"add databases in codeguard\" class=\"wp-image-1310\" srcset=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/add-database-name.png 995w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/add-database-name-300x229.png 300w, https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/add-database-name-768x587.png 768w\" sizes=\"auto, (max-width: 995px) 100vw, 995px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Using phpMyAdmin can be confusing when you need to create a backup of your database. No worries \u2014 we\u2019ve got you covered! In this article, we\u2019ll look at how to create a backup of your MySQL database using phpMyAdmin. We\u2019ll also discuss an alternative solution that automates the entire backup process. Manual MySQL Backup: phpMyAdmin Backup Database Follow the steps mentioned below to manually back up you MySQL database with phpMyAdmin: Log in to your web hosting control panel (such as cPanel) and enter your credentials. Open the phpMyAdmin console <a href=\"https:\/\/sectigostore.com\/page\/backup-your-mysql-database-in-phpmyadmin\/\" class=\"more-link\">Continue Reading<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[54],"tags":[],"class_list":["post-1294","post","type-post","status-publish","format-standard","hentry","category-codeguard"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.0 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to Back Up Your MySQL Database in phpMyAdmin<\/title>\n<meta name=\"description\" content=\"A complete step-by-step guide to back up your MySQL database in phpMyadmin. It also includes codeguard backup guide to backyour website.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/sectigostore.com\/page\/backup-your-mysql-database-in-phpmyadmin\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Back Up Your MySQL Database in phpMyAdmin\" \/>\n<meta property=\"og:description\" content=\"A complete step-by-step guide to back up your MySQL database in phpMyadmin. It also includes codeguard backup guide to backyour website.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sectigostore.com\/page\/backup-your-mysql-database-in-phpmyadmin\/\" \/>\n<meta property=\"og:site_name\" content=\"SectigoStore\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/sectigostore\/\" \/>\n<meta property=\"article:published_time\" content=\"2019-12-27T09:47:46+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/mysql-backup-cpanel-1024x485.png\" \/>\n<meta name=\"author\" content=\"sectigostorepages\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@sectigostore\" \/>\n<meta name=\"twitter:site\" content=\"@sectigostore\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"sectigostorepages\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/backup-your-mysql-database-in-phpmyadmin\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/backup-your-mysql-database-in-phpmyadmin\\\/\"},\"author\":{\"name\":\"sectigostorepages\",\"@id\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/#\\\/schema\\\/person\\\/f38f303abd42ade13a74a5d3c12b1cec\"},\"headline\":\"How to Back Up Your MySQL Database in phpMyAdmin\",\"datePublished\":\"2019-12-27T09:47:46+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/backup-your-mysql-database-in-phpmyadmin\\\/\"},\"wordCount\":993,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/backup-your-mysql-database-in-phpmyadmin\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/wp-content\\\/uploads\\\/2019\\\/12\\\/mysql-backup-cpanel-1024x485.png\",\"articleSection\":[\"CodeGuard\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/backup-your-mysql-database-in-phpmyadmin\\\/\",\"url\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/backup-your-mysql-database-in-phpmyadmin\\\/\",\"name\":\"How to Back Up Your MySQL Database in phpMyAdmin\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/backup-your-mysql-database-in-phpmyadmin\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/backup-your-mysql-database-in-phpmyadmin\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/wp-content\\\/uploads\\\/2019\\\/12\\\/mysql-backup-cpanel-1024x485.png\",\"datePublished\":\"2019-12-27T09:47:46+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/#\\\/schema\\\/person\\\/f38f303abd42ade13a74a5d3c12b1cec\"},\"description\":\"A complete step-by-step guide to back up your MySQL database in phpMyadmin. It also includes codeguard backup guide to backyour website.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/backup-your-mysql-database-in-phpmyadmin\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/sectigostore.com\\\/page\\\/backup-your-mysql-database-in-phpmyadmin\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/backup-your-mysql-database-in-phpmyadmin\\\/#primaryimage\",\"url\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/wp-content\\\/uploads\\\/2019\\\/12\\\/mysql-backup-cpanel.png\",\"contentUrl\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/wp-content\\\/uploads\\\/2019\\\/12\\\/mysql-backup-cpanel.png\",\"width\":1429,\"height\":677},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/backup-your-mysql-database-in-phpmyadmin\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"SSL Resources\",\"item\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"CodeGuard\",\"item\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/codeguard\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"How to Back Up Your MySQL Database in phpMyAdmin\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/#website\",\"url\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/\",\"name\":\"SectigoStore\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/#\\\/schema\\\/person\\\/f38f303abd42ade13a74a5d3c12b1cec\",\"name\":\"sectigostorepages\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/78239165ecb118435d2709ba4dd124dd9151b1f6b069f87258c6514fe3728c7e?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/78239165ecb118435d2709ba4dd124dd9151b1f6b069f87258c6514fe3728c7e?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/78239165ecb118435d2709ba4dd124dd9151b1f6b069f87258c6514fe3728c7e?s=96&d=mm&r=g\",\"caption\":\"sectigostorepages\"},\"url\":\"https:\\\/\\\/sectigostore.com\\\/page\\\/author\\\/sectigostorepages\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Back Up Your MySQL Database in phpMyAdmin","description":"A complete step-by-step guide to back up your MySQL database in phpMyadmin. It also includes codeguard backup guide to backyour website.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/sectigostore.com\/page\/backup-your-mysql-database-in-phpmyadmin\/","og_locale":"en_US","og_type":"article","og_title":"How to Back Up Your MySQL Database in phpMyAdmin","og_description":"A complete step-by-step guide to back up your MySQL database in phpMyadmin. It also includes codeguard backup guide to backyour website.","og_url":"https:\/\/sectigostore.com\/page\/backup-your-mysql-database-in-phpmyadmin\/","og_site_name":"SectigoStore","article_publisher":"https:\/\/www.facebook.com\/sectigostore\/","article_published_time":"2019-12-27T09:47:46+00:00","og_image":[{"url":"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/mysql-backup-cpanel-1024x485.png","type":"","width":"","height":""}],"author":"sectigostorepages","twitter_card":"summary_large_image","twitter_creator":"@sectigostore","twitter_site":"@sectigostore","twitter_misc":{"Written by":"sectigostorepages","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/sectigostore.com\/page\/backup-your-mysql-database-in-phpmyadmin\/#article","isPartOf":{"@id":"https:\/\/sectigostore.com\/page\/backup-your-mysql-database-in-phpmyadmin\/"},"author":{"name":"sectigostorepages","@id":"https:\/\/sectigostore.com\/page\/#\/schema\/person\/f38f303abd42ade13a74a5d3c12b1cec"},"headline":"How to Back Up Your MySQL Database in phpMyAdmin","datePublished":"2019-12-27T09:47:46+00:00","mainEntityOfPage":{"@id":"https:\/\/sectigostore.com\/page\/backup-your-mysql-database-in-phpmyadmin\/"},"wordCount":993,"commentCount":0,"image":{"@id":"https:\/\/sectigostore.com\/page\/backup-your-mysql-database-in-phpmyadmin\/#primaryimage"},"thumbnailUrl":"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/mysql-backup-cpanel-1024x485.png","articleSection":["CodeGuard"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/sectigostore.com\/page\/backup-your-mysql-database-in-phpmyadmin\/","url":"https:\/\/sectigostore.com\/page\/backup-your-mysql-database-in-phpmyadmin\/","name":"How to Back Up Your MySQL Database in phpMyAdmin","isPartOf":{"@id":"https:\/\/sectigostore.com\/page\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sectigostore.com\/page\/backup-your-mysql-database-in-phpmyadmin\/#primaryimage"},"image":{"@id":"https:\/\/sectigostore.com\/page\/backup-your-mysql-database-in-phpmyadmin\/#primaryimage"},"thumbnailUrl":"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/mysql-backup-cpanel-1024x485.png","datePublished":"2019-12-27T09:47:46+00:00","author":{"@id":"https:\/\/sectigostore.com\/page\/#\/schema\/person\/f38f303abd42ade13a74a5d3c12b1cec"},"description":"A complete step-by-step guide to back up your MySQL database in phpMyadmin. It also includes codeguard backup guide to backyour website.","breadcrumb":{"@id":"https:\/\/sectigostore.com\/page\/backup-your-mysql-database-in-phpmyadmin\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sectigostore.com\/page\/backup-your-mysql-database-in-phpmyadmin\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/sectigostore.com\/page\/backup-your-mysql-database-in-phpmyadmin\/#primaryimage","url":"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/mysql-backup-cpanel.png","contentUrl":"https:\/\/sectigostore.com\/page\/wp-content\/uploads\/2019\/12\/mysql-backup-cpanel.png","width":1429,"height":677},{"@type":"BreadcrumbList","@id":"https:\/\/sectigostore.com\/page\/backup-your-mysql-database-in-phpmyadmin\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"SSL Resources","item":"https:\/\/sectigostore.com\/page\/"},{"@type":"ListItem","position":2,"name":"CodeGuard","item":"https:\/\/sectigostore.com\/page\/codeguard\/"},{"@type":"ListItem","position":3,"name":"How to Back Up Your MySQL Database in phpMyAdmin"}]},{"@type":"WebSite","@id":"https:\/\/sectigostore.com\/page\/#website","url":"https:\/\/sectigostore.com\/page\/","name":"SectigoStore","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/sectigostore.com\/page\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/sectigostore.com\/page\/#\/schema\/person\/f38f303abd42ade13a74a5d3c12b1cec","name":"sectigostorepages","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/78239165ecb118435d2709ba4dd124dd9151b1f6b069f87258c6514fe3728c7e?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/78239165ecb118435d2709ba4dd124dd9151b1f6b069f87258c6514fe3728c7e?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/78239165ecb118435d2709ba4dd124dd9151b1f6b069f87258c6514fe3728c7e?s=96&d=mm&r=g","caption":"sectigostorepages"},"url":"https:\/\/sectigostore.com\/page\/author\/sectigostorepages\/"}]}},"_links":{"self":[{"href":"https:\/\/sectigostore.com\/page\/wp-json\/wp\/v2\/posts\/1294","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sectigostore.com\/page\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sectigostore.com\/page\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sectigostore.com\/page\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sectigostore.com\/page\/wp-json\/wp\/v2\/comments?post=1294"}],"version-history":[{"count":0,"href":"https:\/\/sectigostore.com\/page\/wp-json\/wp\/v2\/posts\/1294\/revisions"}],"wp:attachment":[{"href":"https:\/\/sectigostore.com\/page\/wp-json\/wp\/v2\/media?parent=1294"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sectigostore.com\/page\/wp-json\/wp\/v2\/categories?post=1294"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sectigostore.com\/page\/wp-json\/wp\/v2\/tags?post=1294"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}