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.
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.