Laravel(xampp) Got error while trying to migrate real website to virtual host : SQLSTATE[42S02]

0
votes

I'm new at Laravel, I got this error when I tried to migrate a real website to XAMPP sevrer

The problem occured after I executed the following commands in the command line:

composer install 
php artisan key:generate
php artisan migrate

In Connection.php line 664:

SQLSTATE[42S02]: Base table or view not found: 1146 Table '<mydatabase>.setting' doesn't exist (SQL: select * from setting limit 1)

In Connection.php line 326:

SQLSTATE[42S02]: Base table or view not found: 1146 Table '<mydatabase>.setting' doesn't exist

1
mysqllaravel
Looks like you simply forgot to create tables in the database you're using. You may export the database from live database using any of the tools available on the internet and then import it. Create an SQL dump, then import it into your XAMPP server MySQL database. IIRC you have phpmyadmin available straight away. – Sergey Telshevsky
@SergeyTelshevsky Thx you so much. That's what I think so but my customer, he gave me only the "public" folder(I've ask him about the live database but he didn't give it to me T^T). Moreover, he told me that his dev. team can run the website without the live database, just create the new one!. So, I got this problem lol. However, thank you so much mannn – Werachai Tamboon
Did you configure the database connection in .env and config/database.php? – Manuel Eduardo Romero
@ManuelEduardoRomero yes,I tried. So, I don't have any clues to make it work. Thanks mannn – Werachai Tamboon
@SergeyTelshevsky Now, I got the exported database from live website. Everything seems to work fine,thank you anyway mannnn – Werachai Tamboon

1 Answers

0
votes

Now, I got the exported database from live website. Everything seems to work fine,thank you anyway mannnn