{"version":"1.0","provider_name":"4GoodHosting Blog","provider_url":"https:\/\/4goodhosting.com\/blog","author_name":"4GHadmin","author_url":"https:\/\/4goodhosting.com\/blog\/author\/4goodhosting\/","title":"The way to Backup Your Database with phpMyAdmin - 4GoodHosting Blog","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"9aNB34c4L0\"><a href=\"https:\/\/4goodhosting.com\/blog\/the-way-to-backup-your-database-with-phpmyadmin\/\">The way to Backup Your Database with phpMyAdmin<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/4goodhosting.com\/blog\/the-way-to-backup-your-database-with-phpmyadmin\/embed\/#?secret=9aNB34c4L0\" width=\"600\" height=\"338\" title=\"&#8220;The way to Backup Your Database with phpMyAdmin&#8221; &#8212; 4GoodHosting Blog\" data-secret=\"9aNB34c4L0\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" class=\"wp-embedded-content\"><\/iframe><script type=\"text\/javascript\">\n\/* <![CDATA[ *\/\n\/*! This file is auto-generated *\/\n!function(d,l){\"use strict\";l.querySelector&&d.addEventListener&&\"undefined\"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!\/[^a-zA-Z0-9]\/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret=\"'+t.secret+'\"]'),o=l.querySelectorAll('blockquote[data-secret=\"'+t.secret+'\"]'),c=new RegExp(\"^https?:$\",\"i\"),i=0;i<o.length;i++)o[i].style.display=\"none\";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute(\"style\"),\"height\"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):\"link\"===t.message&&(r=new URL(s.getAttribute(\"src\")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener(\"message\",d.wp.receiveEmbedMessage,!1),l.addEventListener(\"DOMContentLoaded\",function(){for(var e,t,s=l.querySelectorAll(\"iframe.wp-embedded-content\"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute(\"data-secret\"))||(t=Math.random().toString(36).substring(2,12),e.src+=\"#?secret=\"+t,e.setAttribute(\"data-secret\",t)),e.contentWindow.postMessage({message:\"ready\",secret:t},\"*\")},!1)))}(window,document);\n\/\/# sourceURL=https:\/\/4goodhosting.com\/blog\/wp-includes\/js\/wp-embed.min.js\n\/* ]]> *\/\n<\/script>\n","description":"On modern websites, information is often stored within databases (db&#8217;s) instead of directories on a web server. Therefore, simply storing your website&#8217;s files into directories of your website won&#8217;t deliver all the data your website application presents and also needs to operate. So you should occasionally carry out a database backup. If you utilize a MySQL database, you should use phpMyAdmin to backup your database from inside its graphical interface. To backup your MySQL database with phpMyAdmin, try this procedure: 1. Login to phpMyAdmin. It is possible to find it via your hosting control panel, such as cPanel. 2. Click the database name for the left column in the page. 3. Click on the Export tab at the top of the phpmyadmin page. read_more 4. Select either &#8220;quick&#8221; to show minimal options or &#8220;custom&#8221; to display all of the options. 5. In case you chose custom, choose the tables you would like to backup and set the other available choices. Otherwise, proceed to step 6 6. Find the output format. The default is SQL and sufficient for most backups. 7. Click &#8220;Go&#8221; 8. Save the SQL file into the folder of your choice. The advantage of this method of backup [&hellip;]","thumbnail_url":"https:\/\/4goodhosting.com\/blog\/wp-content\/uploads\/2014\/07\/PhpMyAdmin.png","thumbnail_width":"728","thumbnail_height":"400"}