I am trying to setup a test database and a live database using seperate MySQL instances running on Amazon RDS.

This would theoretically keep live and test data seperate, and allow changes to be made to the test database configuration that could later be applied to the live database configuration.

I have previously written a MySQL script for changing database tables, although I am unsure whether this is the best way to do an update, since it requires manual creation and execution of scripts.

Is there a better way to manage the deployment of database changes in MySQL using RDS?

There exists the snapshot and restore snapshot features, although I am not planning to migrate data, so it would be a configuration only migration.