请就如何我的本地MySQL服务器迁移到云中。
目前我有Fedora Linux中和NAS通过以太网连接到它。 我相信,去了解它最好的办法是:
我是在正确的轨道? 我应该如何去这样做(1)。我到MySQL服务器的用户名和密码的访问,它只有1个数据库。我试图按照网上一些联系,但该命令似乎没有工作。
时(2)甚至可能吗?
最终目标是从本地服务器连接到数据库服务器上的AWS,并能够无缝地查询。
解决方案我已经做了类似的迁移,我认为你是在正确的轨道。
我应该如何去这样做(1)?
只要看看你的数据库的mysqldump和其存储在一个文件中,例如:
的mysqldump -h [主持人] -u [用户] -p [密码] [DBNAME] GT; dumpfilename.sql
是(2)甚至可能吗?
当然可以。您可以连接到MySQL的RDS实例,就像你连接到任何其他MySQL实例。主机名refered为在AWS管理控制台终点。
您已经创建了RDS实例,并设置安全组的一个,你就可以加载转储:
的mysql -h [终点] -u [用户] -p [密码] [DBNAME] LT; dumpfilename.sqlPlease advise on how to migrate my local mysql server to the cloud.
Currently I have a Fedora linux box and a NAS attached to it via ethernet. I believe the best way to go about it is :
Am I on the right track ? How should I go about doing (1). I have a username and password based access to the mysql server and it has only 1 database. I tried to follow a few links on the net but the commands did not seem to work.
Is (2) even possible ?
The end goal is to connect from local servers to DB server on AWS and be able to query seamlessly.
解决方案I've done similar migrations and I think you're on the right track.
"How should I go about doing (1)?"
Just take a mysqldump of your DB and store it in a file, e.g.:
mysqldump -h [host] -u [user] -p[password] [dbname] > dumpfilename.sql
"Is (2) even possible ?"
Absolutely. You can connect to a MySQL RDS instance just like you would connect to any other MySQL instance. The host name is refered to as "endpoint" in the AWS Management Console.
One you've created the RDS instance and setup the security group, you're ready to load the dump:
mysql -h [endpoint] -u [user] -p[password] [dbname] < dumpfilename.sql
更多推荐
试图迁移本地MySQL服务器到AWS
发布评论