Stack Overflow
Stack Overflow

Questions tagged [amazon-rds]

Amazon Relational Database Service (Amazon RDS) is a web service that makes it easy to set up, operate, and scale a relational database in the cloud.

Amazon RDS (Relational Database Service) is an online storage web service offered by Amazon Web Services. Amazon RDS is a web service that makes it easy to set up, operate, and scale a relational database in the cloud. It provides cost-efficient and resizable capacity while managing time-consuming database administration tasks, freeing you up to focus on your applications and business.

References

Related tags:

6750 questions
235
votes
19 answers

Access denied; you need (at least one of) the SUPER privilege(s) for this operation

So I try to import sql file into rds (1G MEM, 1 CPU). The sql file is like 1.4G mysql -h xxxx.rds.amazonaws.com -u user -ppass --max-allowed-packet=33554432 db < db.sql It got stuck at: ERROR 1227 (42000) at line 374: Access denied; you need (at…
kenpeter
  • 7,404
  • 14
  • 64
  • 95
136
votes
8 answers

What are the respective advantages/limitations of Amazon RDS vs. EC2 with MySQL?

I realize a couple of basic differences between the two, i.e. EC2 is going to be cheaper RDS I wouldn't have to do maintenance Other than those two, are there any advantages to running my database from RDS as opposed to a separate EC2 server…
Macgyver
  • 1,831
  • 2
  • 16
  • 19
135
votes
9 answers

"ERROR: must be member of role" When creating schema in PostgreSQL

I'm logged in with a superuser account and this is the process I'm doing: 1-> CREATE ROLE test WITH IN ROLE testroles PASSWORD 'testpasswd' 2-> CREATE SCHEMA AUTHORIZATION test The role is correctly created but I'm getting this error when trying to…
Ultranuke
  • 1,735
  • 2
  • 15
  • 21
131
votes
9 answers

MySQL/Amazon RDS error: "you do not have SUPER privileges..."

I'm attempting to copy my mysql database from an Amazon EC2 to an RDS: I successfully did a mysqldump of my database into my root folder using this: root@ip-xx-xx-xx-xx:~# mysqldump my_database -u my_username -p > my_database.sql Then I tried to…
tim peterson
  • 23,653
  • 59
  • 177
  • 299
122
votes
8 answers

Amazon RDS: Restore snapshot to existing instance

I have created a snapshot of my instance and made some unwanted changes in DB. Now I want to restore my instance from this snapshot. When I try to do it - it creates me one more instance, additionally to the one I have. I specify "DB Instance…
SmxCde
  • 5,053
  • 7
  • 25
  • 45
104
votes
2 answers

How does Amazon RDS backup/snapshot actually work?

I am an Amazon RDS customer and am experiencing daily amazon RDS write latency spikes, corresponding roughly to the backup window. I will also see spikes at the end of a snapshot (case in point: running a snapshot takes appx 1 hour, and in the final…
esilver
  • 27,713
  • 23
  • 122
  • 168
99
votes
14 answers

AWS: can't connect to RDS database from my machine

The EC2 instance/live web can connect just fine to the RDS database. But when I want to debug the code in my local machine, I can't connect to the database and got this error: OperationalError: (2003, "Can't connect to MySQL server on…
Aminah Nuraini
  • 18,120
  • 8
  • 90
  • 108
92
votes
4 answers

How to export database from Amazon RDS MySQL instance to local instance?

AWS documentation has this page that talks about importing and exporting data from MySQL server, but it's mostly about import. The only thing I see in their documentation is a way to export 5.6 data using replication, which is documented here. I was…
Srini K
  • 3,315
  • 10
  • 37
  • 47
89
votes
7 answers

download RDS snapshot

I recently downgraded my EC2 instance. I can no longer connect to RDS. I think it might be that the internal IP is different and now the logins are attached to that specific IP. I haven't been able to figure it out. I would like to be able to…
William
  • 1,295
  • 1
  • 10
  • 19
87
votes
5 answers

Amazon RDS (postgres) connection limit?

I've searched the web and browsed the RDS docs, yet I can't seem to find an open connection limit. For what it's worth, I'm planning on using the new Postgres flavor of RDS, but I suppose an answer from the mySQL side of the house would be…
cs44
  • 1,210
  • 1
  • 9
  • 11
81
votes
7 answers

Exporting a table from Amazon RDS into a CSV file

I have a MySQL database running in Amazon RDS, and I want to know how to export an entire table to CSV format. I currently use MySQL server on Windows to query the Amazon database, but when I try to run an export I get an error, probably because…
Kenny
  • 1,131
  • 1
  • 9
  • 12
73
votes
5 answers

Creating A New MySQL User In Amazon RDS Environment

I need to create a new MySQL user with limited permission on an existing Amazon RDS instance. After encountering a couple error messages I was sort of able to do this using the official MySQL Administrator tool and the user now appears in the list.…
Dan
  • 1,450
  • 3
  • 12
  • 18
72
votes
10 answers

Can't connect to RDS instance from EC2 instance

From EC2 instance i-78a8df00, I'm trying to connect to RDS instance mysql.************.us-east-1.rds.amazonaws.com. They are both in the U.S. East region. I added the security group of EC2 instance (sg-********) to the RDS security group, but that…
Mark Shust at M.academy
  • 6,300
  • 4
  • 32
  • 50
69
votes
2 answers

AWS RDS Provisioned IOPS really worth it?

As I understand it, RDS Provisioned IOPS is quite expensive compared to standard I/O rate. In Tokyo region, P-IOPS rate is 0.15$/GB, 0.12$/IOP for standard deployment. (Double the price for Multi-AZ deployment...) For P-IOPS, the minimum required…
Jee Seok Yoon
  • 4,716
  • 9
  • 32
  • 47
68
votes
4 answers

Amazon RDS running out of freeable memory. Should I be worried?

I have an Amazon RDS instance. Freeable Memory has been declining since setup over 1-2 weeks, starting from 15GB of memory down to about 250MB. As it has dropped this low in the last days, it has started to resemble a sawtooth pattern where Freeable…
william tell
  • 4,352
  • 6
  • 23
  • 27
1
2 3
…
99 100