blocks|key|4407317|text|导入数据有两种方式：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4407318|4407319|mysqldump：如果您的数据小于1+1GB，您可以直接使用mysqldump命令将您的数据导入RDS.|ordered-list-item|offset|length|style|CODE|4407320|mysqlimport：如果您的数据大于1+1GB或其他任何格式，您可以将数据压缩成平面文件，然后使用sqlimport命令上传数据。|4407321|4407322|entityMap^0|0|0|0|9|0|0|B|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|P|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|Q|8|@$F|R|G|S|H|I]]|9|@]|A|$]]|$1|J|3|K|5|E|7|T|8|@$F|U|G|V|H|I]]|9|@]|A|$]]|$1|L|3|-4|5|6|7|W|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|X|8|@]|9|@]|A|$]]]|N|$]]

<p>There are two ways to import data : </p>

<ol>
<li><code>mysqldump</code> : If you data size is less than 1GB, you can directly make use of mysqldump command and import your data to RDS.</li>
<li><code>mysqlimport</code> : If your data size is more than 1GB or in any other format, you can compress the data into flat files and upload the data using sqlimport command.</li>
</ol>


blocks|key|738703|text|我找到了this+page+on+the+AWS+docs，它解释了如何使用mysqldump并通过管道将其导入到RDS实例中。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|738704|下面是它们的示例代码(在命令行/shell/ssh中使用)：mysqldump+acme+%7C+mysql+--host=hostname+--user=username+--password+acme|style|CODE|738705|其中acme是您要迁移的数据库，而hostname/username是来自您的RDS实例的数据库。|738706|你可以像连接一个普通的mysql服务器一样连接到RDS，只需确保将你的EC2+if添加到每个this+forum+posting的安全组中。|738707|我必须包含本地mysqldump的密码，所以我的命令最终看起来更像这样：mysqldump+--password=local_mysql_pass+acme+%7C+mysql+--host=hostname+--user=username+--password+acme|738708|顺便说一句，我刚刚把我的数据库移过来了。我使用this+reference+for+mysql+commands就像创建用户和授予权限一样。|738709|希望这能有所帮助！|738710|entityMap|0|LINK|mutability|MUTABLE|url|http://aws.amazon.com/articles/2933|1|https://forums.aws.amazon.com/thread.jspa?threadID=81774&tstart=0&messageID=309154#309154|2|http://www.ntchosting.com/mysql/create-user.html#How_to_add_a_new_account_in_MySQL_by_using_CREATE_USER^0|4|P|0|0|U|1Y|0|2|4|H|8|Q|8|0|1A|I|1|0|10|2Q|0|N|X|2|0|0^^$0|@$1|2|3|4|5|6|7|13|8|@]|9|@$A|14|B|15|1|16]]|C|$]]|$1|D|3|E|5|6|7|17|8|@$A|18|B|19|F|G]]|9|@]|C|$]]|$1|H|3|I|5|6|7|1A|8|@$A|1B|B|1C|F|G]|$A|1D|B|1E|F|G]|$A|1F|B|1G|F|G]]|9|@]|C|$]]|$1|J|3|K|5|6|7|1H|8|@]|9|@$A|1I|B|1J|1|1K]]|C|$]]|$1|L|3|M|5|6|7|1L|8|@$A|1M|B|1N|F|G]]|9|@]|C|$]]|$1|N|3|O|5|6|7|1O|8|@]|9|@$A|1P|B|1Q|1|1R]]|C|$]]|$1|P|3|Q|5|6|7|1S|8|@]|9|@]|C|$]]|$1|R|3|-4|5|6|7|1T|8|@]|9|@]|C|$]]]|S|$T|$5|U|V|W|C|$X|Y]]|Z|$5|U|V|W|C|$X|10]]|11|$5|U|V|W|C|$X|12]]]]

<p>I found <a href="http://aws.amazon.com/articles/2933" rel="noreferrer">this page on the AWS docs</a> which explains how to use mysqldump and pipe it into an RDS instance. </p>

