How to fix "Database (database.sqlite) does not exist." in Laravel?

Question

I'm studying laravel then I switched mysql from sqlite. I deleted the database.sqlite file, configure the database.php to mysql and .env file.

I'm having a error "Database (database.sqlite) does not exist". How to fix this error?

Please show contents of .env and /config/database.php files — Alexey Mezenin
– Alexey Mezenin, Commented May 17, 2016 at 15:14
@AlexeyMezenin I think Im connected but I have another error it says "SQLSTATE[HY000]: General error: 1 no such table: users (SQL: select * from "users")" — Van Adrian Cabrera
– Van Adrian Cabrera, Commented May 17, 2016 at 15:20
Run php artisan migrate command, it will create users table — Alexey Mezenin
– Alexey Mezenin, Commented May 17, 2016 at 15:27

Atrakeur · Accepted Answer · 2016-05-17 15:57:15Z

10

The sqlite driver doesn't create the database file if it doesn't exist.

The simple solution is to create an empty file just before migrating the database into it (filling the file with schemas and data)

Simply put, this command will fix it:

 touch database/database.sqlite

answered May 17, 2016 at 15:57

Atrakeur

4,2643 gold badges20 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Chaminda Chanaka Over a year ago

this is not working for me

OLIVIERS · Accepted Answer · 2018-12-03 09:28:16Z

2

You don't need anything in the .env file except the DB_CONNECTION key/value pair. When you are using SQLite, remove all of the following keys:

DB_HOST

DB_PORT

DB_DATABASE

DB_USERNAME

DB_PASSWORD

answered Dec 3, 2018 at 9:28

OLIVIERS

3843 silver badges15 bronze badges

3 Comments

Nico Haase Over a year ago

Can you explain further how this fixes the problem of a non-existing file?

OLIVIERS Over a year ago

In my case the file exists, and the proposed solution did not work for me. This is the solution that worked for me that I posted.

memoht Over a year ago

I've spent the last few hours trying to get MySQL, PostgreSQL and then Sqlite to work. Following this and removing the other items from the .ENV file is what actually worked. Thanks.

Codedreamer · Accepted Answer · 2021-07-16 13:29:33Z

0

If the above solution can not handle the current issue. click here

Issue with SQLite and Laravel on Heroku

answered Jul 16, 2021 at 13:29

Codedreamer

1,70216 silver badges13 bronze badges

Collectives™ on Stack Overflow

How to fix "Database (database.sqlite) does not exist." in Laravel?

3 Answers 3

1 Comment

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related