importing MySQL database in shared hosting

Question

I am importing a MySQL database in shared hosting but I am unable to import the structure of tables properly. After importing, for all tables, there are no primary and foreign keys are coming only data is imported. In between, I will get an error like

1071 - Specified key was too long; max key length is 767 bytes

Does this answer your question? laravel migration Specified key was too long; max key length is 767 bytes — dvr
– dvr, Commented Nov 18, 2019 at 5:49
Does this answer your question? #1071 - Specified key was too long; max key length is 767 bytes — Dilip Hirapara
– Dilip Hirapara, Commented Nov 18, 2019 at 5:49
No, I have tried this. I am unable to import the MySQL database completely. — matheen ulla
– matheen ulla, Commented Nov 18, 2019 at 5:59

Kenneth Sunday · Accepted Answer · 2019-11-18 05:55:51Z

1

add this to you AppServiceProvider.

use Schema;

then add this to boot() function

Schema::defaultStringLength(191);

However if you really want to maximize the 255 VARCHAR default length of your database. you need to manage your database setting first.

answered Nov 18, 2019 at 5:55

Kenneth Sunday

8957 silver badges14 bronze badges

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

2 Comments

Kenneth Sunday Over a year ago

if 255 link doesn't matter to you. you can add the schema setting to your AppServiceProvider class.

Kenneth Sunday Over a year ago

what mysql version are you using. i'll guess . its Mysql 8 ?

Collectives™ on Stack Overflow

importing MySQL database in shared hosting

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related