<p>Here's their example code (use in command line/shell/ssh):
<code>mysqldump acme | mysql --host=hostname --user=username --password acme</code></p>

<p>where <code>acme</code> is the database you're migrating over, and <code>hostname</code>/<code>username</code> are those from your RDS instance.</p>

<p>You can connect to RDS as if it were a regular mysql server, just make sure to add your EC2 IPs to your security groups per <a href="https://forums.aws.amazon.com/thread.jspa?threadID=81774&amp;tstart=0&amp;messageID=309154#309154" rel="noreferrer">this forum posting</a>.</p>

<p>I had to include the password for the local mysqldump, so my command ended up looking more like this:
<code>mysqldump --password=local_mysql_pass acme | mysql --host=hostname --user=username --password acme</code></p>

<p>FWIW, I just completed moving my databases over. I used <a href="http://www.ntchosting.com/mysql/create-user.html#How_to_add_a_new_account_in_MySQL_by_using_CREATE_USER" rel="noreferrer">this reference for mysql commands</a> like creating users and granting permissions.</p>

<p>Hope this helps!</p>


blocks|key|738549|text|我是SqlYog工具的铁杆粉丝。它允许您连接到源数据库和目标数据库，并同步模式和/或数据。我也使用了SQLWave，但切换到了SqlYog。我已经很久没有换了，以至于我都记不清为什么换了。不管怎样，这就是我的两个观点。我知道有些人会反对我关于MySQL的Windows+GUI工具的建议。实际上，我非常喜欢SqlYog产品，以至于我在Wine上运行它(对我来说，Wine在Ubuntu上运行得天衣无缝)。此blog可能会有所帮助。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|738550|​|738551|📷|atomic|738552|738553|entityMap|0|LINK|mutability|MUTABLE|url|http://www.webyog.com/en/downloads.php|1|http://www.nerocode.com/|2|http://www.webyog.com/blog/2009/11/06/amazon-rds-the-beginners-guide/|3|IMAGE|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/cbb4873b55435e906b43bb057bdcb722.png|imageAlt^0|2|6|0|1E|7|1|5N|4|2|0|0|0|1|3|0|0^^$0|@$1|2|3|4|5|6|7|11|8|@]|9|@$A|12|B|13|1|14]|$A|15|B|16|1|17]|$A|18|B|19|1|1A]]|C|$]]|$1|D|3|E|5|6|7|1B|8|@]|9|@]|C|$]]|$1|F|3|G|5|H|7|1C|8|@]|9|@$A|1D|B|1E|1|1F]]|C|$]]|$1|I|3|E|5|6|7|1G|8|@]|9|@]|C|$]]|$1|J|3|-4|5|6|7|1H|8|@]|9|@]|C|$]]]|K|$L|$5|M|N|O|C|$P|Q]]|R|$5|M|N|O|C|$P|S]]|T|$5|M|N|O|C|$P|U]]|V|$5|W|N|X|C|$Y|Z|10|-4]]]]

<p>I'm a big fan of the <a href="http://www.webyog.com/en/downloads.php" rel="nofollow noreferrer">SqlYog</a> tool.  It lets you connect to your source and target databases and sync schema and/or data.  I've also used <a href="http://www.nerocode.com/" rel="nofollow noreferrer">SQLWave</a>, but switched to SqlYog.  Been so long since I made the switch that I can't remember exactly why I switched.  Anyway, that's my two cents.  I know some will object to my suggestion of Windows GUI tools for MySQL.  I actually like the SqlYog product so much that I run it from Wine (works flawlessly from Wine on Ubuntu for me). 
This <a href="http://www.webyog.com/blog/2009/11/06/amazon-rds-the-beginners-guide/" rel="nofollow noreferrer">blog</a> might be helpful.</p>

<p><img src="https://i.stack.imgur.com/rXAKb.png" alt="enter image description here"></p>


