I'm loving using appfog to host my fuel app. Trouble comes when it's time to run a migration.
What I have tried:
Use tunnel to connect to the production database, edit the development configuration to connect to the tunnel and run migrations locally... couldn't get the drivers to connect to the appfog tunnel FAIL...couldn't connect, suspect it's something to do with the required TCP parameter
Take the app down, quickly dump the db to sql with the tunnel. spin it up locally run the migration and then send the sql back up via the tunnel
enable mysql logging on the dev machine. Run the migration. Cut and paste the sql into mysql via the tunnel once again.
I've resorted to the last one :( ... Does anyone have a solution to this?