sqlite database is empty after migrate

out of the box is 'database' => storage_path('database.sqlite'), ... there is no database_path unless you have created it

Also, it should be in a place that is writeable, ie, the storage folder

Finally, your .env is not being used at all since you don't defer to values from there in your config file.

Thanks. I've created a new database.sqlite in storage and updated database.php, but the database is still empty. This is after rolling back the migration and then migrating again.

Do I need to define 'storage_path' anywhere, or is that already defined? (sorry, I'm new to Laravel!)

I've tried (from Jeffrey's video)

     'sqlite' => [
            'driver' => 'sqlite',
            'database' => storage_path().'database.sqlite',
            'prefix' => '',
        ],

and

'sqlite' => [
            'driver' => 'sqlite',
            'database' => storage_path('database.sqlite'),
            'prefix' => '',
        ],

Out of the box these days it is

        'sqlite' => [
            'driver' => 'sqlite',
            'database' => env('DB_DATABASE', database_path('database.sqlite')),
            'prefix' => '',
        ],

and do

    'default' => env('DB_CONNECTION', 'sqlite'),

and make sure to initialise a file in the shell

touch database/database.sqlite

not sure if you have to make sure it's world writable which you'd do by issuing the command

chmod 777 database/database.sqlite

and when migrating, make sure you're doing it within wherever you environment is. Within your vagrant VM for example if you're running your environment within there

That didn't work either unfortunately. I'm migrating inside the vagrant VM. I wonder if there's something wrong with the way I set up homestead? I might start from scratch and see.

This post is over a year old but I just came across the same situation Philb was. Well the solution (which at least worked for me) is to edit conf/database.php as follows; 'default' => env('DB_CONNECTION', 'sqlite'), to 'default' => 'sqlite', and then remove any databse connection code blocks in your .env file.