blocks|key|2806048|text|一篇GoSquared工程帖子的快速摘要：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2806049|配置%2B引导|2806050|2806051|选择维护窗口和备份窗口，当实例处于最低负载时选择多可用区或不选择多可用区(强烈建议对自动故障切换和RDS+instance|unordered-list-item|2806052|Configure安全组执行maintenance)|2806053|Boot操作，以便您的应用程序等可以访问新的实例|2806054|2806055|2806056|数据迁移%2B准备|2806057|2806058|启用绑定日志记录如果您尚未|ordered-list-item|2806059|在旧实例上运行mysqldump+--single-transaction+--master-data=2+-C+-q+dbname+-u+username+-p+>+backup.sql以转储当前数据|offset|length|style|CODE|2806060|运行mysql+-u+username+-p+-h+RDS_endpoint+DB_name+<+backup.sql以将数据导入到您的RDS实例中(这可能需要一段时间，具体取决于您的数据库大小)|2806061|<代码>H119同时，您当前的生产实例仍在处理查询-这就是backup.sql文件中的<代码>H221H122中的D20和binlogging的位置。在顶部有一行代码，看起来像是CHANGE+MASTER+TO+MASTER_LOG_FILE=’mysql-bin.000003′,+MASTER_LOG_POS=350789121;|2806062|Get+mysqlbinlog+/var/log/mysql/mysql-bin.000003+--start-position=350789121+--base64-output=NEVER+>+output.sql|2806063|Run+cat+output.sql+%7C+mysql+-h+RDS_endpoint+-u+username+-p+DB_name|2806064|Get+backup.sql作为一个SQL文件，通过在最新的output.sql文件末尾查找end_log_pos来更新它和新的日志位置。|2806065|获取自上一次output.sql以来的差异(如步骤6)，并重复步骤7%2B8。|2806066|2806067|实际的迁移|2806068|2806069|已准备好使用新的RDS实例快速部署您的所有应用程序|2806070|从旧实例上的RDS+end_log_pos获取最新的FLUSH+TABLES+WITH+READ+LOCK;以停止所有写入|2806071|开始使用新的RDS实例部署您的应用|2806072|从上面运行步骤6-8，使用对旧服务器的最后一次查询更新RDS实例|2806073|2806074|结论|2806075|使用这种方法，您将有少量的时间(取决于部署您的应用程序所需的时间%2B您的MySQL实例服务的写入数量-可能只有一两分钟)，从您的旧服务器拒绝写入，但您将拥有一致的迁移，而不会出现读取停机时间。|2806076|这里有一篇完整而详细的文章，解释了我们(GoSquared)如何以最小的停机时间(包括错误调试)迁移到RDS：https://engineering.gosquared.com/migrating-mysql-to-amazon-rds。|2806077|entityMap|0|LINK|mutability|MUTABLE|url|https://engineering.gosquared.com/migrating-mysql-to-amazon-rds^0|0|0|0|0|0|0|0|0|0|0|0|7|2F|0|2|1L|0|2H|26|0|4|2X|0|4|1P|0|4|A|U|A|1A|B|0|6|A|0|0|0|0|0|A|B|Q|S|0|0|0|0|0|0|1J|1R|0|0^^$0|@$1|2|3|4|5|6|7|22|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|23|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|24|8|@]|9|@]|A|$]]|$1|E|3|F|5|G|7|25|8|@]|9|@]|A|$]]|$1|H|3|I|5|G|7|26|8|@]|9|@]|A|$]]|$1|J|3|K|5|G|7|27|8|@]|9|@]|A|$]]|$1|L|3|-4|5|G|7|28|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|29|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|2A|8|@]|9|@]|A|$]]|$1|P|3|-4|5|6|7|2B|8|@]|9|@]|A|$]]|$1|Q|3|R|5|S|7|2C|8|@]|9|@]|A|$]]|$1|T|3|U|5|S|7|2D|8|@$V|2E|W|2F|X|Y]]|9|@]|A|$]]|$1|Z|3|10|5|S|7|2G|8|@$V|2H|W|2I|X|Y]]|9|@]|A|$]]|$1|11|3|12|5|6|7|2J|8|@$V|2K|W|2L|X|Y]]|9|@]|A|$]]|$1|13|3|14|5|S|7|2M|8|@$V|2N|W|2O|X|Y]]|9|@]|A|$]]|$1|15|3|16|5|S|7|2P|8|@$V|2Q|W|2R|X|Y]]|9|@]|A|$]]|$1|17|3|18|5|S|7|2S|8|@$V|2T|W|2U|X|Y]|$V|2V|W|2W|X|Y]|$V|2X|W|2Y|X|Y]]|9|@]|A|$]]|$1|19|3|1A|5|S|7|2Z|8|@$V|30|W|31|X|Y]]|9|@]|A|$]]|$1|1B|3|-4|5|6|7|32|8|@]|9|@]|A|$]]|$1|1C|3|1D|5|6|7|33|8|@]|9|@]|A|$]]|$1|1E|3|-4|5|6|7|34|8|@]|9|@]|A|$]]|$1|1F|3|1G|5|S|7|35|8|@]|9|@]|A|$]]|$1|1H|3|1I|5|S|7|36|8|@$V|37|W|38|X|Y]|$V|39|W|3A|X|Y]]|9|@]|A|$]]|$1|1J|3|1K|5|S|7|3B|8|@]|9|@]|A|$]]|$1|1L|3|1M|5|S|7|3C|8|@]|9|@]|A|$]]|$1|1N|3|-4|5|6|7|3D|8|@]|9|@]|A|$]]|$1|1O|3|1P|5|6|7|3E|8|@]|9|@]|A|$]]|$1|1Q|3|1R|5|6|7|3F|8|@]|9|@]|A|$]]|$1|1S|3|1T|5|6|7|3G|8|@]|9|@$V|3H|W|3I|1|3J]]|A|$]]|$1|1U|3|-4|5|6|7|3K|8|@]|9|@]|A|$]]]|1V|$1W|$5|1X|1Y|1Z|A|$20|21]]]]

