laravel 8 manually deleted tables cant be generated from migration

Question

I manually deleted my all tables now i want ot re-migrate my tables. but it shows this error

Base table or view not found: 1146 Table 'mymedia.categories' doesn't exist (SQL: select * from categories where categories.deleted_at is null order by id asc)

I tried these functions php artisan migrate php artisan migrate --force php artisan migrate:reset php artisan migrate:refresh

but problem does not solve! please help me

Hi , You can use this command php artisan migrate:fresh. Run it if you are in localhost , donot use this command on live server , when tables have some data. — Assad Yaqoob, Sep 30 '21 at 08:09

score 1 · Answer 1 · answered Sep 30 '21 at 08:12

1

Run this command when you are in localhost and don't need data

php artisan migrate:fresh

If you have seeder then run

php artisan migrate:fresh --seed

Don't use these commands in live server when you have some data in live database

answered Sep 30 '21 at 08:12

Assad Yaqoob

792
1
6
16

I run these function but shows this error https://prnt.sc/1u76bwb – MicroWeb Technology Ltd Sep 30 '21 at 08:18
Screenshot is not available , can you send it again – Assad Yaqoob Sep 30 '21 at 08:19
https://drive.google.com/file/d/1h2LaDfTA749hiP6_Z6CWHNNoAAL1gGux/view?usp=sharing – MicroWeb Technology Ltd Sep 30 '21 at 08:22
This says that you are fetching records not migrating. – Assad Yaqoob Sep 30 '21 at 08:30
Can you show me the command which you run? – Assad Yaqoob Sep 30 '21 at 08:31
php artisan migrate:fresh --seed – MicroWeb Technology Ltd Sep 30 '21 at 08:38

score 0 · Answer 2 · answered Sep 30 '21 at 08:08

0

But for now try this

php artisan migrate:fresh

answered Sep 30 '21 at 08:08

Mostafa Hana

115
2
8

it is not working. shows this error https://drive.google.com/file/d/1h2LaDfTA749hiP6_Z6CWHNNoAAL1gGux/view?usp=sharing – MicroWeb Technology Ltd Sep 30 '21 at 08:23
Please add a screenshot for your migrations directory, and get me a screen shot for table anosundhan.categories – Mostafa Hana Sep 30 '21 at 08:25
my skype name is: mohiuddin3824 – MicroWeb Technology Ltd Sep 30 '21 at 08:45
1

Thanks Mostafa Hana. You solved my problem by skype. – MicroWeb Technology Ltd Sep 30 '21 at 09:58
You welcome, sir – Mostafa Hana Sep 30 '21 at 10:00

laravel 8 manually deleted tables cant be generated from migration

2 Answers2