Amazon AWS Mysql Database FullPosted: August 31, 2012
Arrrgghhhh our web site decided to fill the 5GB database it uses !!!!!!!
When you use the AWS console you get the following error
The specified database instance is currently in the storage-full state. The only modification permitted on a database instance in this state is an increase …”
You have to use the RDS command line tools, you can see how to install them in my riveting post 🙂 Change the max_allowed_packet Amazon RDS
Once installed and working make a note of the database instance either using the management console or use
Issue this command to increase the size of the database to 10GB, XXXXXXXXX is the database instance name
rds-modify-db-instance XXXXXXXX --allocated-storage 10 --apply-immediately
Once the process was started it took about 10 minutes for the database to increase in size and be back on line.
Good luck with yours !!!!