MySQL-Error: Table or view already exists

Question

I try to create a table in MySQL but I get the following error:

SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'migrations' already exists (SQL: create table migrations (id int unsigned not null auto_increment primary key, migration varchar(255) not null, batch int not null) default character set utf8 collate utf8_unicode_ci)

How can I fix this?

are you running `php artisan migrate` or `php artisan migrate:install` ? — lagbox, Dec 18 '17 at 05:51

score 1 · Answer 1 · answered Dec 18 '17 at 05:35

1

Try

php artisan migrate:fresh

Or

Manually empty the database and including the migrations table and then try migrating again.

answered Dec 18 '17 at 05:35

Sapnesh Naik

11,011
7
63
98

Actually i cannot do fresh or refresh. Bcz it is a live database. – Hashan Dec 18 '17 at 05:40

score 0 · Answer 2 · answered Dec 18 '17 at 14:07

0

Try this

php artisan migrate:refresh

may i hope this work.

answered Dec 18 '17 at 14:07

Niket Joshi

739
5
23

MySQL-Error: Table or view already exists

2 Answers2