{"id":764,"date":"2021-03-16T05:18:28","date_gmt":"2021-03-16T04:18:28","guid":{"rendered":"https:\/\/www.graber.cloud\/?p=764"},"modified":"2021-03-16T05:18:32","modified_gmt":"2021-03-16T04:18:32","slug":"restore-appservice-mysql-inapp-db","status":"publish","type":"post","link":"https:\/\/www.graber.cloud\/en\/restore-appservice-mysql-inapp-db\/","title":{"rendered":"Restore Azure App Service MySQL In-App Database"},"content":{"rendered":"<p>The Azure App Service offers the possibility to have backups created automatically by Azure. This backup also includes the MySQL in-app database, which is often used for a simple WordPress site. But when testing the restore, the surprise that WordPress needs to be reinstalled. This is because the database is not restored during the restore, only the backed up file structure. But more about that later. The following tutorial shows how you can test what problem occurs and how restoring the Azure App Service MySQL in-app database works anyway.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Deployment slot to restore the app service<\/h2>\n\n\n\n<p>This guide assumes that you have already successfully set up the App Service backup. <\/p>\n\n\n\n<p class=\"has-vivid-cyan-blue-color has-pale-cyan-blue-background-color has-text-color has-background translation-block\"><em>Note:<br>If that's not the case, you can check out <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/app-service\/manage-backup\/?WT.mc_id=AZ-MVP-5004129\" target=\"_self\" rel=\"noreferrer noopener\">this link<\/a> to learn how to set one it up in just a few steps!<\/em><br><br><a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/app-service\/manage-backup\/?WT.mc_id=AZ-MVP-5004129\" target=\"_self\" rel=\"noreferrer noopener\">https:\/\/docs.microsoft.com\/en-us\/azure\/app-service\/manage-backup\/<\/a><\/p>\n\n\n\n<p class=\"translation-block\">Open the app service for which you want to check the backup and restore. Then create a new <em>deployment slot<\/em>, or use an already existing one. In this example I use the already existing slot \"ygr-tech-blog-Dev\". Then assign <em>Traffic<\/em> as a percentage to the slot, for example 20.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"373\" src=\"\/wp-content\/uploads\/2021\/03\/01_Prepare-DeploymentSlot-1024x373.png\" alt=\"\" class=\"wp-image-766\" srcset=\"https:\/\/www.graber.cloud\/wp-content\/uploads\/2021\/03\/01_Prepare-DeploymentSlot-1024x373.png 1024w, https:\/\/www.graber.cloud\/wp-content\/uploads\/2021\/03\/01_Prepare-DeploymentSlot-300x109.png 300w, https:\/\/www.graber.cloud\/wp-content\/uploads\/2021\/03\/01_Prepare-DeploymentSlot-768x279.png 768w, https:\/\/www.graber.cloud\/wp-content\/uploads\/2021\/03\/01_Prepare-DeploymentSlot-1536x559.png 1536w, https:\/\/www.graber.cloud\/wp-content\/uploads\/2021\/03\/01_Prepare-DeploymentSlot-16x6.png 16w, https:\/\/www.graber.cloud\/wp-content\/uploads\/2021\/03\/01_Prepare-DeploymentSlot.png 1745w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Restore the App Service<\/h2>\n\n\n\n<p class=\"translation-block\">Now restore the app service to the <em>deployment slot<\/em> prepared earlier. Navigate to the menu item <em>Backup<\/em> and select <em>Restore.<\/em><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"640\" src=\"\/wp-content\/uploads\/2021\/03\/02_SelectBackupRestore-1024x640.png\" alt=\"\" class=\"wp-image-767\" srcset=\"https:\/\/www.graber.cloud\/wp-content\/uploads\/2021\/03\/02_SelectBackupRestore-1024x640.png 1024w, https:\/\/www.graber.cloud\/wp-content\/uploads\/2021\/03\/02_SelectBackupRestore-300x187.png 300w, https:\/\/www.graber.cloud\/wp-content\/uploads\/2021\/03\/02_SelectBackupRestore-768x480.png 768w, https:\/\/www.graber.cloud\/wp-content\/uploads\/2021\/03\/02_SelectBackupRestore-16x10.png 16w, https:\/\/www.graber.cloud\/wp-content\/uploads\/2021\/03\/02_SelectBackupRestore.png 1337w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"translation-block\">Now select the desired backup in the dropdown, which you want to restore and test. Under \"Restore destionation\" it is now extremely important that you select \"New or existing app\". In addition, you must make sure that you select the correct <em>deployment slot<\/em> in the following dropdown. Check the setting again to make sure you don't overwrite anything you still need, and a data loss results from that! At \"Ignore Conflicting Hostnames on Restore\" you select \"Yes\" and start the restore.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"785\" src=\"\/wp-content\/uploads\/2021\/03\/03_RestoreSettings-1024x785.png\" alt=\"\" class=\"wp-image-768\" srcset=\"https:\/\/www.graber.cloud\/wp-content\/uploads\/2021\/03\/03_RestoreSettings-1024x785.png 1024w, https:\/\/www.graber.cloud\/wp-content\/uploads\/2021\/03\/03_RestoreSettings-300x230.png 300w, https:\/\/www.graber.cloud\/wp-content\/uploads\/2021\/03\/03_RestoreSettings-768x589.png 768w, https:\/\/www.graber.cloud\/wp-content\/uploads\/2021\/03\/03_RestoreSettings-16x12.png 16w, https:\/\/www.graber.cloud\/wp-content\/uploads\/2021\/03\/03_RestoreSettings.png 1409w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"translation-block\">Once you see the message that Azure has successfully completed the restore, open the URL of the <em>deployment slot<\/em> in the browser of your choice. You will now notice that you are redirected to \"\/wp-admin\/install.php\" and you need to reinstall WordPress.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"967\" height=\"839\" src=\"\/wp-content\/uploads\/2021\/03\/04_WPInstall-appears.png\" alt=\"\" class=\"wp-image-769\" srcset=\"https:\/\/www.graber.cloud\/wp-content\/uploads\/2021\/03\/04_WPInstall-appears.png 967w, https:\/\/www.graber.cloud\/wp-content\/uploads\/2021\/03\/04_WPInstall-appears-300x260.png 300w, https:\/\/www.graber.cloud\/wp-content\/uploads\/2021\/03\/04_WPInstall-appears-768x666.png 768w, https:\/\/www.graber.cloud\/wp-content\/uploads\/2021\/03\/04_WPInstall-appears-14x12.png 14w\" sizes=\"auto, (max-width: 967px) 100vw, 967px\" \/><\/figure>\n\n\n\n<p>This is where restoring the app service MySQL In-App database comes into play.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">MySQL In-App database recovery check<\/h2>\n\n\n\n<p class=\"translation-block\">To check the MySQL In-App database, first go to the appropriate <em>deployment slot<\/em>, select \"MySQL In-App\" and then \"Manage\".<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"798\" height=\"375\" src=\"\/wp-content\/uploads\/2021\/03\/05_BrowseMySQLinApp.png\" alt=\"\" class=\"wp-image-770\" srcset=\"https:\/\/www.graber.cloud\/wp-content\/uploads\/2021\/03\/05_BrowseMySQLinApp.png 798w, https:\/\/www.graber.cloud\/wp-content\/uploads\/2021\/03\/05_BrowseMySQLinApp-300x141.png 300w, https:\/\/www.graber.cloud\/wp-content\/uploads\/2021\/03\/05_BrowseMySQLinApp-768x361.png 768w, https:\/\/www.graber.cloud\/wp-content\/uploads\/2021\/03\/05_BrowseMySQLinApp-16x8.png 16w\" sizes=\"auto, (max-width: 798px) 100vw, 798px\" \/><\/figure>\n\n\n\n<p>In the new tab you are now connected to the MySQL In-App database and can check it. By clicking on \"localdb\" you will see that this database is completely empty and has not been restored.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"961\" height=\"470\" src=\"\/wp-content\/uploads\/2021\/03\/06_LocalDBisEmpty.png\" alt=\"\" class=\"wp-image-771\" srcset=\"https:\/\/www.graber.cloud\/wp-content\/uploads\/2021\/03\/06_LocalDBisEmpty.png 961w, https:\/\/www.graber.cloud\/wp-content\/uploads\/2021\/03\/06_LocalDBisEmpty-300x147.png 300w, https:\/\/www.graber.cloud\/wp-content\/uploads\/2021\/03\/06_LocalDBisEmpty-768x376.png 768w, https:\/\/www.graber.cloud\/wp-content\/uploads\/2021\/03\/06_LocalDBisEmpty-16x8.png 16w\" sizes=\"auto, (max-width: 961px) 100vw, 961px\" \/><\/figure>\n\n\n\n<p>Keep this tab open, because you will need it again later. For restoring the MySQL In-App database you now need to follow additional manual steps.<\/p>\n\n\n\n<p class=\"has-vivid-cyan-blue-color has-pale-cyan-blue-background-color has-text-color has-background translation-block\"><em>Note:<br>I've already submitted feedback to Microsoft that restoring the in-app database should be available as an option.<\/em> <em>If you'd like to support the idea, you can vote at this link.<\/em><br><br><a href=\"https:\/\/feedback.azure.com\/forums\/34192--general-feedback\/suggestions\/42923787-restore-of-app-service-mysql-in-app-database\/?WT.mc_id=AZ-MVP-5004129\" target=\"_self\" rel=\"noreferrer noopener\">Restore of App Service MySQL In-App Database - Customer Feedback for ACE Community Tooling (azure.com)<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Manually restore the app service MySQL In-App database<\/h2>\n\n\n\n<p class=\"translation-block\">To restore the database manually, you need to download the corresponding backup. To do this, switch back to the original <em>deployment slot<\/em> (production) on which you configured the backup. Then select the desired backup under \"Backups\" and download it to your local computer via \"Download\".<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"569\" src=\"\/wp-content\/uploads\/2021\/03\/07_DownloadBackupFile-1024x569.png\" alt=\"\" class=\"wp-image-772\" srcset=\"https:\/\/www.graber.cloud\/wp-content\/uploads\/2021\/03\/07_DownloadBackupFile-1024x569.png 1024w, https:\/\/www.graber.cloud\/wp-content\/uploads\/2021\/03\/07_DownloadBackupFile-300x167.png 300w, https:\/\/www.graber.cloud\/wp-content\/uploads\/2021\/03\/07_DownloadBackupFile-768x427.png 768w, https:\/\/www.graber.cloud\/wp-content\/uploads\/2021\/03\/07_DownloadBackupFile-16x9.png 16w, https:\/\/www.graber.cloud\/wp-content\/uploads\/2021\/03\/07_DownloadBackupFile.png 1114w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Check the downloaded ZIP file if it contains a file named \"LocalMySqlDatabase.sql\". If it does not, the Azure backup did not back up your database. However, the MySQL In-App database should always be automatically included in the backup. If the file is present, extract this file from the ZIP and continue.<\/p>\n\n\n\n<p>Next you will import the database file from the backup manually. To do this, go back to the MySQL database tab, select the \"localdb\" on the left side, click on \"Import\" at the top and select the previously extracted database file in \"Choose File\". Then start the import of the database.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"975\" height=\"443\" src=\"\/wp-content\/uploads\/2021\/03\/08_ImportDBDumpFile.png\" alt=\"\" class=\"wp-image-773\" srcset=\"https:\/\/www.graber.cloud\/wp-content\/uploads\/2021\/03\/08_ImportDBDumpFile.png 975w, https:\/\/www.graber.cloud\/wp-content\/uploads\/2021\/03\/08_ImportDBDumpFile-300x136.png 300w, https:\/\/www.graber.cloud\/wp-content\/uploads\/2021\/03\/08_ImportDBDumpFile-768x349.png 768w, https:\/\/www.graber.cloud\/wp-content\/uploads\/2021\/03\/08_ImportDBDumpFile-16x7.png 16w\" sizes=\"auto, (max-width: 975px) 100vw, 975px\" \/><\/figure>\n\n\n\n<p class=\"translation-block\">After a few moments the success message of the import job appears. Now open the URL of the <em>deployment slot<\/em> again in the browser of your choice. You will now notice that you are no longer redirected to \"\/wp-admin\/install.php\" and therefore no reinstallation of WordPress is necessary. You have successfully validated your backup and restore of the Azure App Service MySQL In-App database.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"623\" src=\"\/wp-content\/uploads\/2021\/03\/09_RestoreSuccessTest-1024x623.png\" alt=\"\" class=\"wp-image-774\" srcset=\"https:\/\/www.graber.cloud\/wp-content\/uploads\/2021\/03\/09_RestoreSuccessTest-1024x623.png 1024w, https:\/\/www.graber.cloud\/wp-content\/uploads\/2021\/03\/09_RestoreSuccessTest-300x182.png 300w, https:\/\/www.graber.cloud\/wp-content\/uploads\/2021\/03\/09_RestoreSuccessTest-768x467.png 768w, https:\/\/www.graber.cloud\/wp-content\/uploads\/2021\/03\/09_RestoreSuccessTest-16x10.png 16w, https:\/\/www.graber.cloud\/wp-content\/uploads\/2021\/03\/09_RestoreSuccessTest.png 1523w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"has-vivid-cyan-blue-color has-pale-cyan-blue-background-color has-text-color has-background translation-block\"><em>Note:<br>I recommend performing this test regularly to continuously check the functionality of the backup as well as the restore.<\/em><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusion<\/h2>\n\n\n\n<p class=\"translation-block\">The backup of the Azure App Service, as well as its restoration, is very reliable and simple in my opinion. The fact that the MySQL In-App database is automatically backed up directly is very good. However, the whole thing would be even more helpful if this backup of the database could also be included directly during the restore. So this would save the additional manual effort. I have already placed a corresponding feedback with Microsoft, <a href=\"https:\/\/feedback.azure.com\/forums\/34192--general-feedback\/suggestions\/42923787-restore-of-app-service-mysql-in-app-database\/?WT.mc_id=AZ-MVP-5004129\" target=\"_self\" rel=\"noreferrer noopener\">see here!<\/a><\/p>","protected":false},"excerpt":{"rendered":"<p>The Azure App Service offers the possibility to have backups created automatically by Azure. This backup also includes the MySQL in-app database, which is often used for a simple WordPress site. But when testing the restore, the surprise that WordPress needs to be reinstalled. This is because the database is not restored during the restore, only the backed up file structure. But more about that later. The following tutorial shows how you can test what problem occurs and how restoring the Azure App Service MySQL in-app database works anyway.<\/p>","protected":false},"author":1,"featured_media":781,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[7],"tags":[75,3,14,71,61],"class_list":["post-764","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology","tag-appservice","tag-azure","tag-howto","tag-paas","tag-webapp"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.0 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Wiederherstellen der Azure App Service MySQL In-App Datenbank<\/title>\n<meta name=\"description\" content=\"Lerne Schritt f\u00fcr Schritt, wie das Wiederherstellen der Azure App Service MySQL In-App Datenbank funktioniert. - by Yannic Graber\" \/>\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.graber.cloud\/en\/restore-appservice-mysql-inapp-db\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Wiederherstellen der Azure App Service MySQL In-App Datenbank\" \/>\n<meta property=\"og:description\" content=\"Lerne Schritt f\u00fcr Schritt, wie das Wiederherstellen der Azure App Service MySQL In-App Datenbank funktioniert. - by Yannic Graber\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.graber.cloud\/en\/restore-appservice-mysql-inapp-db\/\" \/>\n<meta property=\"og:site_name\" content=\"Cloud Business &amp; Technology\" \/>\n<meta property=\"article:published_time\" content=\"2021-03-16T04:18:28+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-03-16T04:18:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.graber.cloud\/wp-content\/uploads\/2021\/03\/Header-AppSvc-MySQL-Restore-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1751\" \/>\n\t<meta property=\"og:image:height\" content=\"916\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Yannic Graber\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@GraberYannic\" \/>\n<meta name=\"twitter:site\" content=\"@GraberYannic\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Yannic Graber\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.graber.cloud\/en\/restore-appservice-mysql-inapp-db\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.graber.cloud\/en\/restore-appservice-mysql-inapp-db\/\"},\"author\":{\"name\":\"Yannic Graber\",\"@id\":\"https:\/\/www.graber.cloud\/en\/#\/schema\/person\/50b8d88e3d433af9d16d73f354d897fe\"},\"headline\":\"Wiederherstellen der Azure App Service MySQL In-App Datenbank\",\"datePublished\":\"2021-03-16T04:18:28+00:00\",\"dateModified\":\"2021-03-16T04:18:32+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.graber.cloud\/en\/restore-appservice-mysql-inapp-db\/\"},\"wordCount\":837,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.graber.cloud\/en\/#\/schema\/person\/50b8d88e3d433af9d16d73f354d897fe\"},\"image\":{\"@id\":\"https:\/\/www.graber.cloud\/en\/restore-appservice-mysql-inapp-db\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.graber.cloud\/wp-content\/uploads\/2021\/03\/Header-AppSvc-MySQL-Restore-1.png\",\"keywords\":[\"AppService\",\"Azure\",\"HowTo\",\"PaaS\",\"WebApp\"],\"articleSection\":[\"Technology\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.graber.cloud\/en\/restore-appservice-mysql-inapp-db\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.graber.cloud\/en\/restore-appservice-mysql-inapp-db\/\",\"url\":\"https:\/\/www.graber.cloud\/en\/restore-appservice-mysql-inapp-db\/\",\"name\":\"Wiederherstellen der Azure App Service MySQL In-App Datenbank\",\"isPartOf\":{\"@id\":\"https:\/\/www.graber.cloud\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.graber.cloud\/en\/restore-appservice-mysql-inapp-db\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.graber.cloud\/en\/restore-appservice-mysql-inapp-db\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.graber.cloud\/wp-content\/uploads\/2021\/03\/Header-AppSvc-MySQL-Restore-1.png\",\"datePublished\":\"2021-03-16T04:18:28+00:00\",\"dateModified\":\"2021-03-16T04:18:32+00:00\",\"description\":\"Lerne Schritt f\u00fcr Schritt, wie das Wiederherstellen der Azure App Service MySQL In-App Datenbank funktioniert. - by Yannic Graber\",\"breadcrumb\":{\"@id\":\"https:\/\/www.graber.cloud\/en\/restore-appservice-mysql-inapp-db\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.graber.cloud\/en\/restore-appservice-mysql-inapp-db\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.graber.cloud\/en\/restore-appservice-mysql-inapp-db\/#primaryimage\",\"url\":\"https:\/\/www.graber.cloud\/wp-content\/uploads\/2021\/03\/Header-AppSvc-MySQL-Restore-1.png\",\"contentUrl\":\"https:\/\/www.graber.cloud\/wp-content\/uploads\/2021\/03\/Header-AppSvc-MySQL-Restore-1.png\",\"width\":1751,\"height\":916,\"caption\":\"Header-AppSvc-MySQL-Restore\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.graber.cloud\/en\/restore-appservice-mysql-inapp-db\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.graber.cloud\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Wiederherstellen der Azure App Service MySQL In-App Datenbank\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.graber.cloud\/en\/#website\",\"url\":\"https:\/\/www.graber.cloud\/en\/\",\"name\":\"Cloud Business &amp; Technology\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.graber.cloud\/en\/#\/schema\/person\/50b8d88e3d433af9d16d73f354d897fe\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.graber.cloud\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/www.graber.cloud\/en\/#\/schema\/person\/50b8d88e3d433af9d16d73f354d897fe\",\"name\":\"Yannic Graber\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.graber.cloud\/en\/#\/schema\/person\/image\/\",\"url\":\"\/wp-content\/uploads\/2020\/03\/Techdata-Yannic_Graber_downsized.jpg\",\"contentUrl\":\"\/wp-content\/uploads\/2020\/03\/Techdata-Yannic_Graber_downsized.jpg\",\"width\":264,\"height\":267,\"caption\":\"Yannic Graber\"},\"logo\":{\"@id\":\"https:\/\/www.graber.cloud\/en\/#\/schema\/person\/image\/\"},\"description\":\"Experienced technical cloud consultant, certified Azure solutions architect and MCT, focusing on Microsoft Cloud related topics. As a graduate business informatics specialist HF, I consider both the technology and economics. Born in Lucerne, Switzerland and still living there.\",\"sameAs\":[\"https:\/\/www.graber.cloud\",\"https:\/\/www.linkedin.com\/in\/ygr\/\",\"https:\/\/x.com\/GraberYannic\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Restore Azure App Service MySQL In-App Database","description":"Lerne Schritt f\u00fcr Schritt, wie das Wiederherstellen der Azure App Service MySQL In-App Datenbank funktioniert. - by Yannic Graber","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.graber.cloud\/en\/restore-appservice-mysql-inapp-db\/","og_locale":"en_GB","og_type":"article","og_title":"Wiederherstellen der Azure App Service MySQL In-App Datenbank","og_description":"Lerne Schritt f\u00fcr Schritt, wie das Wiederherstellen der Azure App Service MySQL In-App Datenbank funktioniert. - by Yannic Graber","og_url":"https:\/\/www.graber.cloud\/en\/restore-appservice-mysql-inapp-db\/","og_site_name":"Cloud Business &amp; Technology","article_published_time":"2021-03-16T04:18:28+00:00","article_modified_time":"2021-03-16T04:18:32+00:00","og_image":[{"width":1751,"height":916,"url":"https:\/\/www.graber.cloud\/wp-content\/uploads\/2021\/03\/Header-AppSvc-MySQL-Restore-1.png","type":"image\/png"}],"author":"Yannic Graber","twitter_card":"summary_large_image","twitter_creator":"@GraberYannic","twitter_site":"@GraberYannic","twitter_misc":{"Written by":"Yannic Graber","Estimated reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.graber.cloud\/en\/restore-appservice-mysql-inapp-db\/#article","isPartOf":{"@id":"https:\/\/www.graber.cloud\/en\/restore-appservice-mysql-inapp-db\/"},"author":{"name":"Yannic Graber","@id":"https:\/\/www.graber.cloud\/en\/#\/schema\/person\/50b8d88e3d433af9d16d73f354d897fe"},"headline":"Wiederherstellen der Azure App Service MySQL In-App Datenbank","datePublished":"2021-03-16T04:18:28+00:00","dateModified":"2021-03-16T04:18:32+00:00","mainEntityOfPage":{"@id":"https:\/\/www.graber.cloud\/en\/restore-appservice-mysql-inapp-db\/"},"wordCount":837,"commentCount":0,"publisher":{"@id":"https:\/\/www.graber.cloud\/en\/#\/schema\/person\/50b8d88e3d433af9d16d73f354d897fe"},"image":{"@id":"https:\/\/www.graber.cloud\/en\/restore-appservice-mysql-inapp-db\/#primaryimage"},"thumbnailUrl":"https:\/\/www.graber.cloud\/wp-content\/uploads\/2021\/03\/Header-AppSvc-MySQL-Restore-1.png","keywords":["AppService","Azure","HowTo","PaaS","WebApp"],"articleSection":["Technology"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.graber.cloud\/en\/restore-appservice-mysql-inapp-db\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.graber.cloud\/en\/restore-appservice-mysql-inapp-db\/","url":"https:\/\/www.graber.cloud\/en\/restore-appservice-mysql-inapp-db\/","name":"Restore Azure App Service MySQL In-App Database","isPartOf":{"@id":"https:\/\/www.graber.cloud\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.graber.cloud\/en\/restore-appservice-mysql-inapp-db\/#primaryimage"},"image":{"@id":"https:\/\/www.graber.cloud\/en\/restore-appservice-mysql-inapp-db\/#primaryimage"},"thumbnailUrl":"https:\/\/www.graber.cloud\/wp-content\/uploads\/2021\/03\/Header-AppSvc-MySQL-Restore-1.png","datePublished":"2021-03-16T04:18:28+00:00","dateModified":"2021-03-16T04:18:32+00:00","description":"Lerne Schritt f\u00fcr Schritt, wie das Wiederherstellen der Azure App Service MySQL In-App Datenbank funktioniert. - by Yannic Graber","breadcrumb":{"@id":"https:\/\/www.graber.cloud\/en\/restore-appservice-mysql-inapp-db\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.graber.cloud\/en\/restore-appservice-mysql-inapp-db\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.graber.cloud\/en\/restore-appservice-mysql-inapp-db\/#primaryimage","url":"https:\/\/www.graber.cloud\/wp-content\/uploads\/2021\/03\/Header-AppSvc-MySQL-Restore-1.png","contentUrl":"https:\/\/www.graber.cloud\/wp-content\/uploads\/2021\/03\/Header-AppSvc-MySQL-Restore-1.png","width":1751,"height":916,"caption":"Header-AppSvc-MySQL-Restore"},{"@type":"BreadcrumbList","@id":"https:\/\/www.graber.cloud\/en\/restore-appservice-mysql-inapp-db\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.graber.cloud\/en\/"},{"@type":"ListItem","position":2,"name":"Wiederherstellen der Azure App Service MySQL In-App Datenbank"}]},{"@type":"WebSite","@id":"https:\/\/www.graber.cloud\/en\/#website","url":"https:\/\/www.graber.cloud\/en\/","name":"Cloud Business &amp; Technology","description":"","publisher":{"@id":"https:\/\/www.graber.cloud\/en\/#\/schema\/person\/50b8d88e3d433af9d16d73f354d897fe"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.graber.cloud\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":["Person","Organization"],"@id":"https:\/\/www.graber.cloud\/en\/#\/schema\/person\/50b8d88e3d433af9d16d73f354d897fe","name":"Yannic Graber","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.graber.cloud\/en\/#\/schema\/person\/image\/","url":"\/wp-content\/uploads\/2020\/03\/Techdata-Yannic_Graber_downsized.jpg","contentUrl":"\/wp-content\/uploads\/2020\/03\/Techdata-Yannic_Graber_downsized.jpg","width":264,"height":267,"caption":"Yannic Graber"},"logo":{"@id":"https:\/\/www.graber.cloud\/en\/#\/schema\/person\/image\/"},"description":"Experienced technical cloud consultant, certified Azure solutions architect and MCT, focusing on Microsoft Cloud related topics. As a graduate business informatics specialist HF, I consider both the technology and economics. Born in Lucerne, Switzerland and still living there.","sameAs":["https:\/\/www.graber.cloud","https:\/\/www.linkedin.com\/in\/ygr\/","https:\/\/x.com\/GraberYannic"]}]}},"_links":{"self":[{"href":"https:\/\/www.graber.cloud\/en\/wp-json\/wp\/v2\/posts\/764","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.graber.cloud\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.graber.cloud\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.graber.cloud\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.graber.cloud\/en\/wp-json\/wp\/v2\/comments?post=764"}],"version-history":[{"count":4,"href":"https:\/\/www.graber.cloud\/en\/wp-json\/wp\/v2\/posts\/764\/revisions"}],"predecessor-version":[{"id":779,"href":"https:\/\/www.graber.cloud\/en\/wp-json\/wp\/v2\/posts\/764\/revisions\/779"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.graber.cloud\/en\/wp-json\/wp\/v2\/media\/781"}],"wp:attachment":[{"href":"https:\/\/www.graber.cloud\/en\/wp-json\/wp\/v2\/media?parent=764"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.graber.cloud\/en\/wp-json\/wp\/v2\/categories?post=764"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.graber.cloud\/en\/wp-json\/wp\/v2\/tags?post=764"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}