I have (well, stole from here no doubt) the following command that updates column widths. It works in my old 2.6 systems, but not in the new 5.4. Can you help update it for 5.4?
Code: Select all
echo "use nagios;alter table nagios_servicestatus modify output varchar(1024) not null;alter table nagios_servicestatus modify long_output varchar(1024) not null;alter table nagios_servicestatus modify perfdata varchar(1024);" | mysql –pnagiosxi