Designing a database structure for huge sets of form data
Have 'real' columns for a few of the fields -- the ones that you are likely to search or filter on.  Throw the rest (or, simply, all) of the fields into a big JSON string as another column.  Perhaps MEDIUMTEXT.