Hi friends, in this tutorial, you will learn how to resolve phpmyadmin #1709 – index column size too large. the maximum column size is 767 bytes. This is a specific error in MySQL that occurs at the time of importing sql file or an SQL table to the existing database or at the time of importing a new database as shown below
You cannot import any SQL file if this error exists. In order to resolve this error, please follow the below steps.
Also read, How to resolve #1118 – Row size too large (> 8126)
Steps to resolve phpmyadmin #1709 – index column size too large
Step 1:- Open your SQL file or SQL table in an editor such as sublime text, notepad++, notepad, etc.
Step 2:- Search for the below lines of code in your SQL file.
Step 3:- Replace the above lines of code with the below one.
Step 4:- Now, go to phpmyadmin and gain try to import the SQL file.
Finally, your SQL file will be imported successfully.
Also read, Select First 10 Rows from MySQL using PHP
Conclusion:- I hope this will help you to understand the concept and resolve the issue. If there is any doubt then please leave a comment below. Download wamp from here.