there is not a need to alter the table in chunks as this did not cause the mysql has gone away error