Glad to hear that my package is being used!
I've just played around with the migrations and I'm planning to add support for Google Cloud SQL. Still have some issues to resolve, mostly configuration options.
Anyway I did the following and was able to run migrations on Google Cloud SQL:
'mysql' => array( 'driver' => 'mysql', 'unix_socket'=> '/cloudsql/gaeAppId:cloudSqlInstanceName' 'host' => '', 'database' => 'databaseName', 'username' => 'root', 'password' => '', 'charset' => 'utf8', 'collation' => 'utf8_unicode_ci', 'prefix' => '', ),
'mysql' => array( 'driver' => 'mysql', 'host' => 'XXX.XXX.XXX.XXX', // The IPv4 address of the Cloud SQL Instance, see step 4. 'database' => 'databaseName', 'username' => 'root', 'password' => 'password', // The password for 'root' user, see step 2. 'charset' => 'utf8', 'collation' => 'utf8_unicode_ci', 'prefix' => '', ),
Of course using environment files '.env.php' (production) and '.env.local.php' (local) to store credentials is preferred.
Now you should be able to run the migrations in local environment and access your DB from the application running on GAE.
This is a procedure for Laravel 4. Laravel 5 procedure should be similar, but will include several changes.
Both Laravel 4 and Laravel 5 packages will have Google Cloud SQL support in near future.
You might want to look here for some references and Q/A https://github.com/shpasser/GaeSupport/issues/6
Sign in to participate in this thread!
We'd like to thank these amazing companies for supporting us
The Laravel portal for problem solving, knowledge sharing and community building.