I am running Mysql on a Linux System ( Caos ).
Today when I am trying to create a procedure in it, I m facing the below
ERROR 1307 (HY000) at line 31: Failed to CREATE PROCEDURE
My OS version is :
Systemr-5:~ # cat /etc/issue
Welcome to SUSE Linux Enterprise Server 10 SP1 (x86_64) - Kernel \r (\l).
Kernel Version is : Server-5:~ # uname -a
Linux 5 184.108.40.206-0.12-smp #1 SMP Thu May 17 14:00:09 UTC 2007 x86_64
x86_64 x86_64 GNU/Linux
Mysql Version is very old :
System-5:~ # mysql --version
mysql Ver 14.12 Distrib 5.0.45, for unknown-linux-gnu (x86_64) using
After some research ,I know this error occurs due to loading mysql data
in previous version of mysql from new one.
I had this issue in the past & I solved the issue by mysql_upgrade
command but this time the issue still persists.
Any suggestions for solving the issue.
Thanks in Advance.