How to dump my Mysql in-app database?

Question

I was reading some instructions about Mysql In-app on https://github.com/projectkudu/kudu/wiki/MySQL-in-app

And as discribed there, I configured my public credentials for my SCM and I execute a POST to myapp.scm.azurewebsites.net/mysqlutils/dump
The response was 200, but I don't know how I can get the dump file.

What I need to do to get my dump file?

The response body when I POST to dump:

-- MySQL dump 10.13  Distrib 5.7.9, for Win32 (AMD64)
--
-- Host: 127.0.0.1    Database: localdb
-- ------------------------------------------------------
-- Server version 5.7.9

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2020-05-06 14:32:04

Answer

Hi @JeanCarlosdeAlmeida-3435,

I can confirm that's the correct way to do it. I created a wordpress site to host in Azure and POST'ed to /mysqlutils/dump. For my response, I received the scripts and SQL commands to create the data (see snippet below).

/*!40103 SET TIME_ZONE='+00:00' */;  
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;  
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;  
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;  
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;  
  
--  
-- Table structure for table `wp_commentmeta`  
--  
  
DROP TABLE IF EXISTS `wp_commentmeta`;  
/*!40101 SET @saved_cs_client     = @@character_set_client */;  
/*!40101 SET character_set_client = utf8 */;  
CREATE TABLE `wp_commentmeta` (  
  `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,  
  `comment_id` bigint(20) unsigned NOT NULL DEFAULT '0',  
  `meta_key` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,  
  `meta_value` longtext COLLATE utf8mb4_unicode_520_ci,  
  PRIMARY KEY (`meta_id`),  
  KEY `comment_id` (`comment_id`),  
  KEY `meta_key` (`meta_key`(191))  
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci;  
/*!40101 SET character_set_client = @saved_cs_client */;  
  
--  
-- Dumping data for table `wp_commentmeta`  
--

I would verify you have your database files in D:\home\data\mysql.

7982-2020-05-07-14-25-48-diagnostic-console-microsoft-e.png

Share via

How to dump my Mysql in-app database?

1 answer

Your answer