[eluser]theseamusjames[/eluser]
I just succeeded in doing this. Here's what I did to make it work:
1. I created an RDS DB, setting the security group to CIDR/IP. Instead of using the IP they suggest below that box, I went to whatsmyip.org and used what I saw there, putting "/32" on the end of it. ** THIS IS VERY IMPORTANT **
2. I downloaded a fresh phpMyAdmin and put it under /admin in my local web root folder (I run MAMP for a localhost).
3. I copied my config.inc.php file from my MAMP installation and edited it to include my RDS server address for $cfg['Servers'][$i]['host']. I set $cfg['Servers'][$i]['auth_type'] = 'http' and then set$cfg['Servers'][$i]['user'] and $cfg['Servers'][$i]['password'] respectively to the settings I made when I set up the DB.
4. I opened localhost:8888/admin and voila! There was my new RDS server.
5. I uploaded our existing database.
6. To integrate with CI, I changed my database config file to include my RDS host name, username, and pw.
BANG! It worked!!
Now, keep in mind that if you want to do this for your production server, you're going to need a static IP and you'll have to add a new security group that includes that IP address.
For us, the next step is to move to EC2 for hosting with the load balancer, and I believe all that will include is changing the security group to EC2 for the DB to work properly.
(All of this is because we've gotten too big! We had an epic crash two days ago that cost us a good chunk of money, hence the switchover)
