{"id":755,"date":"2019-05-09T22:36:21","date_gmt":"2019-05-09T13:36:21","guid":{"rendered":"https:\/\/itips.krsw.biz\/?p=755"},"modified":"2019-05-09T22:36:21","modified_gmt":"2019-05-09T13:36:21","slug":"aws-rds-recommended-import-method","status":"publish","type":"post","link":"https:\/\/itips.krsw.biz\/en\/aws-rds-recommended-import-method\/","title":{"rendered":"Recommended way of moving DB in AWS(RDS)"},"content":{"rendered":"

\"Recommended<\/p>\n

How can we apply data from local environment to RDS of AWS.
\nMoving data is a problem for AWS beginner.
\nSo this article shows recommended way of moving DB in AWS(RDS).<\/p>\n


\n<\/br><\/p>\n

How to move DB<\/h2>\n

Regarding AWS site, it is recommended to export and import.<\/p>\n

\n To import data from an existing database to an RDS DB instance:
\n 1. Export data from the source database.
\n 2. Upload the exported data.
\n 3. Import the uploaded data into an RDS DB instance.
\n Amazon RDS Import Data<\/a>\n<\/p><\/blockquote>\n

It is written like using a command-line utility<\/strong>. It means to use mysqldump<\/code> command.<\/p>\n

\n You can use several different techniques to import data into an Amazon RDS for MySQL DB instance. The best approach depends on the source of the data, the amount of data, and whether the import is done one time or is ongoing.
\n [Source] Existing MySQL or MariaDB database
\n [Technique] Copy the data directly to your Amazon RDS MySQL DB instance using a command-line utility.
\n Importing Data into a MySQL DB Instance - Amazon Relational Database Service<\/a>\n<\/p><\/blockquote>\n

<\/br><\/p>\n

Using GUI instead of command<\/h2>\n

If you use tool, I recommend you to use MySQL Workbench<\/a>.
\nYou can execute this 2 steps.<\/p>\n

    \n
  1. Connect source DB (local). Then export data.<\/li>\n
  2. Connect destination DB. Then import data.<\/li>\n<\/ol>\n

    <\/br><\/p>\n

    Finally<\/h2>\n
      \n
    • For moving data to AWS(RDS), it is recommended to export and import. <\/li>\n
    • If you use tool, I recommend you to use MySQL Workbench.<\/li>\n<\/ul>\n

      <\/br><\/p>\n","protected":false},"excerpt":{"rendered":"

      How can we apply data from local environment to RDS of AWS. Moving data is a problem for AWS beginne … <\/p>\n","protected":false},"author":1,"featured_media":666,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_locale":"en_US","_original_post":"753","footnotes":""},"categories":[14],"tags":[39,85,69],"class_list":["post-755","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-db","tag-amazon","tag-aws","tag-mysql","en-US"],"yoast_head":"\nRecommended way of moving DB in AWS(RDS) - ITips\u30b7\u30b9\u30c6\u30e0\u30bd\u30ea\u30e5\u30fc\u30b7\u30e7\u30f3\u30ba<\/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:\/\/itips.krsw.biz\/en\/aws-rds-recommended-import-method\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Recommended way of moving DB in AWS(RDS) - ITips\u30b7\u30b9\u30c6\u30e0\u30bd\u30ea\u30e5\u30fc\u30b7\u30e7\u30f3\u30ba\" \/>\n<meta property=\"og:description\" content=\"How can we apply data from local environment to RDS of AWS. Moving data is a problem for AWS beginne ...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/itips.krsw.biz\/en\/aws-rds-recommended-import-method\/\" \/>\n<meta property=\"og:site_name\" content=\"ITips\u30b7\u30b9\u30c6\u30e0\u30bd\u30ea\u30e5\u30fc\u30b7\u30e7\u30f3\u30ba\" \/>\n<meta property=\"article:published_time\" content=\"2019-05-09T13:36:21+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/itips.krsw.biz\/wp-content\/uploads\/2019\/04\/amazon_1555423788.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"1159\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"ITips\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/karasan_itips\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"ITips\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/itips.krsw.biz\\\/en\\\/aws-rds-recommended-import-method\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/itips.krsw.biz\\\/en\\\/aws-rds-recommended-import-method\\\/\"},\"author\":{\"name\":\"ITips\",\"@id\":\"https:\\\/\\\/itips.krsw.biz\\\/#\\\/schema\\\/person\\\/981ee81393a64c1b43f0b62d91998f0c\"},\"headline\":\"Recommended way of moving DB in AWS(RDS)\",\"datePublished\":\"2019-05-09T13:36:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/itips.krsw.biz\\\/en\\\/aws-rds-recommended-import-method\\\/\"},\"wordCount\":237,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/itips.krsw.biz\\\/en\\\/aws-rds-recommended-import-method\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/itips.krsw.biz\\\/wp-content\\\/uploads\\\/2019\\\/04\\\/amazon_1555423788.png\",\"keywords\":[\"amazon\",\"AWS\",\"MySQL\"],\"articleSection\":[\"DB\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/itips.krsw.biz\\\/en\\\/aws-rds-recommended-import-method\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/itips.krsw.biz\\\/en\\\/aws-rds-recommended-import-method\\\/\",\"url\":\"https:\\\/\\\/itips.krsw.biz\\\/en\\\/aws-rds-recommended-import-method\\\/\",\"name\":\"Recommended way of moving DB in AWS(RDS) - ITips\u30b7\u30b9\u30c6\u30e0\u30bd\u30ea\u30e5\u30fc\u30b7\u30e7\u30f3\u30ba\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/itips.krsw.biz\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/itips.krsw.biz\\\/en\\\/aws-rds-recommended-import-method\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/itips.krsw.biz\\\/en\\\/aws-rds-recommended-import-method\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/itips.krsw.biz\\\/wp-content\\\/uploads\\\/2019\\\/04\\\/amazon_1555423788.png\",\"datePublished\":\"2019-05-09T13:36:21+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/itips.krsw.biz\\\/#\\\/schema\\\/person\\\/981ee81393a64c1b43f0b62d91998f0c\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/itips.krsw.biz\\\/en\\\/aws-rds-recommended-import-method\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/itips.krsw.biz\\\/en\\\/aws-rds-recommended-import-method\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/itips.krsw.biz\\\/en\\\/aws-rds-recommended-import-method\\\/#primaryimage\",\"url\":\"https:\\\/\\\/itips.krsw.biz\\\/wp-content\\\/uploads\\\/2019\\\/04\\\/amazon_1555423788.png\",\"contentUrl\":\"https:\\\/\\\/itips.krsw.biz\\\/wp-content\\\/uploads\\\/2019\\\/04\\\/amazon_1555423788.png\",\"width\":1280,\"height\":1159},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/itips.krsw.biz\\\/en\\\/aws-rds-recommended-import-method\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u30db\u30fc\u30e0\",\"item\":\"https:\\\/\\\/itips.krsw.biz\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Recommended way of moving DB in AWS(RDS)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/itips.krsw.biz\\\/#website\",\"url\":\"https:\\\/\\\/itips.krsw.biz\\\/\",\"name\":\"ITips\u30b7\u30b9\u30c6\u30e0\u30bd\u30ea\u30e5\u30fc\u30b7\u30e7\u30f3\u30ba\",\"description\":\"\u4e8b\u696d\u306b\u3068\u3063\u3066\u91cd\u8981\u306a\u60c5\u5831\u30b7\u30b9\u30c6\u30e0\u306e\u8ab2\u984c\u3092\u89e3\u6c7a\u3057\u307e\u3059\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/itips.krsw.biz\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/itips.krsw.biz\\\/#\\\/schema\\\/person\\\/981ee81393a64c1b43f0b62d91998f0c\",\"name\":\"ITips\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a89ef68c98cf6b05d7754a22b3e650bab179284eafbaa216db990ab3650cd763?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a89ef68c98cf6b05d7754a22b3e650bab179284eafbaa216db990ab3650cd763?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a89ef68c98cf6b05d7754a22b3e650bab179284eafbaa216db990ab3650cd763?s=96&d=mm&r=g\",\"caption\":\"ITips\"},\"description\":\"\u30b7\u30b9\u30c6\u30e0\u30a8\u30f3\u30b8\u30cb\u30a2\u3001AI\u30a8\u30f3\u30b8\u30cb\u30a2\u3068\u3001IT\u696d\u754c\u306710\u5e74\u4ee5\u4e0a\u50cd\u3044\u3066\u3044\u308b\u4e2d\u5805\u3002Python\u3068SQL\u304c\u5f97\u610f\u3002 System engineer AI engineer, Data scientist. Mid-carrier IT person. Good at Python and SQL.\",\"sameAs\":[\"https:\\\/\\\/www.pinterest.jp\\\/it_karasan\\\/\",\"https:\\\/\\\/x.com\\\/https:\\\/\\\/twitter.com\\\/karasan_itips\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Recommended way of moving DB in AWS(RDS) - ITips\u30b7\u30b9\u30c6\u30e0\u30bd\u30ea\u30e5\u30fc\u30b7\u30e7\u30f3\u30ba","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:\/\/itips.krsw.biz\/en\/aws-rds-recommended-import-method\/","og_locale":"en_US","og_type":"article","og_title":"Recommended way of moving DB in AWS(RDS) - ITips\u30b7\u30b9\u30c6\u30e0\u30bd\u30ea\u30e5\u30fc\u30b7\u30e7\u30f3\u30ba","og_description":"How can we apply data from local environment to RDS of AWS. Moving data is a problem for AWS beginne ...","og_url":"https:\/\/itips.krsw.biz\/en\/aws-rds-recommended-import-method\/","og_site_name":"ITips\u30b7\u30b9\u30c6\u30e0\u30bd\u30ea\u30e5\u30fc\u30b7\u30e7\u30f3\u30ba","article_published_time":"2019-05-09T13:36:21+00:00","og_image":[{"width":1280,"height":1159,"url":"https:\/\/itips.krsw.biz\/wp-content\/uploads\/2019\/04\/amazon_1555423788.png","type":"image\/png"}],"author":"ITips","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/karasan_itips","twitter_misc":{"Written by":"ITips","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/itips.krsw.biz\/en\/aws-rds-recommended-import-method\/#article","isPartOf":{"@id":"https:\/\/itips.krsw.biz\/en\/aws-rds-recommended-import-method\/"},"author":{"name":"ITips","@id":"https:\/\/itips.krsw.biz\/#\/schema\/person\/981ee81393a64c1b43f0b62d91998f0c"},"headline":"Recommended way of moving DB in AWS(RDS)","datePublished":"2019-05-09T13:36:21+00:00","mainEntityOfPage":{"@id":"https:\/\/itips.krsw.biz\/en\/aws-rds-recommended-import-method\/"},"wordCount":237,"commentCount":0,"image":{"@id":"https:\/\/itips.krsw.biz\/en\/aws-rds-recommended-import-method\/#primaryimage"},"thumbnailUrl":"https:\/\/itips.krsw.biz\/wp-content\/uploads\/2019\/04\/amazon_1555423788.png","keywords":["amazon","AWS","MySQL"],"articleSection":["DB"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/itips.krsw.biz\/en\/aws-rds-recommended-import-method\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/itips.krsw.biz\/en\/aws-rds-recommended-import-method\/","url":"https:\/\/itips.krsw.biz\/en\/aws-rds-recommended-import-method\/","name":"Recommended way of moving DB in AWS(RDS) - ITips\u30b7\u30b9\u30c6\u30e0\u30bd\u30ea\u30e5\u30fc\u30b7\u30e7\u30f3\u30ba","isPartOf":{"@id":"https:\/\/itips.krsw.biz\/#website"},"primaryImageOfPage":{"@id":"https:\/\/itips.krsw.biz\/en\/aws-rds-recommended-import-method\/#primaryimage"},"image":{"@id":"https:\/\/itips.krsw.biz\/en\/aws-rds-recommended-import-method\/#primaryimage"},"thumbnailUrl":"https:\/\/itips.krsw.biz\/wp-content\/uploads\/2019\/04\/amazon_1555423788.png","datePublished":"2019-05-09T13:36:21+00:00","author":{"@id":"https:\/\/itips.krsw.biz\/#\/schema\/person\/981ee81393a64c1b43f0b62d91998f0c"},"breadcrumb":{"@id":"https:\/\/itips.krsw.biz\/en\/aws-rds-recommended-import-method\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/itips.krsw.biz\/en\/aws-rds-recommended-import-method\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/itips.krsw.biz\/en\/aws-rds-recommended-import-method\/#primaryimage","url":"https:\/\/itips.krsw.biz\/wp-content\/uploads\/2019\/04\/amazon_1555423788.png","contentUrl":"https:\/\/itips.krsw.biz\/wp-content\/uploads\/2019\/04\/amazon_1555423788.png","width":1280,"height":1159},{"@type":"BreadcrumbList","@id":"https:\/\/itips.krsw.biz\/en\/aws-rds-recommended-import-method\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u30db\u30fc\u30e0","item":"https:\/\/itips.krsw.biz\/"},{"@type":"ListItem","position":2,"name":"Recommended way of moving DB in AWS(RDS)"}]},{"@type":"WebSite","@id":"https:\/\/itips.krsw.biz\/#website","url":"https:\/\/itips.krsw.biz\/","name":"ITips\u30b7\u30b9\u30c6\u30e0\u30bd\u30ea\u30e5\u30fc\u30b7\u30e7\u30f3\u30ba","description":"\u4e8b\u696d\u306b\u3068\u3063\u3066\u91cd\u8981\u306a\u60c5\u5831\u30b7\u30b9\u30c6\u30e0\u306e\u8ab2\u984c\u3092\u89e3\u6c7a\u3057\u307e\u3059","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/itips.krsw.biz\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/itips.krsw.biz\/#\/schema\/person\/981ee81393a64c1b43f0b62d91998f0c","name":"ITips","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/a89ef68c98cf6b05d7754a22b3e650bab179284eafbaa216db990ab3650cd763?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/a89ef68c98cf6b05d7754a22b3e650bab179284eafbaa216db990ab3650cd763?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a89ef68c98cf6b05d7754a22b3e650bab179284eafbaa216db990ab3650cd763?s=96&d=mm&r=g","caption":"ITips"},"description":"\u30b7\u30b9\u30c6\u30e0\u30a8\u30f3\u30b8\u30cb\u30a2\u3001AI\u30a8\u30f3\u30b8\u30cb\u30a2\u3068\u3001IT\u696d\u754c\u306710\u5e74\u4ee5\u4e0a\u50cd\u3044\u3066\u3044\u308b\u4e2d\u5805\u3002Python\u3068SQL\u304c\u5f97\u610f\u3002 System engineer AI engineer, Data scientist. Mid-carrier IT person. Good at Python and SQL.","sameAs":["https:\/\/www.pinterest.jp\/it_karasan\/","https:\/\/x.com\/https:\/\/twitter.com\/karasan_itips"]}]}},"_links":{"self":[{"href":"https:\/\/itips.krsw.biz\/wp-json\/wp\/v2\/posts\/755","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/itips.krsw.biz\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/itips.krsw.biz\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/itips.krsw.biz\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/itips.krsw.biz\/wp-json\/wp\/v2\/comments?post=755"}],"version-history":[{"count":1,"href":"https:\/\/itips.krsw.biz\/wp-json\/wp\/v2\/posts\/755\/revisions"}],"predecessor-version":[{"id":756,"href":"https:\/\/itips.krsw.biz\/wp-json\/wp\/v2\/posts\/755\/revisions\/756"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/itips.krsw.biz\/wp-json\/wp\/v2\/media\/666"}],"wp:attachment":[{"href":"https:\/\/itips.krsw.biz\/wp-json\/wp\/v2\/media?parent=755"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/itips.krsw.biz\/wp-json\/wp\/v2\/categories?post=755"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/itips.krsw.biz\/wp-json\/wp\/v2\/tags?post=755"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}