Sunday, 17 April 2016

MySQL alter query getting 'Row size too large' issue ? issue : #1118

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.

No comments:

Post a Comment