<p>A quick summary of a GoSquared Engineering post:</p>

<h2>Configuration + Booting</h2>

<ul>
<li>Select a maintenance window and backup window when the instance will be at lowest load</li>
<li>Choose Multi-AZ or not (highly recommended for auto-failover and maintenance)</li>
<li>Boot your RDS instance</li>
<li>Configure security groups so your apps etc can access the new instance</li>
</ul>

<h2>Data migration + preparation</h2>

<ol>
<li>Enable binlogging if you haven't already</li>
<li>Run <code>mysqldump --single-transaction --master-data=2 -C -q dbname -u username -p &gt; backup.sql</code> on the old instance to take a dump of the current data</li>
<li>Run <code>mysql -u username -p -h RDS_endpoint DB_name &lt; backup.sql</code> to import the data into your RDS instance (this may take a while depending on your DB size)</li>
<li>In the meantime, your current production instance is still serving queries - this is where the <code>master-data=2</code> and binlogging comes in</li>
<li>In your backup.sql file, you'll have a line at the top that looks like <code>CHANGE MASTER TO MASTER_LOG_FILE=’mysql-bin.000003′, MASTER_LOG_POS=350789121;</code></li>
<li>Get the diff since <code>backup.sql</code> as an SQL file <code>mysqlbinlog /var/log/mysql/mysql-bin.000003 --start-position=350789121 --base64-output=NEVER &gt; output.sql</code></li>
<li>Run those queries on your RDS instance to update it <code>cat output.sql | mysql -h RDS_endpoint -u username -p DB_name</code></li>
<li>Get the new log position by finding <code>end_log_pos</code> at the end of the latest <code>output.sql</code> file.</li>
<li>Get the diff since the last <code>output.sql</code> (like step 6) and repeat steps 7 + 8.</li>
</ol>

<h2>The actual migration</h2>

<ol>
<li>Have all your apps ready to deploy quickly with the new RDS instance</li>
<li>Get the latest <code>end_log_pos</code> from <code>output.sql</code></li>
<li>Run <code>FLUSH TABLES WITH READ LOCK;</code> on the old instance to stop all writes</li>
<li>Start deploying your apps with the new RDS instance</li>
<li>Run steps 6-8 from above to update the RDS instance with the last queries to the old server</li>
</ol>

