Category Archives: MySQL

Zend Server 5 to 6 mysql 5.1 to 5.5 fix

By | MySQL, Software Development, Zend, Zend Server | No Comments

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;

Zend Server CE on OSX 10.6 Snow Leopard

By | MySQL, PHP | No Comments

When I installed Zend Server CE on OSX 10.6 Snow Leopard the admin interface failed, the following fixed the issue :

1. Download this: Watchdog update

2. Backup watchdog with the command

sudo mv /usr/local/zend/bin/watchdog /usr/local/zend/bin/watchdogOLD

3. Extract the new watchdog to /usr/local/zend/bin/ (I used the go to folder in finder, if you can view hidden files)

4. Run the following command to restart the Zend server

sudo /usr/local/zend/bin/ restart

Autostart Zend Core on Ubuntu

By | MySQL, PHP, Platform, Unix/Linux | No Comments

This is the 2nd time I have had to search for starting up Zend Core automatically on Ubuntu Workstation, so here is the answer:

First change the permissions of /etc/rc.local by opening a terminal window (Applications|Accessories|Terminal) and enter the following command:

sudo chmod 777 /etc/rc.local

Then open this file with the text editor (Applications|Accessories|Text Editor) and put the following text before the exit 0 command

cd /usr/local/Zend/Core/mysql && ./bin/safe_mysqld &
/usr/local/Zend/apache2/bin/apachectl start &

Zend Core, PHP and MySQL should now all start automaticaly at boot time.