Yii automatic db migrations

php database-migration yii
Wizzard picture Wizzard · Oct 18, 2011 · Viewed 9.2k times · Source

I have setup my first db migration using the built in migration tools of yii, and locally i can run

./yiic migrate

I can see it say "this migration needs to run" and press Y and it runs and works fine.

When i deploy my site, I can automatically run that command but not pass the Y

Is there a command or url i can hit to upgrade the db without logging in and pressing Y?

Answer

ajsharma picture ajsharma · Oct 18, 2011

Yes, use the command: ./yiic migrate --interactive=0 and it will run without prompting you.

See http://www.yiiframework.com/doc/guide/1.1/en/database.migration#use-command-line-options for more details.

Related questions

Access denied for user 'homestead'@'localhost' (using password: YES)

I'm on a Mac OS Yosemite using Laravel 5.0. While in my local environment, I run php artisan migrate I keep getting : Access denied for user 'homestead'@'localhost' (using password: YES) Configuration Here is my .env APP_ENV=local APP_DEBUG=…

Read More
Dropping column with foreign key Laravel error: General error: 1025 Error on rename

I've created a table using migration like this: public function up() { Schema::create('despatch_discrepancies', function($table) { $table->increments('id')->unsigned(); $table->integer('pick_id')->unsigned(); $table->foreign('pick_id')->references(…

Read More
Make column not nullable in a Laravel migration

I'm writing a migration to make certain columns in a table nullable right now. For the down function, I of course want to make those columns not nullable again. I looked through the schema builder docs, but couldn't see a …

Read More