<h2>Conclusion</h2>

<p>Using this method, you'll have a small amount of time (depending on how long it takes to deploy your apps + how many writes your MySQL instance serves - probably only a minute or two) with writes being rejected from your old server, but you will have a consistent migration with no read downtime.</p>

<p>A full and detailed post explaining how we (GoSquared) migrated to RDS with minimal downtime (including error debugging) is available here: <a href="https://engineering.gosquared.com/migrating-mysql-to-amazon-rds" rel="nofollow">https://engineering.gosquared.com/migrating-mysql-to-amazon-rds</a>.</p>


blocks|key|1719388|text|我完全同意@SanketDangi。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1719389|有两种方法可以做到这一点，一种方法是建议使用mysqldump或mysqlimport。|offset|length|style|CODE|1719390|我见过在恢复云上的数据时产生问题的情况。|1719391|然而，现在在云上导入应用程序已经变得容易得多。您可以尝试通过ravello将DB服务器上传到公共云。|1719392|您可以使用ravello在Amazon上导入数据库服务器本身。|1719393|披露:我为ravello工作。|1719394|entityMap^0|0|M|9|W|B|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@$D|T|E|U|F|G]|$D|V|E|W|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|X|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|Y|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|Z|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|10|8|@]|9|@]|A|$]]|$1|P|3|-4|5|6|7|11|8|@]|9|@]|A|$]]]|Q|$]]

<p>I am completely agree with @SanketDangi.</p>

<p>There are two ways of doing this one way is as suggested using either <code>mysqldump</code> or <code>mysqlimport</code>.</p>

<p>I have seen cases where it creates problem while restoring data on cloud gets corrupt.</p>

<p>However importing applications on cloud has became much easier now a days. You try uploading your DB server on to public cloud through ravello.</p>

<p>You can import your database server itself on Amazon using ravello.</p>

<p>Disclosure: I work for ravello.</p>


blocks|key|738936|text|最简单的例子：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|738937|#+export+local+db+to+sql+file:
mysqldump+-uroot+-p+—-databases+qwe_db+>+qwe_db.sql

#+Now+you+can+edit+qwe_db.sql+file+and+change+db+name+at+top+if+you+want

#+import+sql+file+to+AWS+RDS:
mysql+--host=proddb.cfrnxxxxxxx.eu-central-1.rds.amazonaws.com+--port=3306+--user=someuser+-p+qwe_db+<+qwe_db.sql|code-block|syntax|javascript|738938|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

<p>Simplest example:</p>

<pre><code># export local db to sql file:
mysqldump -uroot -p —-databases qwe_db &gt; qwe_db.sql

# Now you can edit qwe_db.sql file and change db name at top if you want

# import sql file to AWS RDS:
mysql --host=proddb.cfrnxxxxxxx.eu-central-1.rds.amazonaws.com --port=3306 --user=someuser -p qwe_db &lt; qwe_db.sql
</code></pre>


