Artisan command not to lose data from database

Question

Hello I am starting to work with Laravel 5 and I am having a problem when I run the migrate commands the data is lost in the database, this is expected?

the command php artisan migrate works on the first call and the others php artisan refresh and php artisan reset causes database data to be lost, there is some specific command for it?

Answer 1

If you make changes like adding/deleting a column from some table it is recommended to create a new Migration similar to this one

<?php 

use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class AddColumnOwnerToLikes extends Migration
{
    /**
      * Run the migrations.
      *
      * @return void
    */
    public function up()
    {
        Schema::table('likes' , function(Blueprint $table){
        $table->integer('user_id');
    });

}

    /**
      * Reverse the migrations.
      *
      * @return void
    */
    public function down()
    {
     //
    }

}

after creating Migration run the command:

php artisan migrate

soon after the execution your new column will be created or deleted.

With the commands:

php artisan migrate:refresh
php artisan migrate:reset

data will be deleted as all tables will be deleted and recreated