{"id":79,"date":"2020-02-12T10:36:29","date_gmt":"2020-02-12T10:36:29","guid":{"rendered":"https:\/\/www.lcn.com\/support\/knowledge-base\/how-to-restore-your-mysql-database\/"},"modified":"2020-09-09T11:11:42","modified_gmt":"2020-09-09T11:11:42","slug":"how-to-restore-your-mysql-database","status":"publish","type":"ht_kb","link":"https:\/\/www.lcn.com\/support\/articles\/how-to-restore-your-mysql-database\/","title":{"rendered":"How to restore your MYSQL database"},"content":{"rendered":"

If you are looking to restore a MySQL databases from a backup, we offer a tool called phpMyAdmin<\/a> which makes this really easy to do. You need to first make sure you have an active database or create one following our guide here<\/a>.<\/p>\n

    \n
  1. Firstly, you will need to reach your phpMyAdmin control panel for your domain. This is found by typing \/mysqladmin <\/strong>after your domain name. For example:http:\/\/www.lcnsupport.co.uk\/mysqladmin<\/strong><\/li>\n
  2. Log in to phpMyAdmin with your Database Username<\/strong> and Password<\/strong>, choose the correct Hostname<\/strong> from the Server Choice<\/strong> drop down.<\/li>\n
  3. Once logged in, select the Database<\/strong> tab.<\/li>\n
  4. Select the database e.g. domain_com_db.<\/li>\n
  5. Select the Import<\/strong> tab.<\/li>\n
  6. Click the Choose File<\/strong> button and select the backup file you wish to restore your database from. You should not need to change any of the settings on the page.<\/li>\n
  7. Click the Go<\/strong> button at the bottom of the page and phpMyAdmin will restore your database from the backup file you have chosen.<\/li>\n
  8. If successful, it will generate a message to let you know and also give you a breakdown of the queries executed.<\/li>\n<\/ol>\n

    That’s it! You have now restored your database.<\/p>\n","protected":false},"excerpt":{"rendered":"

    If you are looking to restore a MySQL databases from a backup, we offer a tool called phpMyAdmin which makes this really easy to do. You need to first make sure you have an active database or create one following our guide here. Firstly, you will need to reach your phpMyAdmin control panel for your […]<\/p>\n","protected":false},"author":1,"comment_status":"closed","ping_status":"open","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[7],"ht-kb-tag":[5],"class_list":["post-79","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-creating-and-managing-databases","ht_kb_tag-web-hosting"],"yoast_head":"\nHow to restore your MYSQL database - LCN.com<\/title>\n<meta name=\"description\" content=\"How to restore your MYSQL database at LCN.comFollow this simple guide to restoring your MYSQL database with a back-up copy.\" \/>\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.lcn.com\/support\/articles\/how-to-restore-your-mysql-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to restore your MYSQL database - LCN.com\" \/>\n<meta property=\"og:description\" content=\"How to restore your MYSQL database at LCN.comFollow this simple guide to restoring your MYSQL database with a back-up copy.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.lcn.com\/support\/articles\/how-to-restore-your-mysql-database\/\" \/>\n<meta property=\"og:site_name\" content=\"Customer Support Guides - LCN\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/lcndotcom\" \/>\n<meta property=\"article:modified_time\" content=\"2020-09-09T11:11:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.lcn.com\/support\/wp-content\/uploads\/support-facebook-feed.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@lcndotcom\" \/>\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.lcn.com\/support\/articles\/how-to-restore-your-mysql-database\/\",\"url\":\"https:\/\/www.lcn.com\/support\/articles\/how-to-restore-your-mysql-database\/\",\"name\":\"How to restore your MYSQL database - LCN.com\",\"isPartOf\":{\"@id\":\"https:\/\/www.lcn.com\/support\/#website\"},\"datePublished\":\"2020-02-12T10:36:29+00:00\",\"dateModified\":\"2020-09-09T11:11:42+00:00\",\"description\":\"How to restore your MYSQL database at LCN.comFollow this simple guide to restoring your MYSQL database with a back-up copy.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.lcn.com\/support\/articles\/how-to-restore-your-mysql-database\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.lcn.com\/support\/articles\/how-to-restore-your-mysql-database\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.lcn.com\/support\/articles\/how-to-restore-your-mysql-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.lcn.com\/support\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to restore your MYSQL database\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.lcn.com\/support\/#website\",\"url\":\"https:\/\/www.lcn.com\/support\/\",\"name\":\"Customer Support Guides - LCN\",\"description\":\"- LCN\",\"publisher\":{\"@id\":\"https:\/\/www.lcn.com\/support\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.lcn.com\/support\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.lcn.com\/support\/#organization\",\"name\":\"LCN.com\",\"url\":\"https:\/\/www.lcn.com\/support\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.lcn.com\/support\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.lcn.com\/support\/wp-content\/uploads\/2020\/02\/ZF_-hcc3.jpg\",\"contentUrl\":\"https:\/\/www.lcn.com\/support\/wp-content\/uploads\/2020\/02\/ZF_-hcc3.jpg\",\"width\":461,\"height\":461,\"caption\":\"LCN.com\"},\"image\":{\"@id\":\"https:\/\/www.lcn.com\/support\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/lcndotcom\",\"https:\/\/x.com\/lcndotcom\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to restore your MYSQL database - LCN.com","description":"How to restore your MYSQL database at LCN.comFollow this simple guide to restoring your MYSQL database with a back-up copy.","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.lcn.com\/support\/articles\/how-to-restore-your-mysql-database\/","og_locale":"en_US","og_type":"article","og_title":"How to restore your MYSQL database - LCN.com","og_description":"How to restore your MYSQL database at LCN.comFollow this simple guide to restoring your MYSQL database with a back-up copy.","og_url":"https:\/\/www.lcn.com\/support\/articles\/how-to-restore-your-mysql-database\/","og_site_name":"Customer Support Guides - LCN","article_publisher":"https:\/\/www.facebook.com\/lcndotcom","article_modified_time":"2020-09-09T11:11:42+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/www.lcn.com\/support\/wp-content\/uploads\/support-facebook-feed.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_site":"@lcndotcom","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.lcn.com\/support\/articles\/how-to-restore-your-mysql-database\/","url":"https:\/\/www.lcn.com\/support\/articles\/how-to-restore-your-mysql-database\/","name":"How to restore your MYSQL database - LCN.com","isPartOf":{"@id":"https:\/\/www.lcn.com\/support\/#website"},"datePublished":"2020-02-12T10:36:29+00:00","dateModified":"2020-09-09T11:11:42+00:00","description":"How to restore your MYSQL database at LCN.comFollow this simple guide to restoring your MYSQL database with a back-up copy.","breadcrumb":{"@id":"https:\/\/www.lcn.com\/support\/articles\/how-to-restore-your-mysql-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.lcn.com\/support\/articles\/how-to-restore-your-mysql-database\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.lcn.com\/support\/articles\/how-to-restore-your-mysql-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.lcn.com\/support\/"},{"@type":"ListItem","position":2,"name":"How to restore your MYSQL database"}]},{"@type":"WebSite","@id":"https:\/\/www.lcn.com\/support\/#website","url":"https:\/\/www.lcn.com\/support\/","name":"Customer Support Guides - LCN","description":"- LCN","publisher":{"@id":"https:\/\/www.lcn.com\/support\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.lcn.com\/support\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.lcn.com\/support\/#organization","name":"LCN.com","url":"https:\/\/www.lcn.com\/support\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.lcn.com\/support\/#\/schema\/logo\/image\/","url":"https:\/\/www.lcn.com\/support\/wp-content\/uploads\/2020\/02\/ZF_-hcc3.jpg","contentUrl":"https:\/\/www.lcn.com\/support\/wp-content\/uploads\/2020\/02\/ZF_-hcc3.jpg","width":461,"height":461,"caption":"LCN.com"},"image":{"@id":"https:\/\/www.lcn.com\/support\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/lcndotcom","https:\/\/x.com\/lcndotcom"]}]}},"_links":{"self":[{"href":"https:\/\/www.lcn.com\/support\/wp-json\/wp\/v2\/ht-kb\/79","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.lcn.com\/support\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/www.lcn.com\/support\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.lcn.com\/support\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.lcn.com\/support\/wp-json\/wp\/v2\/comments?post=79"}],"version-history":[{"count":1,"href":"https:\/\/www.lcn.com\/support\/wp-json\/wp\/v2\/ht-kb\/79\/revisions"}],"predecessor-version":[{"id":1375,"href":"https:\/\/www.lcn.com\/support\/wp-json\/wp\/v2\/ht-kb\/79\/revisions\/1375"}],"wp:attachment":[{"href":"https:\/\/www.lcn.com\/support\/wp-json\/wp\/v2\/media?parent=79"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.lcn.com\/support\/wp-json\/wp\/v2\/ht-kb-category?post=79"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.lcn.com\/support\/wp-json\/wp\/v2\/ht-kb-tag?post=79"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}