Reset Zend Server Statistics
I had to work this one out myself, hopefully this will save you some time:
sudo rm /usr/local/zend/var/db/statistics.db
sudo sqlite3 statistics.db < /usr/local/zend/share/statistics_sqlite_create_database.sql
sudo sqlite3 statistics.db < /usr/local/zend/share/stats_sqlite_fixtures.sql
I recently upgraded a Zend Server installation from version 5 to version 6, a side effect of this was that MySQL server was upgraded from version 5.1 to version 5.5.
I was then receiving the error message:
“Error Code: 1548 Cannot load from mysql.proc. The table is probably corrupted”
After rebuilding the databases and trying the mysql_upgrade -u root -p command, i discovered this is just a try to fix the core issue.
The true cause of the issue is that the table definition of mysql.proc is different
To fix the mysql.proc table just run the following command :
alter table mysql.proc modify comment text;