Illuminate\Database\QueryException : SQLSTATE[HY000]: General error: 1813 Tablespace for table

Question

Am using Laravel 5.6

I Tried to migrate purchases table for my project
When i tried to migrate and it's showing Table Space error.

General error: 1813 Tablespace for table 'jshop.purchases' exists. Please DISCARD the tablespace before IMPORT.

Migrate Code Below :

Schema::create('purchases', function (Blueprint $table) {
        $table->increments('id');
        $table->integer("product_price");
        $table->integer("product_qty");
        $table->unsignedInteger('invoice_id');
        $table->unsignedInteger('product_id');
        $table->unsignedInteger('weight_id');
        $table->timestamps();
        $table->foreign("invoice_id")->references('id')->on('invoices');
        $table->foreign("product_id")->references('id')->on('products');
        $table->foreign("weight_id")->references('id')->on('weights');
    });

invoice,products,weights table are valid in my database.

Error Message Image Below : Migration Error image Link How to solve this ?

Full Migration Code Image

Refer this question https://stackoverflow.com/questions/15694168/error-tablespace-for-table-xxx-exists-please-discard-the-tablespace-before-imp — Gihan Lakshan, Oct 02 '18 at 06:24
@sanduniYW sir when am trying to put all code its warning me about length of code. That's why i shared image link below https://i.stack.imgur.com/yeH83.jpg please open this. — Ripon Uddin, Oct 02 '18 at 06:31
please put the relevant code in the question as text and not an image. this question becomes less useful if the image link goes down... — bunbun, Oct 02 '18 at 06:40
@bunbun sir at first i added every single code of this migration. But stack authority showing some error that's y i have to re-edit this code — Ripon Uddin, Oct 02 '18 at 06:58

sanduniYW · Answer 1 · 2018-10-02T07:03:49.030

8

try this:

php artisan migrate:refresh

if it is not solve this error try this:

Go to mysql/data/database_name /tablename.ibd file and delete it manually. after this try your command php artisan migrate

edited Oct 02 '18 at 07:03

answered Oct 02 '18 at 06:22

sanduniYW

723
11
19

sir... still facing this problem . :( – Ripon Uddin Oct 02 '18 at 06:59
you use xampp or wamp? – sanduniYW Oct 02 '18 at 07:00
xampp at windows 10 Operating system – Ripon Uddin Oct 02 '18 at 07:01
try above solution – sanduniYW Oct 02 '18 at 07:04
sir it's not work ... when i create new database with different name and migrate this . And its work now. Thank you so much for your help sir... your suggestion really good – Ripon Uddin Oct 03 '18 at 04:38
deleting database_name folder inside mysql solved it. – beck Jan 10 '22 at 14:19

score 8 · Answer 2 · answered Apr 12 '19 at 00:49

8

Drop the database and create a new one.

answered Apr 12 '19 at 00:49

Sajjad Aljileezi

734
7
9

Although this suggestion is not the most elegant solution to the problem, in some cases, it will work. – ultrajohn Apr 12 '19 at 01:11
It sounds like: "Just reinstall Windows" )) – frops Oct 06 '20 at 08:42

score 1 · Answer 3 · answered Jun 13 '22 at 17:31

1

Your database is corrupted, do the followinf steps to fix it.

SETP 1. Drop the database and create a new one.

SETP 1. run the following command

php artisan migrate:refresh

answered Jun 13 '22 at 17:31

MUHINDO

788
6
10

score 0 · Answer 4 · answered Mar 04 '21 at 15:48

0

Locate where your database is and delete the table. Then run PHP artisan migrate This worked for me

answered Mar 04 '21 at 15:48

Tamale Collins

11
5

Illuminate\Database\QueryException : SQLSTATE[HY000]: General error: 1813 Tablespace for table

Am using Laravel 5.6

invoice,products,weights table are valid in my database.

4 Answers4