issue : #1118 - Row size too large. The maximum row size for the database table type not consider the BLOB or TEXT data type, other than remaining database types total row size is below 65535. If it exceeds these size, it shows the below error
The total size of all fields in the database table is more than the limit 65535. So this reason you are getting this error.
How to get the sizes of the tables of a MySQL database?
SQL : SHOW table status from <mydatabasename>;
Based on the table status you can easily fixed this issue.
The total size of all fields in the database table is more than the limit 65535. So this reason you are getting this error.
How to get the sizes of the tables of a MySQL database?
SQL : SHOW table status from <mydatabasename>;
Based on the table status you can easily fixed this issue.
No comments:
Post a Comment