{"id":463,"date":"2016-10-31T08:52:23","date_gmt":"2016-10-31T08:52:23","guid":{"rendered":"http:\/\/www.siliconhouse.net\/support\/?page_id=463"},"modified":"2018-02-14T14:24:13","modified_gmt":"2018-02-14T14:24:13","slug":"how-do-i-import-data-from-my-mysql-database","status":"publish","type":"page","link":"https:\/\/www.siliconhouse.net\/support\/windows-reseller-web-hosting\/how-do-i-import-data-from-my-mysql-database\/","title":{"rendered":"How do I Import Data from my MYSQL Database ?"},"content":{"rendered":"<div class=\"dedicated_server_hosting_features_center\">\n<div class=\"reseller_web_hosting_support_navigation\"><aside id=\"bcn_widget-2\" class=\"widget widget_breadcrumb_navxt amr_widget\"><span property=\"itemListElement\" typeof=\"ListItem\"><a property=\"item\" typeof=\"WebPage\" title=\"Go to Silicon House - Reseller Hosting - Dedicated Servers - Cloud.\" href=\"https:\/\/www.siliconhouse.net\/support\" class=\"home\"><span property=\"name\" style=\"color: #232323\"><b>Support Home<\/b><\/span><\/a><meta property=\"position\" content=\"1\"><\/span><\/aside><\/div>\n<div class=\"dedicated_server_hosting_features\">\nWindows Web Hosting have the easy way of uploading database file in the server using PHPMYADMIN. The below process explanation will help users to upload the database in the Web Hosting Server.<\/div>\n<p><aside id=\"text-16\" class=\"widget widget_text amr_widget\">\t\t\t<div class=\"textwidget\"><div class=\"reseller_web_hosting_support_advts\">\r\n\r\n<div class=\"reseller_web_hosting_support_advts_left\">\r\n<a href=\"https:\/\/www.siliconhouse.net\/linux-reseller-web-hosting-india\" target=\"_blank\"><img decoding=\"async\" border=\"0\" src=\"https:\/\/www.siliconhouse.net\/wp-content\/uploads\/2018\/06\/336X280-saffron-unlimited-499-kickstart.gif\" width=\"336\" height=\"280\" alt=\"Reseller Hosting Special Offer\"><\/a>\r\n<\/div>\r\n\r\n<div class=\"reseller_web_hosting_support_advts_right\">\r\n<a href=\"https:\/\/www.siliconhouse.net\/linux-cloud-server-hosting-india\" target=\"_blank\"><img decoding=\"async\" border=\"0\" src=\"https:\/\/www.siliconhouse.net\/wp-content\/uploads\/2018\/06\/336X280-purple-enterprise-cloud-stak-19.jpg\" width=\"336\" height=\"280\" alt=\"Enterprise Cloud Stack\"><\/a>\r\n<\/div>\r\n\r\n<\/div><\/div>\n\t\t<\/aside><br \/>\n<aside id=\"text-20\" class=\"extendedwopts-md-center widget widget_text amr_widget\">\t\t\t<div class=\"textwidget\"><div class=\"reseller_web_hosting_support_advts\">\r\n<div class=\"reseller_web_hosting_support_advts_left\">\r\n<img decoding=\"async\" border=\"0\" src=\"http:\/\/www.siliconhouse.net\/support\/wp-content\/uploads\/2016\/12\/reseller-hosting-249-offer.gif\" width=\"320\" height=\"100\" alt=\"Reseller Hosting Special Offer\">\r\n<\/div>\r\n\r\n<div class=\"reseller_web_hosting_support_advts_right\">\r\n<img decoding=\"async\" border=\"0\" src=\"http:\/\/www.siliconhouse.net\/support\/wp-content\/uploads\/2016\/12\/reseller-hosting-249-offer.gif\" width=\"320\" height=\"100\" alt=\"Reseller Hosting Special Offer\">\r\n<\/div>\r\n\r\n<\/div><\/div>\n\t\t<\/aside><\/p>\n<div class=\"dedicated_server_hosting_features\">Share This Now: [addtoany]<\/p>\n<h4><strong>Watch Reseller Hosting Video Tutorial<\/strong><\/h4>\n<p><video id=\"examplePlayer\" class=\"video-js vjs-16-9 vjs-default-skin\" controls=\"controls\" width=\"300\" height=\"150\"><source src=\"http:\/\/www.siliconhouse.net\/support\/wp-content\/uploads\/2016\/12\/how-do-i-import-data-from-my-mysql-database-in-windows-reseller-hosting.mp4\" type=\"video\/mp4\" \/><\/video><br \/>\n<aside id=\"text-24\" class=\"widget widget_text amr_widget\">\t\t\t<div class=\"textwidget\"><script>\r\n    videojs('examplePlayer',{},function(){\r\n      var player = this;\r\n      player.preroll({\r\n        src:{src:\"http:\/\/www.siliconhouse.net\/support\/wp-content\/uploads\/2016\/11\/reseller-hosting-promo-15secs.mp4\",type:\"video\/mp4\"},\r\n        href:\"http:\/\/www.siliconhouse.net\/linux-reseller-hosting-india\",\r\n        adsOptions: {debug:true}\r\n      });\r\n    });\r\n  <\/script><\/div>\n\t\t<\/aside><br \/>\n<aside id=\"text-25\" class=\"widget widget_text amr_widget\">\t\t\t<div class=\"textwidget\"><script>\r\n    videojs('examplePlayer',{},function(){\r\n      var player = this;\r\n      player.preroll({\r\n        src:{src:\"http:\/\/www.siliconhouse.net\/support\/wp-content\/uploads\/2016\/11\/reseller-hosting-promo-15secs.mp4\",type:\"video\/mp4\"},\r\n        href:\"http:\/\/www.siliconhouse.net\/linux-reseller-hosting-india\",\r\n        adsOptions: {debug:true}\r\n      });\r\n    });\r\n  <\/script><\/div>\n\t\t<\/aside><\/p>\n<\/div>\n<div class=\"dedicated_server_hosting_features\">\n<div class=\"responsive-tabs\">\n<h2 class=\"tabtitle\">Procedure<\/h2>\n<div class=\"tabcontent\">\n\n<h4><strong>Procedure to Import Data from my MYSQL Database :<\/strong><\/h4>\n<p><strong><a href=\"http:\/\/www.siliconhouse.net\/windows-reseller-web-hosting-india\" target=\"_blank\" rel=\"noopener\">Windows Reseller Web Hosting<\/a><\/strong> comes with Plesk Control Panel. You will be able to import mysql database using PhpMyadmin for a particular domain name. Please follow the below procedure to import mysql database<\/p>\n<p>Please note that you can access the MYSQL database using PhpMyadmin<\/p>\n<p>[1] Login to your plesk control panel.<br \/>\n[2] Click on subscriptions.<br \/>\n[3] Click on the domain name.<br \/>\n[4] Click on websites and domains<br \/>\n[5] Click on databases<br \/>\n[6] Click on PhpMyAdmin<\/p>\n<p><strong>Importing tables via PhpMyadmin<\/strong><\/p>\n<p>[1] Log in to phpMyAdmin.<br \/>\n[2] Create an empty database from the Databases<br \/>\n[3] Click the Import tab.<br \/>\n[4] Click the Browse button.<br \/>\n[5] Locate the file to be imported.<br \/>\n[6] Click Open or OK, depending on your browser.<br \/>\n[7] Select the proper collation from the drop-down.<br \/>\n[8] Select the format of the import file.<br \/>\n[9] Click Go.<\/p>\n<\/div>\n<div class=\"dedicated_server_hosting_features\">\n\n<\/div><h2 class=\"tabtitle\">Screen Shots<\/h2>\n<div class=\"tabcontent\">\n\n<h4><strong>Refer Screen Shots<\/strong><\/h4>\n\n<\/div><h2 class=\"tabtitle\">Troubleshooting FAQs<\/h2>\n<div class=\"tabcontent\">\n\n<h4><strong>Reseller Hosting WHM Troubleshooting FAQs<\/strong><\/h4>\n\n<\/div><h2 class=\"tabtitle\">Downloads<\/h2>\n<div class=\"tabcontent\">\n\n<h4><strong>Related Downloads<\/strong><\/h4>\n<div class=\"reseller_web_hosting_support_articles_left\"><aside id=\"text-28\" class=\"widget widget_text amr_widget\">\t\t\t<div class=\"textwidget\"><strong>Reseller Hosting Training PDFs<\/strong><br>\r\nReseller Hosting Kick Start<\/div>\n\t\t<\/aside><\/p>\n<aside id=\"text-29\" class=\"widget widget_text amr_widget\">\t\t\t<div class=\"textwidget\"><strong>PHP<\/strong><br>\r\nForm Mail Sample<br>\r\nPHP Database Connection Sample<br><\/div>\n\t\t<\/aside>\n<aside id=\"text-30\" class=\"widget widget_text amr_widget\">\t\t\t<div class=\"textwidget\"><strong>JSP<\/strong><br>\r\nHeap Size Check<br>\r\nJSP Database Connection Sample<\/div>\n\t\t<\/aside>\n<aside id=\"text-31\" class=\"widget widget_text amr_widget\">\t\t\t<div class=\"textwidget\"><strong>Mysql<\/strong><br>\r\nOptimizing Mysql Queries<br>\r\nIndexes<\/div>\n\t\t<\/aside>\n<aside id=\"text-32\" class=\"widget widget_text amr_widget\">\t\t\t<div class=\"textwidget\"><strong>Optimization<\/strong><br>\r\nApplication Optimization<br>\r\nDatabase Optimization<\/div>\n\t\t<\/aside><\/div>\n<div class=\"reseller_web_hosting_support_articles_right\"><aside id=\"text-33\" class=\"widget widget_text amr_widget\">\t\t\t<div class=\"textwidget\"><strong>Security<\/strong><br>\r\nSecurity Best Practices<br>\r\nHow to Secure Your Wordpress Web Hosting?<br>\r\nHow to Secure Your Joomla Web Hosting?<br><\/div>\n\t\t<\/aside><\/p>\n<aside id=\"text-34\" class=\"widget widget_text amr_widget\">\t\t\t<div class=\"textwidget\"><strong>Payment Gateways<\/strong><br>\r\n<\/div>\n\t\t<\/aside>\n<aside id=\"text-35\" class=\"widget widget_text amr_widget\">\t\t\t<div class=\"textwidget\"><strong>Product Brochuers<\/strong><br>\r\nXMAIL Trac<br>\r\nArrow SQLArc<br>\r\nArrow Global Load Balancer<br>\r\nArrow Multi-Zone Db Sync<br>\r\nArrow Media Streaming Servers\r\n<\/div>\n\t\t<\/aside>\n<aside id=\"text-37\" class=\"widget widget_text amr_widget\">\t\t\t<div class=\"textwidget\"><strong>Ebooks<\/strong><br>\r\nReseller Web Hosting Ebook<br><\/div>\n\t\t<\/aside><\/div>\n\n<\/div><h2 class=\"tabtitle\">Related Articles<\/h2>\n<div class=\"tabcontent\">\n\n<h4><strong>Related Reseller Hosting Support Articles<\/strong><\/h4>\n<p>How do I Create a MSSQL Database in a particular domain name ?<br \/>\nHow do I Import and Export Data from my MSSQL Database ?<br \/>\n<\/div><\/div><\/p>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Windows Web Hosting have the easy way of uploading database file in the server using PHPMYADMIN. The below process explanation<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":12,"menu_order":22,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-463","page","type-page","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How toImport Data from my MYSQL Database in Plesk ?<\/title>\n<meta name=\"description\" content=\"You will be able to import mysql database using PhpMyadmin for a particular domain name. Please follow the below procedure to import mysql database\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.siliconhouse.net\/support\/windows-reseller-web-hosting\/how-do-i-import-data-from-my-mysql-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How toImport Data from my MYSQL Database in Plesk ?\" \/>\n<meta property=\"og:description\" content=\"You will be able to import mysql database using PhpMyadmin for a particular domain name. Please follow the below procedure to import mysql database\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.siliconhouse.net\/support\/windows-reseller-web-hosting\/how-do-i-import-data-from-my-mysql-database\/\" \/>\n<meta property=\"og:site_name\" content=\"Silicon House - Reseller Hosting - Dedicated Servers - Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/siliconhouse.net\" \/>\n<meta property=\"article:modified_time\" content=\"2018-02-14T14:24:13+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@siliconhouse\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.siliconhouse.net\/support\/windows-reseller-web-hosting\/how-do-i-import-data-from-my-mysql-database\/\",\"url\":\"https:\/\/www.siliconhouse.net\/support\/windows-reseller-web-hosting\/how-do-i-import-data-from-my-mysql-database\/\",\"name\":\"How toImport Data from my MYSQL Database in Plesk ?\",\"isPartOf\":{\"@id\":\"https:\/\/www.siliconhouse.net\/support\/#website\"},\"datePublished\":\"2016-10-31T08:52:23+00:00\",\"dateModified\":\"2018-02-14T14:24:13+00:00\",\"description\":\"You will be able to import mysql database using PhpMyadmin for a particular domain name. Please follow the below procedure to import mysql database\",\"breadcrumb\":{\"@id\":\"https:\/\/www.siliconhouse.net\/support\/windows-reseller-web-hosting\/how-do-i-import-data-from-my-mysql-database\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.siliconhouse.net\/support\/windows-reseller-web-hosting\/how-do-i-import-data-from-my-mysql-database\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.siliconhouse.net\/support\/windows-reseller-web-hosting\/how-do-i-import-data-from-my-mysql-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.siliconhouse.net\/support\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Windows Reseller Web Hosting\",\"item\":\"https:\/\/www.siliconhouse.net\/support\/windows-reseller-web-hosting\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"How do I Import Data from my MYSQL Database ?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.siliconhouse.net\/support\/#website\",\"url\":\"https:\/\/www.siliconhouse.net\/support\/\",\"name\":\"Silicon House - Reseller Hosting - Dedicated Servers - Cloud\",\"description\":\"Reseller Hosting - Dedicated Servers - Cloud\",\"publisher\":{\"@id\":\"https:\/\/www.siliconhouse.net\/support\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.siliconhouse.net\/support\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.siliconhouse.net\/support\/#organization\",\"name\":\"Silicon House\",\"url\":\"https:\/\/www.siliconhouse.net\/support\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.siliconhouse.net\/support\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.siliconhouse.net\/support\/wp-content\/uploads\/2016\/10\/siliconhouse-logo.png\",\"contentUrl\":\"https:\/\/www.siliconhouse.net\/support\/wp-content\/uploads\/2016\/10\/siliconhouse-logo.png\",\"width\":42,\"height\":40,\"caption\":\"Silicon House\"},\"image\":{\"@id\":\"https:\/\/www.siliconhouse.net\/support\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/siliconhouse.net\",\"https:\/\/x.com\/siliconhouse\",\"https:\/\/www.youtube.com\/siliconhouse\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How toImport Data from my MYSQL Database in Plesk ?","description":"You will be able to import mysql database using PhpMyadmin for a particular domain name. Please follow the below procedure to import mysql database","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:\/\/www.siliconhouse.net\/support\/windows-reseller-web-hosting\/how-do-i-import-data-from-my-mysql-database\/","og_locale":"en_US","og_type":"article","og_title":"How toImport Data from my MYSQL Database in Plesk ?","og_description":"You will be able to import mysql database using PhpMyadmin for a particular domain name. Please follow the below procedure to import mysql database","og_url":"https:\/\/www.siliconhouse.net\/support\/windows-reseller-web-hosting\/how-do-i-import-data-from-my-mysql-database\/","og_site_name":"Silicon House - Reseller Hosting - Dedicated Servers - Cloud","article_publisher":"https:\/\/www.facebook.com\/siliconhouse.net","article_modified_time":"2018-02-14T14:24:13+00:00","twitter_card":"summary_large_image","twitter_site":"@siliconhouse","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.siliconhouse.net\/support\/windows-reseller-web-hosting\/how-do-i-import-data-from-my-mysql-database\/","url":"https:\/\/www.siliconhouse.net\/support\/windows-reseller-web-hosting\/how-do-i-import-data-from-my-mysql-database\/","name":"How toImport Data from my MYSQL Database in Plesk ?","isPartOf":{"@id":"https:\/\/www.siliconhouse.net\/support\/#website"},"datePublished":"2016-10-31T08:52:23+00:00","dateModified":"2018-02-14T14:24:13+00:00","description":"You will be able to import mysql database using PhpMyadmin for a particular domain name. Please follow the below procedure to import mysql database","breadcrumb":{"@id":"https:\/\/www.siliconhouse.net\/support\/windows-reseller-web-hosting\/how-do-i-import-data-from-my-mysql-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.siliconhouse.net\/support\/windows-reseller-web-hosting\/how-do-i-import-data-from-my-mysql-database\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.siliconhouse.net\/support\/windows-reseller-web-hosting\/how-do-i-import-data-from-my-mysql-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.siliconhouse.net\/support\/"},{"@type":"ListItem","position":2,"name":"Windows Reseller Web Hosting","item":"https:\/\/www.siliconhouse.net\/support\/windows-reseller-web-hosting\/"},{"@type":"ListItem","position":3,"name":"How do I Import Data from my MYSQL Database ?"}]},{"@type":"WebSite","@id":"https:\/\/www.siliconhouse.net\/support\/#website","url":"https:\/\/www.siliconhouse.net\/support\/","name":"Silicon House - Reseller Hosting - Dedicated Servers - Cloud","description":"Reseller Hosting - Dedicated Servers - Cloud","publisher":{"@id":"https:\/\/www.siliconhouse.net\/support\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.siliconhouse.net\/support\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.siliconhouse.net\/support\/#organization","name":"Silicon House","url":"https:\/\/www.siliconhouse.net\/support\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.siliconhouse.net\/support\/#\/schema\/logo\/image\/","url":"https:\/\/www.siliconhouse.net\/support\/wp-content\/uploads\/2016\/10\/siliconhouse-logo.png","contentUrl":"https:\/\/www.siliconhouse.net\/support\/wp-content\/uploads\/2016\/10\/siliconhouse-logo.png","width":42,"height":40,"caption":"Silicon House"},"image":{"@id":"https:\/\/www.siliconhouse.net\/support\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/siliconhouse.net","https:\/\/x.com\/siliconhouse","https:\/\/www.youtube.com\/siliconhouse"]}]}},"_links":{"self":[{"href":"https:\/\/www.siliconhouse.net\/support\/wp-json\/wp\/v2\/pages\/463","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.siliconhouse.net\/support\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.siliconhouse.net\/support\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.siliconhouse.net\/support\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.siliconhouse.net\/support\/wp-json\/wp\/v2\/comments?post=463"}],"version-history":[{"count":12,"href":"https:\/\/www.siliconhouse.net\/support\/wp-json\/wp\/v2\/pages\/463\/revisions"}],"predecessor-version":[{"id":5615,"href":"https:\/\/www.siliconhouse.net\/support\/wp-json\/wp\/v2\/pages\/463\/revisions\/5615"}],"up":[{"embeddable":true,"href":"https:\/\/www.siliconhouse.net\/support\/wp-json\/wp\/v2\/pages\/12"}],"wp:attachment":[{"href":"https:\/\/www.siliconhouse.net\/support\/wp-json\/wp\/v2\/media?parent=463"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}