blocks|key|738825|text|AWS+RDS+Customer+data+Import+guide+for+Mysql可在此处获得：http://aws.amazon.com/articles/2933|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|738826|Amazon+RDS创建包含要加载的数据的平面文件再次停止任何应用程序访问目标DB+Instance|738827|Create+a+DB+Snapshot|unordered-list-item|738828|
|738829|Disable+|738830|738831|自动备份|738832|738833|使用mysqlimport|738834|738835|Enable+automated+backups+|738836|738837|738838|738839|加载数据|738840|738841|entityMap|0|LINK|mutability|MUTABLE|url|http://aws.amazon.com/articles/2933^0|1F|Z|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|19|8|@]|9|@$A|1A|B|1B|1|1C]]|C|$]]|$1|D|3|E|5|6|7|1D|8|@]|9|@]|C|$]]|$1|F|3|G|5|H|7|1E|8|@]|9|@]|C|$]]|$1|I|3|J|5|6|7|1F|8|@]|9|@]|C|$]]|$1|K|3|L|5|H|7|1G|8|@]|9|@]|C|$]]|$1|M|3|J|5|6|7|1H|8|@]|9|@]|C|$]]|$1|N|3|O|5|H|7|1I|8|@]|9|@]|C|$]]|$1|P|3|J|5|6|7|1J|8|@]|9|@]|C|$]]|$1|Q|3|R|5|H|7|1K|8|@]|9|@]|C|$]]|$1|S|3|J|5|6|7|1L|8|@]|9|@]|C|$]]|$1|T|3|U|5|H|7|1M|8|@]|9|@]|C|$]]|$1|V|3|J|5|6|7|1N|8|@]|9|@]|C|$]]|$1|W|3|-4|5|H|7|1O|8|@]|9|@]|C|$]]|$1|X|3|J|5|6|7|1P|8|@]|9|@]|C|$]]|$1|Y|3|Z|5|H|7|1Q|8|@]|9|@]|C|$]]|$1|10|3|-4|5|6|7|1R|8|@]|9|@]|C|$]]|$1|11|3|-4|5|6|7|1S|8|@]|9|@]|C|$]]]|12|$13|$5|14|15|16|C|$17|18]]]]

<p>AWS RDS Customer data Import guide for Mysql is available here : <a href="http://aws.amazon.com/articles/2933" rel="nofollow">http://aws.amazon.com/articles/2933</a> </p>

<ul>
<li>Create flat files containing the data to be loaded</li>
<li>Stop any applications accessing the target DB Instance</li>
<li>Create a DB Snapshot</li>
<li>Disable Amazon RDS automated backups</li>
<li>Load the data using mysqlimport</li>
<li>Enable automated backups again</li>
</ul>


blocks|key|1722305|text|如果你正在使用终端，这就是对我有效的方法：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1722306|mysqldump+-u+local_username+-plocal_password+local_db_name+%7C+mysql+-h+myRDS-at-amazon.rds.amazonaws.com+-u+rds-username+-prds_password_xxxxx+remote_db_name|code-block|syntax|javascript|1722307|然后我使用MYSQL+WorkBench+(免费下载)来检查它是否工作，因为在按下submit之后，命令行是静态的，我可能已经将-v放在末尾来查看它的输出|1722308|注意：-p后面没有空格|1722309|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|P|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

<p>If you are using the terminal this is what worked for me:</p>

<pre><code>mysqldump -u local_username -plocal_password local_db_name | mysql -h myRDS-at-amazon.rds.amazonaws.com -u rds-username -prds_password_xxxxx remote_db_name
</code></pre>

<p>and then i used MYSQL WorkBench (free download) to check it was working because the command line was static after pressing submit, i could have probably put -v at end to see it's output</p>

<p>Note: there is no space after -p</p>


