{"id":24726,"date":"2022-12-05T07:41:42","date_gmt":"2022-12-05T02:11:42","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-backup-restore-on-cloudsql-instances\/"},"modified":"2022-12-05T07:41:42","modified_gmt":"2022-12-05T02:11:42","slug":"solved-backup-restore-on-cloudsql-instances","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-backup-restore-on-cloudsql-instances\/","title":{"rendered":"[Solved] Backup\/Restore on CloudSQL instances"},"content":{"rendered":"<p> [ad_1]<br \/>\n<\/p>\n<div id=\"answer-66894896\" class=\"answer js-answer accepted-answer js-accepted-answer\" data-answerid=\"66894896\" data-parentid=\"66875016\" data-score=\"1\" data-position-on-page=\"1\" data-highest-scored=\"1\" data-question-has-accepted-highest-score=\"1\" itemprop=\"acceptedAnswer\" itemscope itemtype=\"https:\/\/schema.org\/Answer\">\n<div class=\"post-layout\">\n<div class=\"votecell post-layout--left\"><\/div>\n<div class=\"answercell post-layout--right\">\n<div class=\"js-endorsements\" data-for-answer=\"66894896\">\n<\/div>\n<div class=\"s-prose js-post-body\" itemprop=\"text\">\n<p>Here I address you questions:<\/p>\n<p><strong>1. Any way to check the size of existing databases in CloudSQL instances?<\/strong><\/p>\n<p>Yes, there is. This depends on the database engine you are using(mysql, postgres or mssql)<\/p>\n<p>For <strong>mysql<\/strong>, you can run:<\/p>\n<pre><code>SELECT table_schema \"DB Name\",\n        ROUND(SUM(data_length + index_length) \/ 1024 \/ 1024, 1) \"DB Size in MB\" \nFROM information_schema.tables \nGROUP BY table_schema; \n<\/code><\/pre>\n<p>For <strong>postgres<\/strong>, you can run:<\/p>\n<pre><code>SELECT pg_size_pretty(pg_database_size('Database Name'));\n<\/code><\/pre>\n<p>For <strong>mssql<\/strong>, you can run:<\/p>\n<pre><code>SELECT \n      database_name = DB_NAME(database_id)\n    , log_size_mb = CAST(SUM(CASE WHEN type_desc=\"LOG\" THEN size END) * 8. \/ 1024 AS DECIMAL(8,2))\n    , row_size_mb = CAST(SUM(CASE WHEN type_desc=\"ROWS\" THEN size END) * 8. \/ 1024 AS DECIMAL(8,2))\n    , total_size_mb = CAST(SUM(size) * 8. \/ 1024 AS DECIMAL(8,2))\nFROM sys.master_files WITH(NOWAIT)\nWHERE database_id = DB_ID() -- for current db \nGROUP BY database_id\n<\/code><\/pre>\n<p><strong>2.Where the backup is stored? Is it Cloud Storage or the DB disk?<\/strong><\/p>\n<p>Cloud Storage. When you <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/cloud.google.com\/sql\/docs\/mysql\/import-export\/exporting\">make a Cloud SQL export<\/a>, the export file is<br \/>\nstored in Cloud Storage. From Cloud Storage, you can download\/move<br \/>\nit to a different location.<\/p>\n<p><strong>3. Can we access the CloudSQL instance with a private IP from my desktop using IAP tunneling ?<\/strong><\/p>\n<p>No, the IAP tunneling aka IAP for TCP forwarding is intended to be used with Google Cloud compute engine instances.<br \/>\nQuoting the <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/cloud.google.com\/iap\/docs\/tcp-forwarding-overview#how-tcp-forwarding-works\">documentation<\/a>:<\/p>\n<blockquote>\n<p>IAP&#8217;s TCP forwarding feature allows users to connect to arbitrary TCP<br \/>\nports on Compute Engine instances.<\/p>\n<\/blockquote>\n<p>There is also <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/issuetracker.google.com\/176209851\">this feature request<\/a> to extend the capabilities of IAP TCP forwarding to cover Cloud SQL instances. I would recommend then to star the issue tracker and share your feedback so that the thread relevance increases.<\/p>\n<p>An alternative to connect to a Cloud SQL instance with only private ip, would be to use a bastion host with an external public address that forwards all TCP traffic to your Cloud SQL instance.<\/p>\n<p>I hope you find this useful.<\/p>\n<\/p><\/div>\n<div class=\"mt24\"><\/div>\n<\/div>\n<p>            <span class=\"d-none\" itemprop=\"commentCount\">2<\/span> <\/p><\/div>\n<\/div>\n<p>[ad_2]<\/p>\n<p>solved Backup\/Restore on CloudSQL instances <\/p>\n","protected":false},"excerpt":{"rendered":"<p>[ad_1] Here I address you questions: 1. Any way to check the size of existing databases in CloudSQL instances? Yes, there is. This depends on the database engine you are using(mysql, postgres or mssql) For mysql, you can run: SELECT table_schema &#8220;DB Name&#8221;, ROUND(SUM(data_length + index_length) \/ 1024 \/ 1024, 1) &#8220;DB Size in MB&#8221; &#8230; <a title=\"[Solved] Backup\/Restore on CloudSQL instances\" class=\"read-more\" href=\"https:\/\/jassweb.com\/solved\/solved-backup-restore-on-cloudsql-instances\/\" aria-label=\"More on [Solved] Backup\/Restore on CloudSQL instances\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[320],"tags":[5219,5218,340,623,5220],"class_list":["post-24726","post","type-post","status-publish","format-standard","hentry","category-solved","tag-database-backups","tag-google-cloud-sql","tag-mysql","tag-postgresql","tag-tunnel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>[Solved] Backup\/Restore on CloudSQL instances - JassWeb<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/jassweb.com\/solved\/solved-backup-restore-on-cloudsql-instances\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] Backup\/Restore on CloudSQL instances - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] Here I address you questions: 1. Any way to check the size of existing databases in CloudSQL instances? Yes, there is. This depends on the database engine you are using(mysql, postgres or mssql) For mysql, you can run: SELECT table_schema &quot;DB Name&quot;, ROUND(SUM(data_length + index_length) \/ 1024 \/ 1024, 1) &quot;DB Size in MB&quot; ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-backup-restore-on-cloudsql-instances\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2022-12-05T02:11:42+00:00\" \/>\n<meta name=\"author\" content=\"Kirat\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kirat\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/solved-backup-restore-on-cloudsql-instances\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/solved-backup-restore-on-cloudsql-instances\\\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/#\\\/schema\\\/person\\\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] Backup\\\/Restore on CloudSQL instances\",\"datePublished\":\"2022-12-05T02:11:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/solved-backup-restore-on-cloudsql-instances\\\/\"},\"wordCount\":239,\"publisher\":{\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/#organization\"},\"keywords\":[\"database-backups\",\"google-cloud-sql\",\"mysql\",\"postgresql\",\"tunnel\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/solved-backup-restore-on-cloudsql-instances\\\/\",\"url\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/solved-backup-restore-on-cloudsql-instances\\\/\",\"name\":\"[Solved] Backup\\\/Restore on CloudSQL instances - JassWeb\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/#website\"},\"datePublished\":\"2022-12-05T02:11:42+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/solved-backup-restore-on-cloudsql-instances\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/jassweb.com\\\/solved\\\/solved-backup-restore-on-cloudsql-instances\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/solved-backup-restore-on-cloudsql-instances\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] Backup\\\/Restore on CloudSQL instances\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/#website\",\"url\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/\",\"name\":\"JassWeb\",\"description\":\"Build High-quality Websites\",\"publisher\":{\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/#organization\",\"name\":\"Jass Web\",\"url\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/jassweb.com\\\/wp-content\\\/uploads\\\/2021\\\/02\\\/jass-website-logo-1.png\",\"contentUrl\":\"https:\\\/\\\/jassweb.com\\\/wp-content\\\/uploads\\\/2021\\\/02\\\/jass-website-logo-1.png\",\"width\":693,\"height\":132,\"caption\":\"Jass Web\"},\"image\":{\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/#\\\/schema\\\/person\\\/65c9c7b7958150c0dc8371fa35dd7c31\",\"name\":\"Kirat\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/wp-content\\\/litespeed\\\/avatar\\\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1777008400\",\"url\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/wp-content\\\/litespeed\\\/avatar\\\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1777008400\",\"contentUrl\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/wp-content\\\/litespeed\\\/avatar\\\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1777008400\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\\\/\\\/jassweb.com\"],\"url\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/author\\\/jaspritsinghghumangmail-com\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Solved] Backup\/Restore on CloudSQL instances - JassWeb","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:\/\/jassweb.com\/solved\/solved-backup-restore-on-cloudsql-instances\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] Backup\/Restore on CloudSQL instances - JassWeb","og_description":"[ad_1] Here I address you questions: 1. Any way to check the size of existing databases in CloudSQL instances? Yes, there is. This depends on the database engine you are using(mysql, postgres or mssql) For mysql, you can run: SELECT table_schema \"DB Name\", ROUND(SUM(data_length + index_length) \/ 1024 \/ 1024, 1) \"DB Size in MB\" ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-backup-restore-on-cloudsql-instances\/","og_site_name":"JassWeb","article_published_time":"2022-12-05T02:11:42+00:00","author":"Kirat","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirat","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jassweb.com\/solved\/solved-backup-restore-on-cloudsql-instances\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-backup-restore-on-cloudsql-instances\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] Backup\/Restore on CloudSQL instances","datePublished":"2022-12-05T02:11:42+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-backup-restore-on-cloudsql-instances\/"},"wordCount":239,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["database-backups","google-cloud-sql","mysql","postgresql","tunnel"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-backup-restore-on-cloudsql-instances\/","url":"https:\/\/jassweb.com\/solved\/solved-backup-restore-on-cloudsql-instances\/","name":"[Solved] Backup\/Restore on CloudSQL instances - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2022-12-05T02:11:42+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-backup-restore-on-cloudsql-instances\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-backup-restore-on-cloudsql-instances\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-backup-restore-on-cloudsql-instances\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] Backup\/Restore on CloudSQL instances"}]},{"@type":"WebSite","@id":"https:\/\/jassweb.com\/solved\/#website","url":"https:\/\/jassweb.com\/solved\/","name":"JassWeb","description":"Build High-quality Websites","publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jassweb.com\/solved\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/jassweb.com\/solved\/#organization","name":"Jass Web","url":"https:\/\/jassweb.com\/solved\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/","url":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","contentUrl":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","width":693,"height":132,"caption":"Jass Web"},"image":{"@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31","name":"Kirat","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1777008400","url":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1777008400","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1777008400","caption":"Kirat"},"sameAs":["http:\/\/jassweb.com"],"url":"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/"}]}},"_links":{"self":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/24726","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/comments?post=24726"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/24726\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=24726"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=24726"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=24726"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}