Level 70
Have you checked this discussion?
3 likes
Nov 17, 2019
9
Level 51
unable to import MySQL database in server(Shared Hosting)
hi In local it is working fine. While importing the MySQL database in the server, it is importing all the tables not importing the primary and foreign key relationships. In between, I am getting an error like this
#1071 - Specified key was too long; max key length is 767 bytes
Level 51
Ya I have seen so many discussion but unable to solve
Level 102
Any chance that you can use a newer version of mysql on your shared server?
Level 51
No, last week I have hosted then it was working. Then how to check the version of mysql?
Level 102
You can run this in your query editor
SHOW VARIABLES LIKE "%version%";
There is also a guide for phpmyadmin in this post if thats what you are using
https://www.liquidweb.com/kb/how-to-check-the-mysql-version/
Level 51
Ok I will try now
Level 51
@sinnbeck yes you are right there is a big difference in version
in local I am using 10.4.6 and in the server, I am using 5.5.61-38.13
how to solve this problem?
Level 102
Try asking your provider if its possible to upgrade to 5.7
Level 51
@sinnbeck thank you very much I will upgrade my MySQL server and check
Please or to participate in this conversation.