blocks|key|738979|text|以下是我所做并取得成功的步骤。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|738980|获取所需数据库的MySQLdump。|738981|mysqldump+-u用户名-p数据库名--单事务--快速--锁定-表=false>数据库名-备份-$(日期%2B%25F).sql|offset|length|style|BOLD|738982|(大多数情况下，不要忘记将用户名替换为根目录，以及要迁移到关系数据库的数据库的->+Db名称)|738983|出现提示后，请输入您的密码。|738984|完成后，从您的MySQL服务器登录到RDS实例(确保将安全组配置为允许从Ec2连接到RDS+)|738985|mysql+-h主机地址-P+3306+-u+rdsusername+-p|738986|(不要忘记将hostaddress替换为您的RDS实例的地址，将rdsusernmae替换为您的RDS实例的用户名，并在提示时提供密码)|738987|您可以在AWS控制台的RDS数据库下的连接和安全->端点和端口下找到该主机地址。|738988|登录后，使用MySQL命令创建数据库：|738989|create+database+databasename；\q|738990|在RDS中创建数据库后，导入在步骤1中创建的SQL文件：|738991|mysql+-h主机地址-u+rdsusername+-p数据库名<+backupfile.sql|738992|这应该会将SQL文件导入RDS，并将内容恢复到新数据库中。|738993|参考资料来源：https://k9webops.com/blog/migrate-an-existing-database-on-mysql-mariadb-to-an-already-running-rds-instance-on-the-aws/|738994|entityMap|0|LINK|mutability|MUTABLE|url|https://k9webops.com/blog/migrate-an-existing-database-on-mysql-mariadb-to-an-already-running-rds-instance-on-the-aws/^0|0|0|0|1R|0|0|0|0|0|0|0|0|0|V|0|0|0|1D|0|0|7|3A|0|0^^$0|@$1|2|3|4|5|6|7|1F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1G|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|1H|8|@$F|1I|G|1J|H|I]]|9|@]|A|$]]|$1|J|3|K|5|6|7|1K|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|1L|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|1M|8|@]|9|@]|A|$]]|$1|P|3|Q|5|6|7|1N|8|@]|9|@]|A|$]]|$1|R|3|S|5|6|7|1O|8|@]|9|@]|A|$]]|$1|T|3|U|5|6|7|1P|8|@]|9|@]|A|$]]|$1|V|3|W|5|6|7|1Q|8|@]|9|@]|A|$]]|$1|X|3|Y|5|6|7|1R|8|@$F|1S|G|1T|H|I]]|9|@]|A|$]]|$1|Z|3|10|5|6|7|1U|8|@]|9|@]|A|$]]|$1|11|3|12|5|6|7|1V|8|@$F|1W|G|1X|H|I]]|9|@]|A|$]]|$1|13|3|14|5|6|7|1Y|8|@]|9|@]|A|$]]|$1|15|3|16|5|6|7|1Z|8|@]|9|@$F|20|G|21|1|22]]|A|$]]|$1|17|3|-4|5|6|7|23|8|@]|9|@]|A|$]]]|18|$19|$5|1A|1B|1C|A|$1D|1E]]]]

<p>Here are the steps which i have done and had sucess.</p>

<h1>Take the MySQLdump of the needed database.</h1>

<p><strong>mysqldump -u username -p databasename --single-transaction --quick --lock-tables=false >databasename-backup-$(date +%F).sql</strong></p>

<p>( Dont forget to replace the username as root – most of the times, and databasename -> Db name of database which you are going to migrate to RDS )</p>

<h1>Once prompted, enter your password.</h1>

<p>Once done, login to the RDS Instance from your MySQL server ( Make sure the security groups are configured to allow the connection from Ec2 to RDS )</p>

<h1>mysql -h hostaddress -P 3306 -u rdsusername -p</h1>

<p>( Dont forget to replace hostaddress with the address of your RDS Instance and rdsusernmae with username for your RDS Instance, when prompted give the password too )</p>

<p>You find that hostaddress under – Connectivity &amp; security -> Endpoint &amp; port under RDS Database From AWS Console.</p>

<h1>Once logged in, create the database using MySQL commands :</h1>

<p><strong>create database databasename;
\q</strong></p>

<h1>Once Database is created in RDS, Import the SQL file created in Step 1 :</h1>

<p><strong>mysql -h hostaddress -u rdsusername -p databasename &lt; backupfile.sql</strong></p>

<p>This should import the SQL file to RDS and restore the contents into the new database.</p>

<p>Reference from : <a href="https://k9webops.com/blog/migrate-an-existing-database-on-mysql-mariadb-to-an-already-running-rds-instance-on-the-aws/" rel="nofollow noreferrer">https://k9webops.com/blog/migrate-an-existing-database-on-mysql-mariadb-to-an-already-running-rds-instance-on-the-aws/</a></p>


<p>How can I import existing MySQL database into Amazon RDS?</p>


Migrating existing database to Amazon RDS

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

如何将现有的MySQL数据库导入Amazon RDS？

问将现有数据库迁移到Amazon RDS
EN

回答 9

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问将现有数据库迁移到Amazon RDSEN

回答 9

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问将现有数据库迁移到Amazon RDS
EN